Skip to content
Lucas Lessa
Voltar para as notícias
SnowflakeGAImpacto: Médio

Declarative Semantic Views Management with DCM Projects

The DEFINE SEMANTIC VIEW command in DCM Projects is generally available to declaratively manage semantic views.

O que mudou

The DEFINE SEMANTIC VIEW command in DCM Projects is now generally available, enabling declarative management of semantic view definitions in Snowflake. You can centrally control tables, relationships, facts, dimensions, metrics, AI instructions, and verified queries.### Use casesImagine you need to version and control the evolution of your semantic layer alongside other Snowflake objects automatically.- Manage semantic view definitions via code.- Standardize metrics and dimensions across environments.- Integrate AI rules and verified queries into project control.### How to use```sql DEFINE SEMANTIC VIEW MY_CATALOG.MY_SCHEMA.MY_SEMANTIC_VIEW TABLES = ( MY_CATALOG.MY_SCHEMA.SALES ) DIMENSIONS = ( SALE_DATE ) METRICS = ( TOTAL_SALES ) ;

1. DCM Projects reads the semantic view definition statement.
2. Snowflake creates or alters the semantic view according to the declared state.
3. Associated tables, dimensions, and metrics are managed by the project.### Limitations and requirementsThis feature is Generally Available (GA). Underlying object rules and limitations apply as documented for DCM Projects.
Ver nota oficial do Snowflake

DCM Projects DEFINE SEMANTIC VIEW (General availability)

Resumo e explicação gerados por IA a partir da release note oficial. Em caso de dúvida, a documentação oficial da plataforma prevalece.

Relacionadas