SemanticView

Snowflake v2.10.0, Nov 22 25

Snowflake v2.10.0 published on Saturday, Nov 22, 2025 by Pulumi

Schema (JSON)

pulumi/pulumi-snowflake

Snowflake v2.10.0 published on Saturday, Nov 22, 2025 by Pulumi

Schema (JSON)

pulumi/pulumi-snowflake

Import

$ pulumi import snowflake:index/semanticView:SemanticView example '"<db_name>"."<schema_name>"."<semantic_view_name>"'

Note: Because the external changes for dimensions, facts, metrics, relationships, and tables are not currently handled, then import won’t populate these fields too.

Create SemanticView Resource

Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

Constructor syntax

new SemanticView(name: string, args: SemanticViewArgs, opts?: CustomResourceOptions);

@overload
def SemanticView(resource_name: str,
                 args: SemanticViewArgs,
                 opts: Optional[ResourceOptions] = None)

@overload
def SemanticView(resource_name: str,
                 opts: Optional[ResourceOptions] = None,
                 database: Optional[str] = None,
                 schema: Optional[str] = None,
                 tables: Optional[Sequence[SemanticViewTableArgs]] = None,
                 comment: Optional[str] = None,
                 dimensions: Optional[Sequence[SemanticViewDimensionArgs]] = None,
                 facts: Optional[Sequence[SemanticViewFactArgs]] = None,
                 metrics: Optional[Sequence[SemanticViewMetricArgs]] = None,
                 name: Optional[str] = None,
                 relationships: Optional[Sequence[SemanticViewRelationshipArgs]] = None)

func NewSemanticView(ctx *Context, name string, args SemanticViewArgs, opts ...ResourceOption) (*SemanticView, error)

public SemanticView(string name, SemanticViewArgs args, CustomResourceOptions? opts = null)

public SemanticView(String name, SemanticViewArgs args)
public SemanticView(String name, SemanticViewArgs args, CustomResourceOptions options)

type: snowflake:SemanticView
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

Parameters

name string: The unique name of the resource.
args SemanticViewArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

resource_name str: The unique name of the resource.
args SemanticViewArgs: The arguments to resource properties.
opts ResourceOptions: Bag of options to control resource's behavior.

ctx Context: Context object for the current deployment.
name string: The unique name of the resource.
args SemanticViewArgs: The arguments to resource properties.
opts ResourceOption: Bag of options to control resource's behavior.

name string: The unique name of the resource.
args SemanticViewArgs: The arguments to resource properties.
opts CustomResourceOptions: Bag of options to control resource's behavior.

name String: The unique name of the resource.
args SemanticViewArgs: The arguments to resource properties.
options CustomResourceOptions: Bag of options to control resource's behavior.

Constructor example

The following reference example uses placeholder values for all input properties.

var semanticViewResource = new Snowflake.SemanticView("semanticViewResource", new()
{
    Database = "string",
    Schema = "string",
    Tables = new[]
    {
        new Snowflake.Inputs.SemanticViewTableArgs
        {
            TableAlias = "string",
            TableName = "string",
            Comment = "string",
            PrimaryKeys = new[]
            {
                "string",
            },
            Synonyms = new[]
            {
                "string",
            },
            Uniques = new[]
            {
                new Snowflake.Inputs.SemanticViewTableUniqueArgs
                {
                    Values = new[]
                    {
                        "string",
                    },
                },
            },
        },
    },
    Comment = "string",
    Dimensions = new[]
    {
        new Snowflake.Inputs.SemanticViewDimensionArgs
        {
            QualifiedExpressionName = "string",
            SqlExpression = "string",
            Comment = "string",
            Synonyms = new[]
            {
                "string",
            },
        },
    },
    Facts = new[]
    {
        new Snowflake.Inputs.SemanticViewFactArgs
        {
            QualifiedExpressionName = "string",
            SqlExpression = "string",
            Comment = "string",
            Synonyms = new[]
            {
                "string",
            },
        },
    },
    Metrics = new[]
    {
        new Snowflake.Inputs.SemanticViewMetricArgs
        {
            SemanticExpression = new Snowflake.Inputs.SemanticViewMetricSemanticExpressionArgs
            {
                QualifiedExpressionName = "string",
                SqlExpression = "string",
                Comment = "string",
                Synonyms = new[]
                {
                    "string",
                },
            },
            WindowFunction = new Snowflake.Inputs.SemanticViewMetricWindowFunctionArgs
            {
                OverClause = new Snowflake.Inputs.SemanticViewMetricWindowFunctionOverClauseArgs
                {
                    OrderBy = "string",
                    PartitionBy = "string",
                    WindowFrameClause = "string",
                },
                QualifiedExpressionName = "string",
                SqlExpression = "string",
            },
        },
    },
    Name = "string",
    Relationships = new[]
    {
        new Snowflake.Inputs.SemanticViewRelationshipArgs
        {
            ReferencedTableNameOrAlias = new Snowflake.Inputs.SemanticViewRelationshipReferencedTableNameOrAliasArgs
            {
                TableAlias = "string",
                TableName = "string",
            },
            RelationshipColumns = new[]
            {
                "string",
            },
            TableNameOrAlias = new Snowflake.Inputs.SemanticViewRelationshipTableNameOrAliasArgs
            {
                TableAlias = "string",
                TableName = "string",
            },
            ReferencedRelationshipColumns = new[]
            {
                "string",
            },
            RelationshipIdentifier = "string",
        },
    },
});

