Can Looker consume on premise SQL Data Warehouses?

I was just encountering on various DWs Looker could consume. Red shift, Google Query and Azure are all based on Cloud. But i wanted to conform if it can be used to connect even on premise SQL Data Warehouses?

Absolutely, Ram. We’re connected to our internal ERP database as well as our data warehouse (both on MS SQL). We connect with a JDBC connector via an SSH tunnel for security purposes. Overall very straight-forward. I see occasional ClientConnection issues from time to time, but feel that’s likely a challenge on our network side.

2 Likes

Great Ben! Thanks for sharing your input!