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
Looker authenticates to your database using SQL Database Authentication. Using a domain account is not supported.
To create an account, run the following commands, changing
some_password_here to a unique, secure password:
Looker requires rights to detect and stop currently running queries, through the following permissions:
To grant these permissions, 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.0, Microsoft Azure SQL Database supports the following Looker features:
After completing the database configuration, you can connect to the database from Looker using these directions.