example, err := snowflake.NewSemanticView(ctx, "semanticViewResource", &snowflake.SemanticViewArgs{
	Database: pulumi.String("string"),
	Schema:   pulumi.String("string"),
	Tables: snowflake.SemanticViewTableArray{
		&snowflake.SemanticViewTableArgs{
			TableAlias: pulumi.String("string"),
			TableName:  pulumi.String("string"),
			Comment:    pulumi.String("string"),
			PrimaryKeys: pulumi.StringArray{
				pulumi.String("string"),
			},
			Synonyms: pulumi.StringArray{
				pulumi.String("string"),
			},
			Uniques: snowflake.SemanticViewTableUniqueArray{
				&snowflake.SemanticViewTableUniqueArgs{
					Values: pulumi.StringArray{
						pulumi.String("string"),
					},
				},
			},
		},
	},
	Comment: pulumi.String("string"),
	Dimensions: snowflake.SemanticViewDimensionArray{
		&snowflake.SemanticViewDimensionArgs{
			QualifiedExpressionName: pulumi.String("string"),
			SqlExpression:           pulumi.String("string"),
			Comment:                 pulumi.String("string"),
			Synonyms: pulumi.StringArray{
				pulumi.String("string"),
			},
		},
	},
	Facts: snowflake.SemanticViewFactArray{
		&snowflake.SemanticViewFactArgs{
			QualifiedExpressionName: pulumi.String("string"),
			SqlExpression:           pulumi.String("string"),
			Comment:                 pulumi.String("string"),
			Synonyms: pulumi.StringArray{
				pulumi.String("string"),
			},
		},
	},
	Metrics: snowflake.SemanticViewMetricArray{
		&snowflake.SemanticViewMetricArgs{
			SemanticExpression: &snowflake.SemanticViewMetricSemanticExpressionArgs{
				QualifiedExpressionName: pulumi.String("string"),
				SqlExpression:           pulumi.String("string"),
				Comment:                 pulumi.String("string"),
				Synonyms: pulumi.StringArray{
					pulumi.String("string"),
				},
			},
			WindowFunction: &snowflake.SemanticViewMetricWindowFunctionArgs{
				OverClause: &snowflake.SemanticViewMetricWindowFunctionOverClauseArgs{
					OrderBy:           pulumi.String("string"),
					PartitionBy:       pulumi.String("string"),
					WindowFrameClause: pulumi.String("string"),
				},
				QualifiedExpressionName: pulumi.String("string"),
				SqlExpression:           pulumi.String("string"),
			},
		},
	},
	Name: pulumi.String("string"),
	Relationships: snowflake.SemanticViewRelationshipArray{
		&snowflake.SemanticViewRelationshipArgs{
			ReferencedTableNameOrAlias: &snowflake.SemanticViewRelationshipReferencedTableNameOrAliasArgs{
				TableAlias: pulumi.String("string"),
				TableName:  pulumi.String("string"),
			},
			RelationshipColumns: pulumi.StringArray{
				pulumi.String("string"),
			},
			TableNameOrAlias: &snowflake.SemanticViewRelationshipTableNameOrAliasArgs{
				TableAlias: pulumi.String("string"),
				TableName:  pulumi.String("string"),
			},
			ReferencedRelationshipColumns: pulumi.StringArray{
				pulumi.String("string"),
			},
			RelationshipIdentifier: pulumi.String("string"),
		},
	},
})

var semanticViewResource = new SemanticView("semanticViewResource", SemanticViewArgs.builder()
    .database("string")
    .schema("string")
    .tables(SemanticViewTableArgs.builder()
        .tableAlias("string")
        .tableName("string")
        .comment("string")
        .primaryKeys("string")
        .synonyms("string")
        .uniques(SemanticViewTableUniqueArgs.builder()
            .values("string")
            .build())
        .build())
    .comment("string")
    .dimensions(SemanticViewDimensionArgs.builder()
        .qualifiedExpressionName("string")
        .sqlExpression("string")
        .comment("string")
        .synonyms("string")
        .build())
    .facts(SemanticViewFactArgs.builder()
        .qualifiedExpressionName("string")
        .sqlExpression("string")
        .comment("string")
        .synonyms("string")
        .build())
    .metrics(SemanticViewMetricArgs.builder()
        .semanticExpression(SemanticViewMetricSemanticExpressionArgs.builder()
            .qualifiedExpressionName("string")
            .sqlExpression("string")
            .comment("string")
            .synonyms("string")
            .build())
        .windowFunction(SemanticViewMetricWindowFunctionArgs.builder()
            .overClause(SemanticViewMetricWindowFunctionOverClauseArgs.builder()
                .orderBy("string")
                .partitionBy("string")
                .windowFrameClause("string")
                .build())
            .qualifiedExpressionName("string")
            .sqlExpression("string")
            .build())
        .build())
    .name("string")
    .relationships(SemanticViewRelationshipArgs.builder()
        .referencedTableNameOrAlias(SemanticViewRelationshipReferencedTableNameOrAliasArgs.builder()
            .tableAlias("string")
            .tableName("string")
            .build())
        .relationshipColumns("string")
        .tableNameOrAlias(SemanticViewRelationshipTableNameOrAliasArgs.builder()
            .tableAlias("string")
            .tableName("string")
            .build())
        .referencedRelationshipColumns("string")
        .relationshipIdentifier("string")
        .build())
    .build());

