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 two 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 this up, see the sql_analytic_model_name documentation page.

2. Looker-managed, SQL-based analytic model: You first 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 this up, see the derived_analytic_model documentation page.