Microsoft Azure SQL Database

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:

CREATE LOGIN looker WITH PASSWORD = 'some_password_here'; USE MyDatabase; CREATE USER looker FOR LOGIN looker; GO

Looker requires rights to detect and stop currently running queries, through the following permissions:

KILL DATABASE CONNECTION VIEW DATABASE STATE

To grant these permissions, run the following:

GRANT KILL DATABASE CONNECTION TO looker; GRANT VIEW DATABASE STATE to looker;

Temp Schema Setup

Create a schema owned by the Looker user:

CREATE SCHEMA looker_scratch AUTHORIZATION looker;

Feature Support

Looker’s ability to provide some features depends on whether the database dialect can support them.

In the current Looker release, Microsoft Azure SQL Database supports the following Looker features:

Next Steps

After completing the database configuration, you can connect to the database from Looker using these directions.