semantic_view_resource = snowflake.SemanticView("semanticViewResource",
    database="string",
    schema="string",
    tables=[{
        "table_alias": "string",
        "table_name": "string",
        "comment": "string",
        "primary_keys": ["string"],
        "synonyms": ["string"],
        "uniques": [{
            "values": ["string"],
        }],
    }],
    comment="string",
    dimensions=[{
        "qualified_expression_name": "string",
        "sql_expression": "string",
        "comment": "string",
        "synonyms": ["string"],
    }],
    facts=[{
        "qualified_expression_name": "string",
        "sql_expression": "string",
        "comment": "string",
        "synonyms": ["string"],
    }],
    metrics=[{
        "semantic_expression": {
            "qualified_expression_name": "string",
            "sql_expression": "string",
            "comment": "string",
            "synonyms": ["string"],
        },
        "window_function": {
            "over_clause": {
                "order_by": "string",
                "partition_by": "string",
                "window_frame_clause": "string",
            },
            "qualified_expression_name": "string",
            "sql_expression": "string",
        },
    }],
    name="string",
    relationships=[{
        "referenced_table_name_or_alias": {
            "table_alias": "string",
            "table_name": "string",
        },
        "relationship_columns": ["string"],
        "table_name_or_alias": {
            "table_alias": "string",
            "table_name": "string",
        },
        "referenced_relationship_columns": ["string"],
        "relationship_identifier": "string",
    }])

const semanticViewResource = new snowflake.SemanticView("semanticViewResource", {
    database: "string",
    schema: "string",
    tables: [{
        tableAlias: "string",
        tableName: "string",
        comment: "string",
        primaryKeys: ["string"],
        synonyms: ["string"],
        uniques: [{
            values: ["string"],
        }],
    }],
    comment: "string",
    dimensions: [{
        qualifiedExpressionName: "string",
        sqlExpression: "string",
        comment: "string",
        synonyms: ["string"],
    }],
    facts: [{
        qualifiedExpressionName: "string",
        sqlExpression: "string",
        comment: "string",
        synonyms: ["string"],
    }],
    metrics: [{
        semanticExpression: {
            qualifiedExpressionName: "string",
            sqlExpression: "string",
            comment: "string",
            synonyms: ["string"],
        },
        windowFunction: {
            overClause: {
                orderBy: "string",
                partitionBy: "string",
                windowFrameClause: "string",
            },
            qualifiedExpressionName: "string",
            sqlExpression: "string",
        },
    }],
    name: "string",
    relationships: [{
        referencedTableNameOrAlias: {
            tableAlias: "string",
            tableName: "string",
        },
        relationshipColumns: ["string"],
        tableNameOrAlias: {
            tableAlias: "string",
            tableName: "string",
        },
        referencedRelationshipColumns: ["string"],
        relationshipIdentifier: "string",
    }],
});

type: snowflake:SemanticView
properties:
    comment: string
    database: string
    dimensions:
        - comment: string
          qualifiedExpressionName: string
          sqlExpression: string
          synonyms:
            - string
    facts:
        - comment: string
          qualifiedExpressionName: string
          sqlExpression: string
          synonyms:
            - string
    metrics:
        - semanticExpression:
            comment: string
            qualifiedExpressionName: string
            sqlExpression: string
            synonyms:
                - string
          windowFunction:
            overClause:
                orderBy: string
                partitionBy: string
                windowFrameClause: string
            qualifiedExpressionName: string
            sqlExpression: string
    name: string
    relationships:
        - referencedRelationshipColumns:
            - string
          referencedTableNameOrAlias:
            tableAlias: string
            tableName: string
          relationshipColumns:
            - string
          relationshipIdentifier: string
          tableNameOrAlias:
            tableAlias: string
            tableName: string
    schema: string
    tables:
        - comment: string
          primaryKeys:
            - string
          synonyms:
            - string
          tableAlias: string
          tableName: string
          uniques:
            - values:
                - string

SemanticView Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

The SemanticView resource accepts the following input properties:

Database string: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Schema string: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Tables List<SemanticViewTable>
Comment string: Specifies a comment for the semantic view.
Dimensions List<SemanticViewDimension>
Facts List<SemanticViewFact>
Metrics List<SemanticViewMetric>
Name string: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Relationships List<SemanticViewRelationship>

Database string: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Schema string: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Tables []SemanticViewTableArgs
Comment string: Specifies a comment for the semantic view.
Dimensions []SemanticViewDimensionArgs
Facts []SemanticViewFactArgs
Metrics []SemanticViewMetricArgs
Name string: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Relationships []SemanticViewRelationshipArgs

database String: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
schema String: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
tables List<SemanticViewTable>
comment String: Specifies a comment for the semantic view.
dimensions List<SemanticViewDimension>
facts List<SemanticViewFact>
metrics List<SemanticViewMetric>
name String: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
relationships List<SemanticViewRelationship>

database string: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
schema string: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
tables SemanticViewTable[]
comment string: Specifies a comment for the semantic view.
dimensions SemanticViewDimension[]
facts SemanticViewFact[]
metrics SemanticViewMetric[]
name string: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
relationships SemanticViewRelationship[]

