home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Looker documentation will be moving to cloud.google.com in mid-2022!
All the information you rely on will be migrated and all docs.looker.com URLs will be redirected to the appropriate page.
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 must be authorized to detect and stop currently running queries, which requires the following permissions:

KILL DATABASE CONNECTION VIEW DATABASE STATE

To grant these permissions, run the following command:

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;

Adding the connection

Use the Looker interface to configure the database connection: In the Admin section of Looker, select Connections, and then select New Connection.

Enter the connection information. The majority of the settings are common to most database dialects and are described on the Connecting Looker to your database documentation page. The following fields have additional information that applies to Microsoft Azure SQL Database:

Click on Test These Settings to verify that the connection to your database is successful. See the Testing database connectivity documentation page for troubleshooting information.

Click Add Connection to save the connection.

Feature support

For Looker to support some features, your database dialect must also support them.

In Looker 22.10, 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 the directions on the Connecting Looker to your database documentation page.

Top