# Integration & Code Generation Views

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

{% code title="Example SQL" %}

```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';
```

{% endcode %}

***

## 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.