database str: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
schema str: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
tables Sequence[SemanticViewTableArgs]
comment str: Specifies a comment for the semantic view.
dimensions Sequence[SemanticViewDimensionArgs]
facts Sequence[SemanticViewFactArgs]
metrics Sequence[SemanticViewMetricArgs]
name str: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
relationships Sequence[SemanticViewRelationshipArgs]

database String: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
schema String: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
tables List<Property Map>
comment String: Specifies a comment for the semantic view.
dimensions List<Property Map>
facts List<Property Map>
metrics List<Property Map>
name String: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
relationships List<Property Map>

Outputs

All input properties are implicitly available as output properties. Additionally, the SemanticView resource produces the following output properties:

FullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
Id string: The provider-assigned unique ID for this managed resource.
ShowOutputs List<SemanticViewShowOutput>: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.

FullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
Id string: The provider-assigned unique ID for this managed resource.
ShowOutputs []SemanticViewShowOutput: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.

fullyQualifiedName String: Fully qualified name of the resource. For more information, see object name resolution.
id String: The provider-assigned unique ID for this managed resource.
showOutputs List<SemanticViewShowOutput>: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.

fullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
id string: The provider-assigned unique ID for this managed resource.
showOutputs SemanticViewShowOutput[]: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.

fully_qualified_name str: Fully qualified name of the resource. For more information, see object name resolution.
id str: The provider-assigned unique ID for this managed resource.
show_outputs Sequence[SemanticViewShowOutput]: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.

fullyQualifiedName String: Fully qualified name of the resource. For more information, see object name resolution.
id String: The provider-assigned unique ID for this managed resource.
showOutputs List<Property Map>: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.

Look up Existing SemanticView Resource

Get an existing SemanticView resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

public static get(name: string, id: Input<ID>, state?: SemanticViewState, opts?: CustomResourceOptions): SemanticView

@staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        comment: Optional[str] = None,
        database: Optional[str] = None,
        dimensions: Optional[Sequence[SemanticViewDimensionArgs]] = None,
        facts: Optional[Sequence[SemanticViewFactArgs]] = None,
        fully_qualified_name: Optional[str] = None,
        metrics: Optional[Sequence[SemanticViewMetricArgs]] = None,
        name: Optional[str] = None,
        relationships: Optional[Sequence[SemanticViewRelationshipArgs]] = None,
        schema: Optional[str] = None,
        show_outputs: Optional[Sequence[SemanticViewShowOutputArgs]] = None,
        tables: Optional[Sequence[SemanticViewTableArgs]] = None) -> SemanticView

func GetSemanticView(ctx *Context, name string, id IDInput, state *SemanticViewState, opts ...ResourceOption) (*SemanticView, error)

public static SemanticView Get(string name, Input<string> id, SemanticViewState? state, CustomResourceOptions? opts = null)

public static SemanticView get(String name, Output<String> id, SemanticViewState state, CustomResourceOptions options)

resources:  _:    type: snowflake:SemanticView    get:      id: ${id}

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

resource_name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

name: The unique name of the resulting resource.
id: The unique provider ID of the resource to lookup.
state: Any extra arguments used during the lookup.
opts: A bag of options that control this resource's behavior.

The following state arguments are supported:

Comment string: Specifies a comment for the semantic view.
Database string: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Dimensions List<SemanticViewDimension>
Facts List<SemanticViewFact>
FullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
Metrics List<SemanticViewMetric>
Name string: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Relationships List<SemanticViewRelationship>
Schema string: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
ShowOutputs List<SemanticViewShowOutput>: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.
Tables List<SemanticViewTable>

Comment string: Specifies a comment for the semantic view.
Database string: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Dimensions []SemanticViewDimensionArgs
Facts []SemanticViewFactArgs
FullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
Metrics []SemanticViewMetricArgs
Name string: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Relationships []SemanticViewRelationshipArgs
Schema string: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
ShowOutputs []SemanticViewShowOutputArgs: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.
Tables []SemanticViewTableArgs

comment String: Specifies a comment for the semantic view.
database String: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
dimensions List<SemanticViewDimension>
facts List<SemanticViewFact>
fullyQualifiedName String: Fully qualified name of the resource. For more information, see object name resolution.
metrics List<SemanticViewMetric>
name String: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
relationships List<SemanticViewRelationship>
schema String: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
showOutputs List<SemanticViewShowOutput>: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.
tables List<SemanticViewTable>

comment string: Specifies a comment for the semantic view.
database string: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
dimensions SemanticViewDimension[]
facts SemanticViewFact[]
fullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
metrics SemanticViewMetric[]
name string: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
relationships SemanticViewRelationship[]
schema string: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
showOutputs SemanticViewShowOutput[]: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.
tables SemanticViewTable[]

comment str: Specifies a comment for the semantic view.
database str: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
dimensions Sequence[SemanticViewDimensionArgs]
facts Sequence[SemanticViewFactArgs]
fully_qualified_name str: Fully qualified name of the resource. For more information, see object name resolution.
metrics Sequence[SemanticViewMetricArgs]
name str: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
relationships Sequence[SemanticViewRelationshipArgs]
schema str: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
show_outputs Sequence[SemanticViewShowOutputArgs]: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.
tables Sequence[SemanticViewTableArgs]

