User Guide Getting Started Help Center Documentation Community Training
Database Configuration Instructions

This page provides links for configuring your database to work with Looker. You’ll create a Looker database user and assign the appropriate permissions. In many cases, you’ll also configure a Looker temp database to provide derived table functionality.

Setting Up Your Database

Instructions are available in the documentation or in the Community Forums for these SQL dialects:

In the current Looker release, Looker also supports at least the following dialects. Looker regularly adds additional dialect support, and this list may not contain every option. Contact your Looker Analyst for assistance.

  • Aster Data
  • Exasol
  • IBM Netezza
  • Microsoft Azure PostgreSQL
  • Oracle ADW
  • XtremeData

You can learn more about the levels of database dialect support in this Community topic.

The drivers for Actian Avalanche, DataVirtuality, Google Cloud Spanner, Teradata, and Vector are not bundled with the Looker JAR file. For customer-hosted installations of Looker, you must configure the driver for Actian Avalanche, DataVirtuality, Google Cloud Spanner, Teradata, or Vector.

Next Step

After you have configured your database to work with Looker you’re ready to connect Looker to your database.