Microsoft Azure SQL Data Warehouse was rebranded to Microsoft Azure Synapse Analytics. Starting in 7.12, Looker is updated to reflect the change.
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:
Looker’s ability to provide some features depends on whether the database dialect can support them.
In the current Looker release, 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.