comment String: Specifies a comment for the semantic view.
database String: The database in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
dimensions List<Property Map>
facts List<Property Map>
fullyQualifiedName String: Fully qualified name of the resource. For more information, see object name resolution.
metrics List<Property Map>
name String: Specifies the identifier for the semantic view; must be unique within the schema. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
relationships List<Property Map>
schema String: The schema in which to create the semantic view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
showOutputs List<Property Map>: Outputs the result of SHOW SEMANTIC VIEWS for the given semantic view.
tables List<Property Map>

Supporting Types

SemanticViewDimension, SemanticViewDimensionArgs

QualifiedExpressionName string: Specifies a qualified name for the dimension, including the table name and a unique identifier for the dimension: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
SqlExpression string: The SQL expression used to compute the dimension.
Comment string: Specifies a comment for the dimension.
Synonyms List<string>: List of synonyms for the dimension.

QualifiedExpressionName string: Specifies a qualified name for the dimension, including the table name and a unique identifier for the dimension: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
SqlExpression string: The SQL expression used to compute the dimension.
Comment string: Specifies a comment for the dimension.
Synonyms []string: List of synonyms for the dimension.

qualifiedExpressionName String: Specifies a qualified name for the dimension, including the table name and a unique identifier for the dimension: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
sqlExpression String: The SQL expression used to compute the dimension.
comment String: Specifies a comment for the dimension.
synonyms List<String>: List of synonyms for the dimension.

qualifiedExpressionName string: Specifies a qualified name for the dimension, including the table name and a unique identifier for the dimension: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
sqlExpression string: The SQL expression used to compute the dimension.
comment string: Specifies a comment for the dimension.
synonyms string[]: List of synonyms for the dimension.

qualified_expression_name str: Specifies a qualified name for the dimension, including the table name and a unique identifier for the dimension: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
sql_expression str: The SQL expression used to compute the dimension.
comment str: Specifies a comment for the dimension.
synonyms Sequence[str]: List of synonyms for the dimension.

qualifiedExpressionName String: Specifies a qualified name for the dimension, including the table name and a unique identifier for the dimension: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
sqlExpression String: The SQL expression used to compute the dimension.
comment String: Specifies a comment for the dimension.
synonyms List<String>: List of synonyms for the dimension.

SemanticViewFact, SemanticViewFactArgs

QualifiedExpressionName string: Specifies a qualified name for the fact, including the table name and a unique identifier for the fact: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
SqlExpression string: The SQL expression used to compute the fact.
Comment string: Specifies a comment for the fact.
Synonyms List<string>: List of synonyms for the fact.

QualifiedExpressionName string: Specifies a qualified name for the fact, including the table name and a unique identifier for the fact: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
SqlExpression string: The SQL expression used to compute the fact.
Comment string: Specifies a comment for the fact.
Synonyms []string: List of synonyms for the fact.

qualifiedExpressionName String: Specifies a qualified name for the fact, including the table name and a unique identifier for the fact: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
sqlExpression String: The SQL expression used to compute the fact.
comment String: Specifies a comment for the fact.
synonyms List<String>: List of synonyms for the fact.

qualifiedExpressionName string: Specifies a qualified name for the fact, including the table name and a unique identifier for the fact: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
sqlExpression string: The SQL expression used to compute the fact.
comment string: Specifies a comment for the fact.
synonyms string[]: List of synonyms for the fact.

qualified_expression_name str: Specifies a qualified name for the fact, including the table name and a unique identifier for the fact: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
sql_expression str: The SQL expression used to compute the fact.
comment str: Specifies a comment for the fact.
synonyms Sequence[str]: List of synonyms for the fact.

qualifiedExpressionName String: Specifies a qualified name for the fact, including the table name and a unique identifier for the fact: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"".
sqlExpression String: The SQL expression used to compute the fact.
comment String: Specifies a comment for the fact.
synonyms List<String>: List of synonyms for the fact.

SemanticViewMetric, SemanticViewMetricArgs

SemanticExpression SemanticViewMetricSemanticExpression: Specifies a semantic expression for a metric definition. Cannot be used in combination with a window function.
WindowFunction SemanticViewMetricWindowFunction: Specifies a window function for a metric definition. Cannot be used in combination with a semantic expression.

SemanticExpression SemanticViewMetricSemanticExpression: Specifies a semantic expression for a metric definition. Cannot be used in combination with a window function.
WindowFunction SemanticViewMetricWindowFunction: Specifies a window function for a metric definition. Cannot be used in combination with a semantic expression.

semanticExpression SemanticViewMetricSemanticExpression: Specifies a semantic expression for a metric definition. Cannot be used in combination with a window function.
windowFunction SemanticViewMetricWindowFunction: Specifies a window function for a metric definition. Cannot be used in combination with a semantic expression.

semanticExpression SemanticViewMetricSemanticExpression: Specifies a semantic expression for a metric definition. Cannot be used in combination with a window function.
windowFunction SemanticViewMetricWindowFunction: Specifies a window function for a metric definition. Cannot be used in combination with a semantic expression.

semantic_expression SemanticViewMetricSemanticExpression: Specifies a semantic expression for a metric definition. Cannot be used in combination with a window function.
window_function SemanticViewMetricWindowFunction: Specifies a window function for a metric definition. Cannot be used in combination with a semantic expression.

