Looker supports a wide range of SQL database dialects and continues to improve the feature implementations for existing dialect options as well as add new dialects. Because our modeling layer, LookML, builds on top of the in-database features available, some dialects allow for a more powerful implementation than others.
Looker has two support levels for dialects based on a dialect’s native feature set and the level of demand by Looker users:
Supported: A dialect that is fully supported by Looker. Looker is committed to improving this dialect implementation, and will fix issues based on severity and demand. Looker runs exhaustive tests against this dialect at least weekly to ensure quality.
Integration: A dialect that is partially supported. Looker is able to connect to this dialect, but there are no commitments to improve implementation, fix issues, or regularly run tests against the dialect.
For the dialects whose value of JDBC Driver Installed? is No, the needed JDBC JAR file is not bundled with the Looker JAR files. For customer-hosted installations of Looker, you must configure the driver for use with Looker as described on the Unpackaged JDBC drivers documentation page.
Database configuration instructions
Instructions are available in the documentation or in the Community Forums for these SQL dialects:
In the current Looker release, Looker also connects with the following dialects. Contact your Looker analyst for assistance.
After you configure your database to work with Looker, you’re ready to connect Looker to your database.