Encrypting Network Traffic
Looker strongly recommends encrypting network traffic between the Looker application and your database. To learn more about using SSL encryption, see the Microsoft documentation.
Users and Security
First, connect to the master database on your server with your server admin login:
Connect to your Microsoft Azure SQL Data Warehouse database and create a database user:
Looker requires rights to detect and stop currently running queries, through the following permissions:
To grant these permissions, run the following:
Depending on the Azure SQL Database tier being used, you may also need to explicitly grant the
VIEW DATABASE STATEpermission.
VIEW DATABASE STATE permission, run the following:
Temp Schema Setup
Create a schema owned by the Looker user:
Looker’s ability to provide some features depends on whether the database dialect can support them.
In the current Looker release, Microsoft Azure SQL Data Warehouse supports the following Looker features:
After completing the database configuration, you can connect to the database from Looker using these directions.