semanticExpression Property Map: Specifies a semantic expression for a metric definition. Cannot be used in combination with a window function.
windowFunction Property Map: Specifies a window function for a metric definition. Cannot be used in combination with a semantic expression.

SemanticViewMetricSemanticExpression, SemanticViewMetricSemanticExpressionArgs

QualifiedExpressionName string: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
SqlExpression string: The SQL expression used to compute the metric.
Comment string: Specifies a comment for the semantic expression.
Synonyms List<string>: List of synonyms for this semantic expression.

QualifiedExpressionName string: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
SqlExpression string: The SQL expression used to compute the metric.
Comment string: Specifies a comment for the semantic expression.
Synonyms []string: List of synonyms for this semantic expression.

qualifiedExpressionName String: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
sqlExpression String: The SQL expression used to compute the metric.
comment String: Specifies a comment for the semantic expression.
synonyms List<String>: List of synonyms for this semantic expression.

qualifiedExpressionName string: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
sqlExpression string: The SQL expression used to compute the metric.
comment string: Specifies a comment for the semantic expression.
synonyms string[]: List of synonyms for this semantic expression.

qualified_expression_name str: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
sql_expression str: The SQL expression used to compute the metric.
comment str: Specifies a comment for the semantic expression.
synonyms Sequence[str]: List of synonyms for this semantic expression.

qualifiedExpressionName String: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
sqlExpression String: The SQL expression used to compute the metric.
comment String: Specifies a comment for the semantic expression.
synonyms List<String>: List of synonyms for this semantic expression.

SemanticViewMetricWindowFunction, SemanticViewMetricWindowFunctionArgs

OverClause SemanticViewMetricWindowFunctionOverClause: Specify the partition by, order by or frame over which the window function is to be computed.
QualifiedExpressionName string: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
SqlExpression string: The SQL expression used to compute the metric following the <window_function>(<metric>) format.

OverClause SemanticViewMetricWindowFunctionOverClause: Specify the partition by, order by or frame over which the window function is to be computed.
QualifiedExpressionName string: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
SqlExpression string: The SQL expression used to compute the metric following the <window_function>(<metric>) format.

overClause SemanticViewMetricWindowFunctionOverClause: Specify the partition by, order by or frame over which the window function is to be computed.
qualifiedExpressionName String: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
sqlExpression String: The SQL expression used to compute the metric following the <window_function>(<metric>) format.

overClause SemanticViewMetricWindowFunctionOverClause: Specify the partition by, order by or frame over which the window function is to be computed.
qualifiedExpressionName string: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
sqlExpression string: The SQL expression used to compute the metric following the <window_function>(<metric>) format.

over_clause SemanticViewMetricWindowFunctionOverClause: Specify the partition by, order by or frame over which the window function is to be computed.
qualified_expression_name str: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
sql_expression str: The SQL expression used to compute the metric following the <window_function>(<metric>) format.

overClause Property Map: Specify the partition by, order by or frame over which the window function is to be computed.
qualifiedExpressionName String: Specifies a qualified name for the metric: <table_alias>.<semantic_expression_name>. Remember to wrap each part in double quotes like "\"<table_alias>\".\"<semantic_expression_name>\"". For the derived metric omit the <table_alias>. part but still wrap in double quotes, e.g. "\"<semantic_expression_name>\"".
sqlExpression String: The SQL expression used to compute the metric following the <window_function>(<metric>) format.

SemanticViewMetricWindowFunctionOverClause, SemanticViewMetricWindowFunctionOverClauseArgs

OrderBy string: Specifies an order by clause. It must be a complete SQL expression, including any [ ASC | DESC ] [ NULLS { FIRST | LAST } ] modifiers.
PartitionBy string: Specifies a partition by clause.
WindowFrameClause string: Specifies a window frame clause.

OrderBy string: Specifies an order by clause. It must be a complete SQL expression, including any [ ASC | DESC ] [ NULLS { FIRST | LAST } ] modifiers.
PartitionBy string: Specifies a partition by clause.
WindowFrameClause string: Specifies a window frame clause.

orderBy String: Specifies an order by clause. It must be a complete SQL expression, including any [ ASC | DESC ] [ NULLS { FIRST | LAST } ] modifiers.
partitionBy String: Specifies a partition by clause.
windowFrameClause String: Specifies a window frame clause.

orderBy string: Specifies an order by clause. It must be a complete SQL expression, including any [ ASC | DESC ] [ NULLS { FIRST | LAST } ] modifiers.
partitionBy string: Specifies a partition by clause.
windowFrameClause string: Specifies a window frame clause.

order_by str: Specifies an order by clause. It must be a complete SQL expression, including any [ ASC | DESC ] [ NULLS { FIRST | LAST } ] modifiers.
partition_by str: Specifies a partition by clause.
window_frame_clause str: Specifies a window frame clause.

orderBy String: Specifies an order by clause. It must be a complete SQL expression, including any [ ASC | DESC ] [ NULLS { FIRST | LAST } ] modifiers.
partitionBy String: Specifies a partition by clause.
windowFrameClause String: Specifies a window frame clause.

SemanticViewRelationship, SemanticViewRelationshipArgs

