Looker introduction
- Quick start pages
- Personalizing Looker
- Keyboard shortcuts
  - Keyboard shortcuts in Looker
- Video tutorials
- Looker glossary
  - Looker glossary
- Looker error catalog
  - Looker error catalog

Latest features
- Latest features

Find and organize content
- Finding and viewing content
- Organizing content
  - Organizing and managing access to content
  - Presenting content with boards
- For developers and admins
  - Deleted and unused content for admins

Send and share content
- Sharing data overview
  - Sharing data
- One-time sharing
- Periodic sharing
- Conditional sharing
- Video tutorials
  - Video tutorials

Retrieve and chart data

Create dashboards and reports
- Creating saved reports (Looks)
  - Saving and editing Looks
- Creating user-defined dashboards
- Creating and managing LookML dashboards

Get ready for development

Write LookML

Use embedding, the API, and the extension framework

Set up and administer Looker
- Getting started with setup and admin
- Installation and maintenance
- Setting up a database connection
- Admin tutorials
- Admin panel reference

Looker mobile application
- Looker mobile application

Microsoft Azure SQL database

Go to Database Configuration Instructions

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

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

In Looker 21.16, 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.