In-database analytic models

Preview: This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA products and features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

If you encounter an issue during the Public Preview of Looker support of in-database analytic models, report it to [e-mail].

Looker integrates with in-database analytic models, such as BigQuery Graph and Snowflake semantic views, so that you can keep your semantic definitions consistent across Looker and other BI tools, applications, or workloads that interface with your data warehouse.

Looker lets you manage your in-database analytic models by using the Looker IDE, version control, and Continuous Integration. You can also use Looker to query your analytic models that are stored in your database directly from Looker Explores and visualizations.

Looker supports three methods for integrating with in-database analytic models:

1. Database-managed analytic model: You first define and manage the analytic model directly in your database, and then you create a LookML view in Looker so that you can use Looker to query your analytic model. For information about setting up a database-managed analytic model, see the sql_analytic_model_name documentation page.

2. Looker-managed, SQL-based analytic model: You define the analytic model in Looker by using SQL commands. Looker then creates and maintains the analytic model within your database based on your definition. For information about setting up a Looker-managed, SQL-based analytic model, see the SQL-based derived analytic models section on the derived_analytic_model documentation page.

3. Looker-managed, LookML-based derived analytic model: You define the analytic model by referencing an existing LookML Explore with the model_source parameter. Looker automatically translates your Explore topology, joins, dimensions, and measures into database-native analytic model DDL statements (such as node and edge tables for BigQuery Graph or tables and relationships for Snowflake semantic views) and creates and manages the model in your database. For information about setting up Looker-managed, LookML-based derived analytic model, see the LookML-based derived analytic models section on the derived_analytic_model documentation page.