User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
Microsoft Azure SQL Data Warehouse

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 SQL Data Warehouse 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;

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 Data Warehouse supports the following Looker features:

Next Steps

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

Top