Integration & Code Generation Views

Views for semantic layer configuration, foreign key relationships, and generated SQL code.

VW_DATASOURCE_ACTIVE_ATTRIBUTES_SEMANTIC_LAYER

Active attributes configured for semantic layer views with complete transformation metadata.

Contents: Semantic layer configuration, view object names, transformation expressions, security policy settings, foreign key relationships, parent array information

Use cases: Semantic layer code generation, view configuration, integration workflows

---

VW_DATASOURCE_ACTIVE_ATTRIBUTES_GEN_AI_SEMANTIC_MODEL

Attributes configured for Cortex Analyst semantic model generation.

Contents: Gen AI semantic model configuration, W question categories, semantic model expressions, reference column names, parent relationships, synonyms, comments

Use cases: Cortex Analyst semantic model generation, Gen AI integration, semantic model configuration

---

VW_DATASOURCE_RELATIONSHIPS_GEN_AI_SEMANTIC_MODEL

Relationships between tables for Cortex Analyst semantic model.

Contents: Relationship names/descriptions, left/right table names, join types, relationship types, foreign key columns, data types

Use cases: Cortex Analyst semantic model generation, relationship configuration

---

VW_DATASOURCE_QUERIES_GEN_AI_SEMANTIC_MODEL

Verified queries for Cortex Analyst semantic model onboarding.

Contents: Query names/questions, query SQL, query order, onboarding question flags

Use cases: Cortex Analyst onboarding, query management

---

VW_DATASOURCE_FOREIGN_KEYS

Foreign key relationships for array tables.

Contents: Array identification, foreign key attribute names, foreign key alias names, security policy inclusion (INCLUDE_COLUMN_IN_ROW_ACCESS_POLICY), row access policy order (ROW_ACCESS_POLICY_COLUMN_ORDER)

Use cases: Foreign key configuration review, relationship management, integration workflows

Example Query:

Example SQL

SELECT 
    datasource_name,
    polymorphic_attribute_name,
    parent_attribute_name,
    foreign_key_alias_name,
    INCLUDE_COLUMN_IN_ROW_ACCESS_POLICY
FROM core.vw_datasource_foreign_keys
WHERE datasource_id = 'your-datasource-id';

---

VW_DATASOURCE_RELATIONSHIPS

Array relationship configuration.

Contents: Relationship names/descriptions, relationship types (many_to_one, one_to_one), join types (left_outer, inner), left/right table names, foreign key columns

Use cases: Relationship configuration review, documentation

---

VW_DATASOURCE_ALIASED_FOREIGN_KEYS

Foreign keys with custom alias names for semantic layer integration.

Contents: Foreign key attribute names, foreign key alias names, data types

Use cases: Semantic layer integration, foreign key alias management

Note: This view is not explicitly defined in the codebase; may be referenced but not created.

---

VW_DATASOURCE_SQL_CODE

Generated SQL code blocks for data sources.

Contents: Version number, code blocks by object type (sql_code_object_type), complete SQL code (sql_code), code order (sql_code_order), deployment status, deployment datetime

Use cases: Code review, code export, version comparison

---

VW_DATASOURCE_SQL_CODE_SUMMARY

Summary of generated SQL code.

Contents: Code generation summary, object counts by type (sql_code_object_type), last version number, last created datetime

Use cases: Code generation overview, quick reference

---

VW_DATASOURCE_CODE_BLOCK

Aggregated code blocks for a data source version.

Contents: Version number, complete code block (all objects concatenated), code order

Use cases: Complete code export, version comparison

Note: This view is not explicitly defined in the codebase; may be referenced but not created.