Integration & Code Generation Views

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

VW_DATASOURCE_ACTIVE_ATTRIBUTES_SEMANTIC_LAYER

Purpose: 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

Purpose: 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 and comments

Use Cases:

• Cortex Analyst semantic model generation

• Gen AI integration

• Semantic model configuration

---

VW_DATASOURCE_RELATIONSHIPS_GEN_AI_SEMANTIC_MODEL

Purpose: Relationships between tables for Cortex Analyst semantic model.

Contents:

• Relationship names and descriptions

• Left and right table names

• Join types and relationship types

• Foreign key columns

• Data types

Use Cases:

• Cortex Analyst semantic model generation

• Relationship configuration

---

VW_DATASOURCE_QUERIES_GEN_AI_SEMANTIC_MODEL

Purpose: Verified queries for Cortex Analyst semantic model onboarding.

Contents:

• Query names and questions

• Query SQL

• Query order

• Onboarding question flags

Use Cases:

• Cortex Analyst onboarding

• Query management

---

VW_DATASOURCE_FOREIGN_KEYS

Purpose: Foreign key relationships for array tables.

Contents:

• Array identification

• Foreign key attribute names

• Foreign key alias names

• Security policy inclusion

• Row access policy 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

Purpose: Array relationship configuration.

Contents:

• Relationship names and descriptions

• Relationship types (many-to-one, one-to-one)

• Join types (left outer, inner)

Use Cases:

• Relationship configuration review

• Documentation

---

VW_DATASOURCE_ALIASED_FOREIGN_KEYS

Purpose: 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

---

VW_DATASOURCE_SQL_CODE

Purpose: Generated SQL code blocks for data sources.

Contents:

• Version number

• Code blocks by object type

• Complete SQL code

Use Cases:

• Code review

• Code export

• Version comparison

---

VW_DATASOURCE_SQL_CODE_SUMMARY

Purpose: Summary of generated SQL code.

Contents:

• Code generation summary

• Object counts

• Version information

Use Cases:

• Code generation overview

• Quick reference

---

VW_DATASOURCE_CODE_BLOCK

Purpose: 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