ReferencedTableNameOrAlias SemanticViewRelationshipReferencedTableNameOrAlias: Specifies the other logical table and one or more of its columns that are referred to by the first logical table. Each referenced table can have either a table_name or a table_alias, not both.
RelationshipColumns List<string>: Specifies one or more columns in the first logical table that refers to columns in another logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
TableNameOrAlias SemanticViewRelationshipTableNameOrAlias: Specifies one of the logical tables that refers to columns in another logical table. Each table can have either a table_name or a table_alias, not both.
ReferencedRelationshipColumns List<string>: Specifies one or more columns in the second logical table that are referred to by the first logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
RelationshipIdentifier string: Specifies an optional identifier for the relationship. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

ReferencedTableNameOrAlias SemanticViewRelationshipReferencedTableNameOrAlias: Specifies the other logical table and one or more of its columns that are referred to by the first logical table. Each referenced table can have either a table_name or a table_alias, not both.
RelationshipColumns []string: Specifies one or more columns in the first logical table that refers to columns in another logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
TableNameOrAlias SemanticViewRelationshipTableNameOrAlias: Specifies one of the logical tables that refers to columns in another logical table. Each table can have either a table_name or a table_alias, not both.
ReferencedRelationshipColumns []string: Specifies one or more columns in the second logical table that are referred to by the first logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
RelationshipIdentifier string: Specifies an optional identifier for the relationship. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

referencedTableNameOrAlias SemanticViewRelationshipReferencedTableNameOrAlias: Specifies the other logical table and one or more of its columns that are referred to by the first logical table. Each referenced table can have either a table_name or a table_alias, not both.
relationshipColumns List<String>: Specifies one or more columns in the first logical table that refers to columns in another logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
tableNameOrAlias SemanticViewRelationshipTableNameOrAlias: Specifies one of the logical tables that refers to columns in another logical table. Each table can have either a table_name or a table_alias, not both.
referencedRelationshipColumns List<String>: Specifies one or more columns in the second logical table that are referred to by the first logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
relationshipIdentifier String: Specifies an optional identifier for the relationship. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

referencedTableNameOrAlias SemanticViewRelationshipReferencedTableNameOrAlias: Specifies the other logical table and one or more of its columns that are referred to by the first logical table. Each referenced table can have either a table_name or a table_alias, not both.
relationshipColumns string[]: Specifies one or more columns in the first logical table that refers to columns in another logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
tableNameOrAlias SemanticViewRelationshipTableNameOrAlias: Specifies one of the logical tables that refers to columns in another logical table. Each table can have either a table_name or a table_alias, not both.
referencedRelationshipColumns string[]: Specifies one or more columns in the second logical table that are referred to by the first logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
relationshipIdentifier string: Specifies an optional identifier for the relationship. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

referenced_table_name_or_alias SemanticViewRelationshipReferencedTableNameOrAlias: Specifies the other logical table and one or more of its columns that are referred to by the first logical table. Each referenced table can have either a table_name or a table_alias, not both.
relationship_columns Sequence[str]: Specifies one or more columns in the first logical table that refers to columns in another logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
table_name_or_alias SemanticViewRelationshipTableNameOrAlias: Specifies one of the logical tables that refers to columns in another logical table. Each table can have either a table_name or a table_alias, not both.
referenced_relationship_columns Sequence[str]: Specifies one or more columns in the second logical table that are referred to by the first logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
relationship_identifier str: Specifies an optional identifier for the relationship. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

referencedTableNameOrAlias Property Map: Specifies the other logical table and one or more of its columns that are referred to by the first logical table. Each referenced table can have either a table_name or a table_alias, not both.
relationshipColumns List<String>: Specifies one or more columns in the first logical table that refers to columns in another logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
tableNameOrAlias Property Map: Specifies one of the logical tables that refers to columns in another logical table. Each table can have either a table_name or a table_alias, not both.
referencedRelationshipColumns List<String>: Specifies one or more columns in the second logical table that are referred to by the first logical table. Column names in this list are case-sensitive - the provider uses double quotes to wrap each of them when sending the SQL to Snowflake.
relationshipIdentifier String: Specifies an optional identifier for the relationship. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

SemanticViewRelationshipReferencedTableNameOrAlias, SemanticViewRelationshipReferencedTableNameOrAliasArgs

TableAlias string: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
TableName string: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

TableAlias string: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
TableName string: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias String: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName String: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias string: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName string: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

table_alias str: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
table_name str: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias String: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName String: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

SemanticViewRelationshipTableNameOrAlias, SemanticViewRelationshipTableNameOrAliasArgs

TableAlias string: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
TableName string: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

TableAlias string: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
TableName string: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias String: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName String: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias string: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName string: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

table_alias str: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
table_name str: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias String: The alias used for the logical table, cannot be used in combination with the table_name. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName String: The name of the logical table, cannot be used in combination with the table_alias. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

SemanticViewShowOutput, SemanticViewShowOutputArgs

Comment string
CreatedOn string
DatabaseName string
Extension string
Name string
Owner string
OwnerRoleType string
SchemaName string

Comment string
CreatedOn string
DatabaseName string
Extension string
Name string
Owner string
OwnerRoleType string
SchemaName string

comment String
createdOn String
databaseName String
extension String
name String
owner String
ownerRoleType String
schemaName String

