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
Microsoft Azure Synapse Analytics

add

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:

CREATE LOGIN looker WITH PASSWORD = '';

Connect to your Microsoft Azure Synapse Analytics database and create a database user:

CREATE USER looker FOR LOGIN looker;

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

ALTER ANY CONNECTION VIEW SERVER STATE

To grant these permissions, run the following:

GRANT CONTROL ON DATABASE::userDatabase TO looker;

Depending on the Microsoft Azure Synapse Analytics tier being used, you may also need to explicitly grant the VIEW DATABASE STATE permission.

To grant VIEW DATABASE STATE permission, run the following:

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 Synapse Analytics supports the following Looker features:

Next Steps

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

Top