1. Packages
  2. Snowflake
  3. API Docs
  4. View
Snowflake v0.59.0 published on Friday, Sep 20, 2024 by Pulumi

snowflake.View

Explore with Pulumi AI

snowflake logo
Snowflake v0.59.0 published on Friday, Sep 20, 2024 by Pulumi

    Import

    $ pulumi import snowflake:index/view:View example '"<database_name>"."<schema_name>"."<view_name>"'
    

    Create View Resource

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

    Constructor syntax

    new View(name: string, args: ViewArgs, opts?: CustomResourceOptions);
    @overload
    def View(resource_name: str,
             args: ViewArgs,
             opts: Optional[ResourceOptions] = None)
    
    @overload
    def View(resource_name: str,
             opts: Optional[ResourceOptions] = None,
             database: Optional[str] = None,
             statement: Optional[str] = None,
             schema: Optional[str] = None,
             data_metric_schedule: Optional[ViewDataMetricScheduleArgs] = None,
             copy_grants: Optional[bool] = None,
             data_metric_functions: Optional[Sequence[ViewDataMetricFunctionArgs]] = None,
             aggregation_policy: Optional[ViewAggregationPolicyArgs] = None,
             comment: Optional[str] = None,
             is_recursive: Optional[str] = None,
             is_secure: Optional[str] = None,
             is_temporary: Optional[str] = None,
             name: Optional[str] = None,
             row_access_policy: Optional[ViewRowAccessPolicyArgs] = None,
             columns: Optional[Sequence[ViewColumnArgs]] = None,
             change_tracking: Optional[str] = None)
    func NewView(ctx *Context, name string, args ViewArgs, opts ...ResourceOption) (*View, error)
    public View(string name, ViewArgs args, CustomResourceOptions? opts = null)
    public View(String name, ViewArgs args)
    public View(String name, ViewArgs args, CustomResourceOptions options)
    
    type: snowflake:View
    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 ViewArgs
    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 ViewArgs
    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 ViewArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ViewArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ViewArgs
    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 viewResource = new Snowflake.View("viewResource", new()
    {
        Database = "string",
        Statement = "string",
        Schema = "string",
        DataMetricSchedule = new Snowflake.Inputs.ViewDataMetricScheduleArgs
        {
            Minutes = 0,
            UsingCron = "string",
        },
        CopyGrants = false,
        DataMetricFunctions = new[]
        {
            new Snowflake.Inputs.ViewDataMetricFunctionArgs
            {
                FunctionName = "string",
                Ons = new[]
                {
                    "string",
                },
                ScheduleStatus = "string",
            },
        },
        AggregationPolicy = new Snowflake.Inputs.ViewAggregationPolicyArgs
        {
            PolicyName = "string",
            EntityKeys = new[]
            {
                "string",
            },
        },
        Comment = "string",
        IsRecursive = "string",
        IsSecure = "string",
        IsTemporary = "string",
        Name = "string",
        RowAccessPolicy = new Snowflake.Inputs.ViewRowAccessPolicyArgs
        {
            Ons = new[]
            {
                "string",
            },
            PolicyName = "string",
        },
        Columns = new[]
        {
            new Snowflake.Inputs.ViewColumnArgs
            {
                ColumnName = "string",
                Comment = "string",
                MaskingPolicy = new Snowflake.Inputs.ViewColumnMaskingPolicyArgs
                {
                    PolicyName = "string",
                    Usings = new[]
                    {
                        "string",
                    },
                },
                ProjectionPolicy = new Snowflake.Inputs.ViewColumnProjectionPolicyArgs
                {
                    PolicyName = "string",
                },
            },
        },
        ChangeTracking = "string",
    });
    
    example, err := snowflake.NewView(ctx, "viewResource", &snowflake.ViewArgs{
    	Database:  pulumi.String("string"),
    	Statement: pulumi.String("string"),
    	Schema:    pulumi.String("string"),
    	DataMetricSchedule: &snowflake.ViewDataMetricScheduleArgs{
    		Minutes:   pulumi.Int(0),
    		UsingCron: pulumi.String("string"),
    	},
    	CopyGrants: pulumi.Bool(false),
    	DataMetricFunctions: snowflake.ViewDataMetricFunctionArray{
    		&snowflake.ViewDataMetricFunctionArgs{
    			FunctionName: pulumi.String("string"),
    			Ons: pulumi.StringArray{
    				pulumi.String("string"),
    			},
    			ScheduleStatus: pulumi.String("string"),
    		},
    	},
    	AggregationPolicy: &snowflake.ViewAggregationPolicyArgs{
    		PolicyName: pulumi.String("string"),
    		EntityKeys: pulumi.StringArray{
    			pulumi.String("string"),
    		},
    	},
    	Comment:     pulumi.String("string"),
    	IsRecursive: pulumi.String("string"),
    	IsSecure:    pulumi.String("string"),
    	IsTemporary: pulumi.String("string"),
    	Name:        pulumi.String("string"),
    	RowAccessPolicy: &snowflake.ViewRowAccessPolicyArgs{
    		Ons: pulumi.StringArray{
    			pulumi.String("string"),
    		},
    		PolicyName: pulumi.String("string"),
    	},
    	Columns: snowflake.ViewColumnArray{
    		&snowflake.ViewColumnArgs{
    			ColumnName: pulumi.String("string"),
    			Comment:    pulumi.String("string"),
    			MaskingPolicy: &snowflake.ViewColumnMaskingPolicyArgs{
    				PolicyName: pulumi.String("string"),
    				Usings: pulumi.StringArray{
    					pulumi.String("string"),
    				},
    			},
    			ProjectionPolicy: &snowflake.ViewColumnProjectionPolicyArgs{
    				PolicyName: pulumi.String("string"),
    			},
    		},
    	},
    	ChangeTracking: pulumi.String("string"),
    })
    
    var viewResource = new View("viewResource", ViewArgs.builder()
        .database("string")
        .statement("string")
        .schema("string")
        .dataMetricSchedule(ViewDataMetricScheduleArgs.builder()
            .minutes(0)
            .usingCron("string")
            .build())
        .copyGrants(false)
        .dataMetricFunctions(ViewDataMetricFunctionArgs.builder()
            .functionName("string")
            .ons("string")
            .scheduleStatus("string")
            .build())
        .aggregationPolicy(ViewAggregationPolicyArgs.builder()
            .policyName("string")
            .entityKeys("string")
            .build())
        .comment("string")
        .isRecursive("string")
        .isSecure("string")
        .isTemporary("string")
        .name("string")
        .rowAccessPolicy(ViewRowAccessPolicyArgs.builder()
            .ons("string")
            .policyName("string")
            .build())
        .columns(ViewColumnArgs.builder()
            .columnName("string")
            .comment("string")
            .maskingPolicy(ViewColumnMaskingPolicyArgs.builder()
                .policyName("string")
                .usings("string")
                .build())
            .projectionPolicy(ViewColumnProjectionPolicyArgs.builder()
                .policyName("string")
                .build())
            .build())
        .changeTracking("string")
        .build());
    
    view_resource = snowflake.View("viewResource",
        database="string",
        statement="string",
        schema="string",
        data_metric_schedule=snowflake.ViewDataMetricScheduleArgs(
            minutes=0,
            using_cron="string",
        ),
        copy_grants=False,
        data_metric_functions=[snowflake.ViewDataMetricFunctionArgs(
            function_name="string",
            ons=["string"],
            schedule_status="string",
        )],
        aggregation_policy=snowflake.ViewAggregationPolicyArgs(
            policy_name="string",
            entity_keys=["string"],
        ),
        comment="string",
        is_recursive="string",
        is_secure="string",
        is_temporary="string",
        name="string",
        row_access_policy=snowflake.ViewRowAccessPolicyArgs(
            ons=["string"],
            policy_name="string",
        ),
        columns=[snowflake.ViewColumnArgs(
            column_name="string",
            comment="string",
            masking_policy=snowflake.ViewColumnMaskingPolicyArgs(
                policy_name="string",
                usings=["string"],
            ),
            projection_policy=snowflake.ViewColumnProjectionPolicyArgs(
                policy_name="string",
            ),
        )],
        change_tracking="string")
    
    const viewResource = new snowflake.View("viewResource", {
        database: "string",
        statement: "string",
        schema: "string",
        dataMetricSchedule: {
            minutes: 0,
            usingCron: "string",
        },
        copyGrants: false,
        dataMetricFunctions: [{
            functionName: "string",
            ons: ["string"],
            scheduleStatus: "string",
        }],
        aggregationPolicy: {
            policyName: "string",
            entityKeys: ["string"],
        },
        comment: "string",
        isRecursive: "string",
        isSecure: "string",
        isTemporary: "string",
        name: "string",
        rowAccessPolicy: {
            ons: ["string"],
            policyName: "string",
        },
        columns: [{
            columnName: "string",
            comment: "string",
            maskingPolicy: {
                policyName: "string",
                usings: ["string"],
            },
            projectionPolicy: {
                policyName: "string",
            },
        }],
        changeTracking: "string",
    });
    
    type: snowflake:View
    properties:
        aggregationPolicy:
            entityKeys:
                - string
            policyName: string
        changeTracking: string
        columns:
            - columnName: string
              comment: string
              maskingPolicy:
                policyName: string
                usings:
                    - string
              projectionPolicy:
                policyName: string
        comment: string
        copyGrants: false
        dataMetricFunctions:
            - functionName: string
              ons:
                - string
              scheduleStatus: string
        dataMetricSchedule:
            minutes: 0
            usingCron: string
        database: string
        isRecursive: string
        isSecure: string
        isTemporary: string
        name: string
        rowAccessPolicy:
            ons:
                - string
            policyName: string
        schema: string
        statement: string
    

    View Resource Properties

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

    Inputs

    The View resource accepts the following input properties:

    Database string
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    Schema string
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    Statement string
    Specifies the query used to create the view.
    AggregationPolicy ViewAggregationPolicy
    Specifies the aggregation policy to set on a view.
    ChangeTracking string
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Columns List<ViewColumn>
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    Comment string
    Specifies a comment for the view.
    CopyGrants bool
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    DataMetricFunctions List<ViewDataMetricFunction>
    Data metric functions used for the view.
    DataMetricSchedule ViewDataMetricSchedule
    Specifies the schedule to run the data metric functions periodically.
    IsRecursive string
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    IsSecure string
    IsTemporary string
    Name string
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    RowAccessPolicy ViewRowAccessPolicy
    Specifies the row access policy to set on a view.
    Database string
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    Schema string
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    Statement string
    Specifies the query used to create the view.
    AggregationPolicy ViewAggregationPolicyArgs
    Specifies the aggregation policy to set on a view.
    ChangeTracking string
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Columns []ViewColumnArgs
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    Comment string
    Specifies a comment for the view.
    CopyGrants bool
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    DataMetricFunctions []ViewDataMetricFunctionArgs
    Data metric functions used for the view.
    DataMetricSchedule ViewDataMetricScheduleArgs
    Specifies the schedule to run the data metric functions periodically.
    IsRecursive string
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    IsSecure string
    IsTemporary string
    Name string
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    RowAccessPolicy ViewRowAccessPolicyArgs
    Specifies the row access policy to set on a view.
    database String
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    schema String
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    statement String
    Specifies the query used to create the view.
    aggregationPolicy ViewAggregationPolicy
    Specifies the aggregation policy to set on a view.
    changeTracking String
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    columns List<ViewColumn>
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    comment String
    Specifies a comment for the view.
    copyGrants Boolean
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    dataMetricFunctions List<ViewDataMetricFunction>
    Data metric functions used for the view.
    dataMetricSchedule ViewDataMetricSchedule
    Specifies the schedule to run the data metric functions periodically.
    isRecursive String
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    isSecure String
    isTemporary String
    name String
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    rowAccessPolicy ViewRowAccessPolicy
    Specifies the row access policy to set on a view.
    database string
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    schema string
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    statement string
    Specifies the query used to create the view.
    aggregationPolicy ViewAggregationPolicy
    Specifies the aggregation policy to set on a view.
    changeTracking string
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    columns ViewColumn[]
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    comment string
    Specifies a comment for the view.
    copyGrants boolean
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    dataMetricFunctions ViewDataMetricFunction[]
    Data metric functions used for the view.
    dataMetricSchedule ViewDataMetricSchedule
    Specifies the schedule to run the data metric functions periodically.
    isRecursive string
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    isSecure string
    isTemporary string
    name string
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    rowAccessPolicy ViewRowAccessPolicy
    Specifies the row access policy to set on a view.
    database str
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    schema str
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    statement str
    Specifies the query used to create the view.
    aggregation_policy ViewAggregationPolicyArgs
    Specifies the aggregation policy to set on a view.
    change_tracking str
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    columns Sequence[ViewColumnArgs]
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    comment str
    Specifies a comment for the view.
    copy_grants bool
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    data_metric_functions Sequence[ViewDataMetricFunctionArgs]
    Data metric functions used for the view.
    data_metric_schedule ViewDataMetricScheduleArgs
    Specifies the schedule to run the data metric functions periodically.
    is_recursive str
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    is_secure str
    is_temporary str
    name str
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    row_access_policy ViewRowAccessPolicyArgs
    Specifies the row access policy to set on a view.
    database String
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    schema String
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    statement String
    Specifies the query used to create the view.
    aggregationPolicy Property Map
    Specifies the aggregation policy to set on a view.
    changeTracking String
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    columns List<Property Map>
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    comment String
    Specifies a comment for the view.
    copyGrants Boolean
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    dataMetricFunctions List<Property Map>
    Data metric functions used for the view.
    dataMetricSchedule Property Map
    Specifies the schedule to run the data metric functions periodically.
    isRecursive String
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    isSecure String
    isTemporary String
    name String
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    rowAccessPolicy Property Map
    Specifies the row access policy to set on a view.

    Outputs

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

    DescribeOutputs List<ViewDescribeOutput>
    Outputs the result of DESCRIBE VIEW for the given 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<ViewShowOutput>
    Outputs the result of SHOW VIEW for the given view.
    DescribeOutputs []ViewDescribeOutput
    Outputs the result of DESCRIBE VIEW for the given 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 []ViewShowOutput
    Outputs the result of SHOW VIEW for the given view.
    describeOutputs List<ViewDescribeOutput>
    Outputs the result of DESCRIBE VIEW for the given 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<ViewShowOutput>
    Outputs the result of SHOW VIEW for the given view.
    describeOutputs ViewDescribeOutput[]
    Outputs the result of DESCRIBE VIEW for the given 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 ViewShowOutput[]
    Outputs the result of SHOW VIEW for the given view.
    describe_outputs Sequence[ViewDescribeOutput]
    Outputs the result of DESCRIBE VIEW for the given 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[ViewShowOutput]
    Outputs the result of SHOW VIEW for the given view.
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE VIEW for the given 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 VIEW for the given view.

    Look up Existing View Resource

    Get an existing View 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?: ViewState, opts?: CustomResourceOptions): View
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            aggregation_policy: Optional[ViewAggregationPolicyArgs] = None,
            change_tracking: Optional[str] = None,
            columns: Optional[Sequence[ViewColumnArgs]] = None,
            comment: Optional[str] = None,
            copy_grants: Optional[bool] = None,
            data_metric_functions: Optional[Sequence[ViewDataMetricFunctionArgs]] = None,
            data_metric_schedule: Optional[ViewDataMetricScheduleArgs] = None,
            database: Optional[str] = None,
            describe_outputs: Optional[Sequence[ViewDescribeOutputArgs]] = None,
            fully_qualified_name: Optional[str] = None,
            is_recursive: Optional[str] = None,
            is_secure: Optional[str] = None,
            is_temporary: Optional[str] = None,
            name: Optional[str] = None,
            row_access_policy: Optional[ViewRowAccessPolicyArgs] = None,
            schema: Optional[str] = None,
            show_outputs: Optional[Sequence[ViewShowOutputArgs]] = None,
            statement: Optional[str] = None) -> View
    func GetView(ctx *Context, name string, id IDInput, state *ViewState, opts ...ResourceOption) (*View, error)
    public static View Get(string name, Input<string> id, ViewState? state, CustomResourceOptions? opts = null)
    public static View get(String name, Output<String> id, ViewState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    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:
    AggregationPolicy ViewAggregationPolicy
    Specifies the aggregation policy to set on a view.
    ChangeTracking string
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Columns List<ViewColumn>
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    Comment string
    Specifies a comment for the view.
    CopyGrants bool
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    DataMetricFunctions List<ViewDataMetricFunction>
    Data metric functions used for the view.
    DataMetricSchedule ViewDataMetricSchedule
    Specifies the schedule to run the data metric functions periodically.
    Database string
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    DescribeOutputs List<ViewDescribeOutput>
    Outputs the result of DESCRIBE VIEW for the given view.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    IsRecursive string
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    IsSecure string
    IsTemporary string
    Name string
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    RowAccessPolicy ViewRowAccessPolicy
    Specifies the row access policy to set on a view.
    Schema string
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    ShowOutputs List<ViewShowOutput>
    Outputs the result of SHOW VIEW for the given view.
    Statement string
    Specifies the query used to create the view.
    AggregationPolicy ViewAggregationPolicyArgs
    Specifies the aggregation policy to set on a view.
    ChangeTracking string
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    Columns []ViewColumnArgs
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    Comment string
    Specifies a comment for the view.
    CopyGrants bool
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    DataMetricFunctions []ViewDataMetricFunctionArgs
    Data metric functions used for the view.
    DataMetricSchedule ViewDataMetricScheduleArgs
    Specifies the schedule to run the data metric functions periodically.
    Database string
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    DescribeOutputs []ViewDescribeOutputArgs
    Outputs the result of DESCRIBE VIEW for the given view.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    IsRecursive string
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    IsSecure string
    IsTemporary string
    Name string
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    RowAccessPolicy ViewRowAccessPolicyArgs
    Specifies the row access policy to set on a view.
    Schema string
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    ShowOutputs []ViewShowOutputArgs
    Outputs the result of SHOW VIEW for the given view.
    Statement string
    Specifies the query used to create the view.
    aggregationPolicy ViewAggregationPolicy
    Specifies the aggregation policy to set on a view.
    changeTracking String
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    columns List<ViewColumn>
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    comment String
    Specifies a comment for the view.
    copyGrants Boolean
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    dataMetricFunctions List<ViewDataMetricFunction>
    Data metric functions used for the view.
    dataMetricSchedule ViewDataMetricSchedule
    Specifies the schedule to run the data metric functions periodically.
    database String
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    describeOutputs List<ViewDescribeOutput>
    Outputs the result of DESCRIBE VIEW for the given view.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    isRecursive String
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    isSecure String
    isTemporary String
    name String
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    rowAccessPolicy ViewRowAccessPolicy
    Specifies the row access policy to set on a view.
    schema String
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    showOutputs List<ViewShowOutput>
    Outputs the result of SHOW VIEW for the given view.
    statement String
    Specifies the query used to create the view.
    aggregationPolicy ViewAggregationPolicy
    Specifies the aggregation policy to set on a view.
    changeTracking string
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    columns ViewColumn[]
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    comment string
    Specifies a comment for the view.
    copyGrants boolean
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    dataMetricFunctions ViewDataMetricFunction[]
    Data metric functions used for the view.
    dataMetricSchedule ViewDataMetricSchedule
    Specifies the schedule to run the data metric functions periodically.
    database string
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    describeOutputs ViewDescribeOutput[]
    Outputs the result of DESCRIBE VIEW for the given view.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    isRecursive string
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    isSecure string
    isTemporary string
    name string
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    rowAccessPolicy ViewRowAccessPolicy
    Specifies the row access policy to set on a view.
    schema string
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    showOutputs ViewShowOutput[]
    Outputs the result of SHOW VIEW for the given view.
    statement string
    Specifies the query used to create the view.
    aggregation_policy ViewAggregationPolicyArgs
    Specifies the aggregation policy to set on a view.
    change_tracking str
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    columns Sequence[ViewColumnArgs]
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    comment str
    Specifies a comment for the view.
    copy_grants bool
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    data_metric_functions Sequence[ViewDataMetricFunctionArgs]
    Data metric functions used for the view.
    data_metric_schedule ViewDataMetricScheduleArgs
    Specifies the schedule to run the data metric functions periodically.
    database str
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    describe_outputs Sequence[ViewDescribeOutputArgs]
    Outputs the result of DESCRIBE VIEW for the given view.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    is_recursive str
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    is_secure str
    is_temporary str
    name str
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    row_access_policy ViewRowAccessPolicyArgs
    Specifies the row access policy to set on a view.
    schema str
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    show_outputs Sequence[ViewShowOutputArgs]
    Outputs the result of SHOW VIEW for the given view.
    statement str
    Specifies the query used to create the view.
    aggregationPolicy Property Map
    Specifies the aggregation policy to set on a view.
    changeTracking String
    Specifies to enable or disable change tracking on the table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    columns List<Property Map>
    If you want to change the name of a column or add a comment to a column in the new view, include a column list that specifies the column names and (if needed) comments about the columns. You do not need to specify the data types of the columns. If this field is not specified, columns are inferred from the statement field by Snowflake.
    comment String
    Specifies a comment for the view.
    copyGrants Boolean
    Retains the access permissions from the original view when a new view is created using the OR REPLACE clause.
    dataMetricFunctions List<Property Map>
    Data metric functions used for the view.
    dataMetricSchedule Property Map
    Specifies the schedule to run the data metric functions periodically.
    database String
    The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE VIEW for the given view.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    isRecursive String
    Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common table expression). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
    isSecure String
    isTemporary String
    name String
    Specifies the identifier for the view; must be unique for the schema in which the view is created. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    rowAccessPolicy Property Map
    Specifies the row access policy to set on a view.
    schema String
    The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., (, ), "
    showOutputs List<Property Map>
    Outputs the result of SHOW VIEW for the given view.
    statement String
    Specifies the query used to create the view.

    Supporting Types

    ViewAggregationPolicy, ViewAggregationPolicyArgs

    PolicyName string
    Aggregation policy name.
    EntityKeys List<string>
    Defines which columns uniquely identify an entity within the view.
    PolicyName string
    Aggregation policy name.
    EntityKeys []string
    Defines which columns uniquely identify an entity within the view.
    policyName String
    Aggregation policy name.
    entityKeys List<String>
    Defines which columns uniquely identify an entity within the view.
    policyName string
    Aggregation policy name.
    entityKeys string[]
    Defines which columns uniquely identify an entity within the view.
    policy_name str
    Aggregation policy name.
    entity_keys Sequence[str]
    Defines which columns uniquely identify an entity within the view.
    policyName String
    Aggregation policy name.
    entityKeys List<String>
    Defines which columns uniquely identify an entity within the view.

    ViewColumn, ViewColumnArgs

    ColumnName string
    Specifies affected column name.
    Comment string
    Specifies a comment for the column.
    MaskingPolicy ViewColumnMaskingPolicy
    ProjectionPolicy ViewColumnProjectionPolicy
    ColumnName string
    Specifies affected column name.
    Comment string
    Specifies a comment for the column.
    MaskingPolicy ViewColumnMaskingPolicy
    ProjectionPolicy ViewColumnProjectionPolicy
    columnName String
    Specifies affected column name.
    comment String
    Specifies a comment for the column.
    maskingPolicy ViewColumnMaskingPolicy
    projectionPolicy ViewColumnProjectionPolicy
    columnName string
    Specifies affected column name.
    comment string
    Specifies a comment for the column.
    maskingPolicy ViewColumnMaskingPolicy
    projectionPolicy ViewColumnProjectionPolicy
    column_name str
    Specifies affected column name.
    comment str
    Specifies a comment for the column.
    masking_policy ViewColumnMaskingPolicy
    projection_policy ViewColumnProjectionPolicy
    columnName String
    Specifies affected column name.
    comment String
    Specifies a comment for the column.
    maskingPolicy Property Map
    projectionPolicy Property Map

    ViewColumnMaskingPolicy, ViewColumnMaskingPolicyArgs

    PolicyName string
    Specifies the masking policy to set on a column.
    Usings List<string>
    Specifies the arguments to pass into the conditional masking policy SQL expression. The first column in the list specifies the column for the policy conditions to mask or tokenize the data and must match the column to which the masking policy is set. The additional columns specify the columns to evaluate to determine whether to mask or tokenize the data in each row of the query result when a query is made on the first column. If the USING clause is omitted, Snowflake treats the conditional masking policy as a normal masking policy.
    PolicyName string
    Specifies the masking policy to set on a column.
    Usings []string
    Specifies the arguments to pass into the conditional masking policy SQL expression. The first column in the list specifies the column for the policy conditions to mask or tokenize the data and must match the column to which the masking policy is set. The additional columns specify the columns to evaluate to determine whether to mask or tokenize the data in each row of the query result when a query is made on the first column. If the USING clause is omitted, Snowflake treats the conditional masking policy as a normal masking policy.
    policyName String
    Specifies the masking policy to set on a column.
    usings List<String>
    Specifies the arguments to pass into the conditional masking policy SQL expression. The first column in the list specifies the column for the policy conditions to mask or tokenize the data and must match the column to which the masking policy is set. The additional columns specify the columns to evaluate to determine whether to mask or tokenize the data in each row of the query result when a query is made on the first column. If the USING clause is omitted, Snowflake treats the conditional masking policy as a normal masking policy.
    policyName string
    Specifies the masking policy to set on a column.
    usings string[]
    Specifies the arguments to pass into the conditional masking policy SQL expression. The first column in the list specifies the column for the policy conditions to mask or tokenize the data and must match the column to which the masking policy is set. The additional columns specify the columns to evaluate to determine whether to mask or tokenize the data in each row of the query result when a query is made on the first column. If the USING clause is omitted, Snowflake treats the conditional masking policy as a normal masking policy.
    policy_name str
    Specifies the masking policy to set on a column.
    usings Sequence[str]
    Specifies the arguments to pass into the conditional masking policy SQL expression. The first column in the list specifies the column for the policy conditions to mask or tokenize the data and must match the column to which the masking policy is set. The additional columns specify the columns to evaluate to determine whether to mask or tokenize the data in each row of the query result when a query is made on the first column. If the USING clause is omitted, Snowflake treats the conditional masking policy as a normal masking policy.
    policyName String
    Specifies the masking policy to set on a column.
    usings List<String>
    Specifies the arguments to pass into the conditional masking policy SQL expression. The first column in the list specifies the column for the policy conditions to mask or tokenize the data and must match the column to which the masking policy is set. The additional columns specify the columns to evaluate to determine whether to mask or tokenize the data in each row of the query result when a query is made on the first column. If the USING clause is omitted, Snowflake treats the conditional masking policy as a normal masking policy.

    ViewColumnProjectionPolicy, ViewColumnProjectionPolicyArgs

    PolicyName string
    Specifies the projection policy to set on a column.
    PolicyName string
    Specifies the projection policy to set on a column.
    policyName String
    Specifies the projection policy to set on a column.
    policyName string
    Specifies the projection policy to set on a column.
    policy_name str
    Specifies the projection policy to set on a column.
    policyName String
    Specifies the projection policy to set on a column.

    ViewDataMetricFunction, ViewDataMetricFunctionArgs

    FunctionName string
    Identifier of the data metric function to add to the table or view or drop from the table or view. This function identifier must be provided without arguments in parenthesis.
    Ons List<string>
    The table or view columns on which to associate the data metric function. The data types of the columns must match the data types of the columns specified in the data metric function definition.
    ScheduleStatus string
    The status of the metrics association. Valid values are: STARTED | SUSPENDED. When status of a data metric function is changed, it is being reassigned with DROP DATA METRIC FUNCTION and ADD DATA METRIC FUNCTION, and then its status is changed by MODIFY DATA METRIC FUNCTION
    FunctionName string
    Identifier of the data metric function to add to the table or view or drop from the table or view. This function identifier must be provided without arguments in parenthesis.
    Ons []string
    The table or view columns on which to associate the data metric function. The data types of the columns must match the data types of the columns specified in the data metric function definition.
    ScheduleStatus string
    The status of the metrics association. Valid values are: STARTED | SUSPENDED. When status of a data metric function is changed, it is being reassigned with DROP DATA METRIC FUNCTION and ADD DATA METRIC FUNCTION, and then its status is changed by MODIFY DATA METRIC FUNCTION
    functionName String
    Identifier of the data metric function to add to the table or view or drop from the table or view. This function identifier must be provided without arguments in parenthesis.
    ons List<String>
    The table or view columns on which to associate the data metric function. The data types of the columns must match the data types of the columns specified in the data metric function definition.
    scheduleStatus String
    The status of the metrics association. Valid values are: STARTED | SUSPENDED. When status of a data metric function is changed, it is being reassigned with DROP DATA METRIC FUNCTION and ADD DATA METRIC FUNCTION, and then its status is changed by MODIFY DATA METRIC FUNCTION
    functionName string
    Identifier of the data metric function to add to the table or view or drop from the table or view. This function identifier must be provided without arguments in parenthesis.
    ons string[]
    The table or view columns on which to associate the data metric function. The data types of the columns must match the data types of the columns specified in the data metric function definition.
    scheduleStatus string
    The status of the metrics association. Valid values are: STARTED | SUSPENDED. When status of a data metric function is changed, it is being reassigned with DROP DATA METRIC FUNCTION and ADD DATA METRIC FUNCTION, and then its status is changed by MODIFY DATA METRIC FUNCTION
    function_name str
    Identifier of the data metric function to add to the table or view or drop from the table or view. This function identifier must be provided without arguments in parenthesis.
    ons Sequence[str]
    The table or view columns on which to associate the data metric function. The data types of the columns must match the data types of the columns specified in the data metric function definition.
    schedule_status str
    The status of the metrics association. Valid values are: STARTED | SUSPENDED. When status of a data metric function is changed, it is being reassigned with DROP DATA METRIC FUNCTION and ADD DATA METRIC FUNCTION, and then its status is changed by MODIFY DATA METRIC FUNCTION
    functionName String
    Identifier of the data metric function to add to the table or view or drop from the table or view. This function identifier must be provided without arguments in parenthesis.
    ons List<String>
    The table or view columns on which to associate the data metric function. The data types of the columns must match the data types of the columns specified in the data metric function definition.
    scheduleStatus String
    The status of the metrics association. Valid values are: STARTED | SUSPENDED. When status of a data metric function is changed, it is being reassigned with DROP DATA METRIC FUNCTION and ADD DATA METRIC FUNCTION, and then its status is changed by MODIFY DATA METRIC FUNCTION

    ViewDataMetricSchedule, ViewDataMetricScheduleArgs

    Minutes int
    Specifies an interval (in minutes) of wait time inserted between runs of the data metric function. Conflicts with using_cron. Valid values are: 5 | 15 | 30 | 60 | 720 | 1440. Due to Snowflake limitations, changes in this field is not managed by the provider. Please consider using taint command, using_cron field, or replacetriggeredby metadata argument.
    UsingCron string
    Specifies a cron expression and time zone for periodically running the data metric function. Supports a subset of standard cron utility syntax. Conflicts with minutes.
    Minutes int
    Specifies an interval (in minutes) of wait time inserted between runs of the data metric function. Conflicts with using_cron. Valid values are: 5 | 15 | 30 | 60 | 720 | 1440. Due to Snowflake limitations, changes in this field is not managed by the provider. Please consider using taint command, using_cron field, or replacetriggeredby metadata argument.
    UsingCron string
    Specifies a cron expression and time zone for periodically running the data metric function. Supports a subset of standard cron utility syntax. Conflicts with minutes.
    minutes Integer
    Specifies an interval (in minutes) of wait time inserted between runs of the data metric function. Conflicts with using_cron. Valid values are: 5 | 15 | 30 | 60 | 720 | 1440. Due to Snowflake limitations, changes in this field is not managed by the provider. Please consider using taint command, using_cron field, or replacetriggeredby metadata argument.
    usingCron String
    Specifies a cron expression and time zone for periodically running the data metric function. Supports a subset of standard cron utility syntax. Conflicts with minutes.
    minutes number
    Specifies an interval (in minutes) of wait time inserted between runs of the data metric function. Conflicts with using_cron. Valid values are: 5 | 15 | 30 | 60 | 720 | 1440. Due to Snowflake limitations, changes in this field is not managed by the provider. Please consider using taint command, using_cron field, or replacetriggeredby metadata argument.
    usingCron string
    Specifies a cron expression and time zone for periodically running the data metric function. Supports a subset of standard cron utility syntax. Conflicts with minutes.
    minutes int
    Specifies an interval (in minutes) of wait time inserted between runs of the data metric function. Conflicts with using_cron. Valid values are: 5 | 15 | 30 | 60 | 720 | 1440. Due to Snowflake limitations, changes in this field is not managed by the provider. Please consider using taint command, using_cron field, or replacetriggeredby metadata argument.
    using_cron str
    Specifies a cron expression and time zone for periodically running the data metric function. Supports a subset of standard cron utility syntax. Conflicts with minutes.
    minutes Number
    Specifies an interval (in minutes) of wait time inserted between runs of the data metric function. Conflicts with using_cron. Valid values are: 5 | 15 | 30 | 60 | 720 | 1440. Due to Snowflake limitations, changes in this field is not managed by the provider. Please consider using taint command, using_cron field, or replacetriggeredby metadata argument.
    usingCron String
    Specifies a cron expression and time zone for periodically running the data metric function. Supports a subset of standard cron utility syntax. Conflicts with minutes.

    ViewDescribeOutput, ViewDescribeOutputArgs

    Check string
    Comment string
    Default string
    Expression string
    IsNullable bool
    IsPrimary bool
    IsUnique bool
    Kind string
    Name string
    PolicyName string
    PrivacyDomain string
    Type string
    Check string
    Comment string
    Default string
    Expression string
    IsNullable bool
    IsPrimary bool
    IsUnique bool
    Kind string
    Name string
    PolicyName string
    PrivacyDomain string
    Type string
    check String
    comment String
    default_ String
    expression String
    isNullable Boolean
    isPrimary Boolean
    isUnique Boolean
    kind String
    name String
    policyName String
    privacyDomain String
    type String
    check string
    comment string
    default string
    expression string
    isNullable boolean
    isPrimary boolean
    isUnique boolean
    kind string
    name string
    policyName string
    privacyDomain string
    type string
    check String
    comment String
    default String
    expression String
    isNullable Boolean
    isPrimary Boolean
    isUnique Boolean
    kind String
    name String
    policyName String
    privacyDomain String
    type String

    ViewRowAccessPolicy, ViewRowAccessPolicyArgs

    Ons List<string>
    Defines which columns are affected by the policy.
    PolicyName string
    Row access policy name.
    Ons []string
    Defines which columns are affected by the policy.
    PolicyName string
    Row access policy name.
    ons List<String>
    Defines which columns are affected by the policy.
    policyName String
    Row access policy name.
    ons string[]
    Defines which columns are affected by the policy.
    policyName string
    Row access policy name.
    ons Sequence[str]
    Defines which columns are affected by the policy.
    policy_name str
    Row access policy name.
    ons List<String>
    Defines which columns are affected by the policy.
    policyName String
    Row access policy name.

    ViewShowOutput, ViewShowOutputArgs

    ChangeTracking string
    Comment string
    CreatedOn string
    DatabaseName string
    IsMaterialized bool
    IsSecure bool
    Kind string
    Name string
    Owner string
    OwnerRoleType string
    Reserved string
    SchemaName string
    Text string
    ChangeTracking string
    Comment string
    CreatedOn string
    DatabaseName string
    IsMaterialized bool
    IsSecure bool
    Kind string
    Name string
    Owner string
    OwnerRoleType string
    Reserved string
    SchemaName string
    Text string
    changeTracking String
    comment String
    createdOn String
    databaseName String
    isMaterialized Boolean
    isSecure Boolean
    kind String
    name String
    owner String
    ownerRoleType String
    reserved String
    schemaName String
    text String
    changeTracking string
    comment string
    createdOn string
    databaseName string
    isMaterialized boolean
    isSecure boolean
    kind string
    name string
    owner string
    ownerRoleType string
    reserved string
    schemaName string
    text string
    changeTracking String
    comment String
    createdOn String
    databaseName String
    isMaterialized Boolean
    isSecure Boolean
    kind String
    name String
    owner String
    ownerRoleType String
    reserved String
    schemaName String
    text String

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Snowflake v0.59.0 published on Friday, Sep 20, 2024 by Pulumi