Get Started with Looker
- Looker’s Different Sections
- Personalizing Looker
  - Your User Account
- Keyboard Shortcuts
  - Keyboard Shortcuts in Looker
- Video Tutorials

Latest Features
- Updates for General Users
  - What’s New for Browsing and Exploring
- Full Release Notes

Find and Organize Content
- Finding and Viewing Content
- Organizing Content
  - Organizing with Spaces
- For Developers and Admins
  - Deleted and Unused Content for Admins

Send and Share Content
- Send and Share Content

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
- Development Basics
- SQL in Looker
- Creating and Editing Projects
- Git and Version Control
- Setting Up a Database
  Connection
- Video Tutorials
  - Video Tutorials

Write LookML

Use Embedding and the API
- Looker API
- Embedding

Set Up and Administer Looker
- Getting Started with Setup and Admin
- Installation and Maintenance
- Setting Up a Database
  Connection
- Admin Tutorials
- Admin Panel Reference

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.