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.
Database configuration instructions
Instructions are available for these SQL dialects:
Looker also connects with the following dialects. Contact your Looker analyst for assistance.
- IBM Netezza
After you configure your database to work with Looker, you're ready to connect Looker to your database.