comment string
createdOn string
databaseName string
extension string
name string
owner string
ownerRoleType string
schemaName string

comment str
created_on str
database_name str
extension str
name str
owner str
owner_role_type str
schema_name str

comment String
createdOn String
databaseName String
extension String
name String
owner String
ownerRoleType String
schemaName String

SemanticViewTable, SemanticViewTableArgs

TableAlias string: Specifies an alias for a logical table in the semantic view. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
TableName string: Specifies an identifier for the logical table. Example: "\"<db_name>\".\"<schema_name>\".\"<table_name>\"". Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Comment string: Specifies a comment for the logical table.
PrimaryKeys List<string>: Definitions of primary keys in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
Synonyms List<string>: List of synonyms for the logical table.
Uniques List<SemanticViewTableUnique>: Definitions of unique key combinations in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

TableAlias string: Specifies an alias for a logical table in the semantic view. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
TableName string: Specifies an identifier for the logical table. Example: "\"<db_name>\".\"<schema_name>\".\"<table_name>\"". Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Comment string: Specifies a comment for the logical table.
PrimaryKeys []string: Definitions of primary keys in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
Synonyms []string: List of synonyms for the logical table.
Uniques []SemanticViewTableUnique: Definitions of unique key combinations in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias String: Specifies an alias for a logical table in the semantic view. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName String: Specifies an identifier for the logical table. Example: "\"<db_name>\".\"<schema_name>\".\"<table_name>\"". Due to technical limitations (read more here), avoid using the following characters: |, ., ".
comment String: Specifies a comment for the logical table.
primaryKeys List<String>: Definitions of primary keys in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
synonyms List<String>: List of synonyms for the logical table.
uniques List<SemanticViewTableUnique>: Definitions of unique key combinations in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias string: Specifies an alias for a logical table in the semantic view. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName string: Specifies an identifier for the logical table. Example: "\"<db_name>\".\"<schema_name>\".\"<table_name>\"". Due to technical limitations (read more here), avoid using the following characters: |, ., ".
comment string: Specifies a comment for the logical table.
primaryKeys string[]: Definitions of primary keys in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
synonyms string[]: List of synonyms for the logical table.
uniques SemanticViewTableUnique[]: Definitions of unique key combinations in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

table_alias str: Specifies an alias for a logical table in the semantic view. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
table_name str: Specifies an identifier for the logical table. Example: "\"<db_name>\".\"<schema_name>\".\"<table_name>\"". Due to technical limitations (read more here), avoid using the following characters: |, ., ".
comment str: Specifies a comment for the logical table.
primary_keys Sequence[str]: Definitions of primary keys in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
synonyms Sequence[str]: List of synonyms for the logical table.
uniques Sequence[SemanticViewTableUnique]: Definitions of unique key combinations in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

tableAlias String: Specifies an alias for a logical table in the semantic view. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
tableName String: Specifies an identifier for the logical table. Example: "\"<db_name>\".\"<schema_name>\".\"<table_name>\"". Due to technical limitations (read more here), avoid using the following characters: |, ., ".
comment String: Specifies a comment for the logical table.
primaryKeys List<String>: Definitions of primary keys in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.
synonyms List<String>: List of synonyms for the logical table.
uniques List<Property Map>: Definitions of unique key combinations in the logical table. This field is case-sensitive - the provider uses double quotes to wrap it when sending the SQL to Snowflake.

SemanticViewTableUnique, SemanticViewTableUniqueArgs

Values List<string>: Unique key combinations in the logical table.

Values []string: Unique key combinations in the logical table.

values List<String>: Unique key combinations in the logical table.

values string[]: Unique key combinations in the logical table.

values Sequence[str]: Unique key combinations in the logical table.

values List<String>: Unique key combinations in the logical table.

Package Details

Repository: Snowflake pulumi/pulumi-snowflake
License: Apache-2.0
Notes: This Pulumi package is based on the snowflake Terraform Provider.

Snowflake v2.10.0 published on Saturday, Nov 22, 2025 by Pulumi

Schema (JSON)

pulumi/pulumi-snowflake

snowflake.SemanticView

On this page

On this page

Import

Create SemanticView Resource

Constructor syntax

Parameters

Constructor example

SemanticView Resource Properties

Inputs

Outputs

Look up Existing SemanticView Resource

Supporting Types

SemanticViewDimension, SemanticViewDimensionArgs

SemanticViewFact, SemanticViewFactArgs

SemanticViewMetric, SemanticViewMetricArgs

SemanticViewMetricSemanticExpression, SemanticViewMetricSemanticExpressionArgs

SemanticViewMetricWindowFunction, SemanticViewMetricWindowFunctionArgs

SemanticViewMetricWindowFunctionOverClause, SemanticViewMetricWindowFunctionOverClauseArgs

SemanticViewRelationship, SemanticViewRelationshipArgs

SemanticViewRelationshipReferencedTableNameOrAlias, SemanticViewRelationshipReferencedTableNameOrAliasArgs

SemanticViewRelationshipTableNameOrAlias, SemanticViewRelationshipTableNameOrAliasArgs

SemanticViewShowOutput, SemanticViewShowOutputArgs

SemanticViewTable, SemanticViewTableArgs

SemanticViewTableUnique, SemanticViewTableUniqueArgs

Package Details

On this page

On this page