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 Synapse Analytics 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 Microsoft Azure Synapse Analytics 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:
For Looker to support some features, your database dialect must also support them.
In Looker 21.6, Microsoft Azure Synapse Analytics supports the following Looker features:
After completing the database configuration, you can connect to the database from Looker using these directions.