1. Packages
  2. Snowflake Provider
  3. API Docs
  4. View
Snowflake v1.1.4 published on Wednesday, Mar 26, 2025 by Pulumi

snowflake.View

Explore with Pulumi AI

Import

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

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 This property is required. string
The unique name of the resource.
args This property is required. ViewArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. 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 This property is required. string
The unique name of the resource.
args This property is required. ViewArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. ViewArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. 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",
});
Copy
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"),
})
Copy
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());
Copy
view_resource = snowflake.View("viewResource",
    database="string",
    statement="string",
    schema="string",
    data_metric_schedule={
        "minutes": 0,
        "using_cron": "string",
    },
    copy_grants=False,
    data_metric_functions=[{
        "function_name": "string",
        "ons": ["string"],
        "schedule_status": "string",
    }],
    aggregation_policy={
        "policy_name": "string",
        "entity_keys": ["string"],
    },
    comment="string",
    is_recursive="string",
    is_secure="string",
    is_temporary="string",
    name="string",
    row_access_policy={
        "ons": ["string"],
        "policy_name": "string",
    },
    columns=[{
        "column_name": "string",
        "comment": "string",
        "masking_policy": {
            "policy_name": "string",
            "usings": ["string"],
        },
        "projection_policy": {
            "policy_name": "string",
        },
    }],
    change_tracking="string")
Copy
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",
});
Copy
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
Copy

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

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

The View resource accepts the following input properties:

Database
This property is required.
Changes to this property will trigger replacement.
string
The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Schema
This property is required.
Changes to this property will trigger replacement.
string
The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Statement This property is required. string
Specifies the query used to create the view. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
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
This property is required.
Changes to this property will trigger replacement.
string
The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Schema
This property is required.
Changes to this property will trigger replacement.
string
The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
Statement This property is required. string
Specifies the query used to create the view. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
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
This property is required.
Changes to this property will trigger replacement.
String
The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
schema
This property is required.
Changes to this property will trigger replacement.
String
The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
statement This property is required. String
Specifies the query used to create the view. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
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
This property is required.
Changes to this property will trigger replacement.
string
The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
schema
This property is required.
Changes to this property will trigger replacement.
string
The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
statement This property is required. string
Specifies the query used to create the view. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
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
This property is required.
Changes to this property will trigger replacement.
str
The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
schema
This property is required.
Changes to this property will trigger replacement.
str
The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
statement This property is required. str
Specifies the query used to create the view. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
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
This property is required.
Changes to this property will trigger replacement.
String
The database in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
schema
This property is required.
Changes to this property will trigger replacement.
String
The schema in which to create the view. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
statement This property is required. String
Specifies the query used to create the view. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
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)
resources:  _:    type: snowflake:View    get:      id: ${id}
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
The unique provider ID of the resource to lookup.
name This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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 This property is required.
The unique name of the resulting resource.
id This property is required.
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
DataMetricFunctions List<ViewDataMetricFunction>
Data metric functions used for the view.
DataMetricSchedule ViewDataMetricSchedule
Specifies the schedule to run the data metric functions periodically.
Database Changes to this property will trigger replacement. 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 Changes to this property will trigger replacement. 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. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
DataMetricFunctions []ViewDataMetricFunctionArgs
Data metric functions used for the view.
DataMetricSchedule ViewDataMetricScheduleArgs
Specifies the schedule to run the data metric functions periodically.
Database Changes to this property will trigger replacement. 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 Changes to this property will trigger replacement. 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. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
dataMetricFunctions List<ViewDataMetricFunction>
Data metric functions used for the view.
dataMetricSchedule ViewDataMetricSchedule
Specifies the schedule to run the data metric functions periodically.
database Changes to this property will trigger replacement. 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 Changes to this property will trigger replacement. 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. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
dataMetricFunctions ViewDataMetricFunction[]
Data metric functions used for the view.
dataMetricSchedule ViewDataMetricSchedule
Specifies the schedule to run the data metric functions periodically.
database Changes to this property will trigger replacement. 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 Changes to this property will trigger replacement. 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. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
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 Changes to this property will trigger replacement. 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 Changes to this property will trigger replacement. 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. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.
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
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 Changes to this property will trigger replacement. 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 Changes to this property will trigger replacement. 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. To mitigate permadiff on this field, the provider replaces blank characters with a space. This can lead to false positives in cases where a change in case or run of whitespace is semantically significant.

Supporting Types

ViewAggregationPolicy
, ViewAggregationPolicyArgs

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

ViewColumn
, ViewColumnArgs

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

ViewColumnMaskingPolicy
, ViewColumnMaskingPolicyArgs

PolicyName This property is required. string
Specifies the masking policy to set on a column. For more information about this resource, see docs.
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 This property is required. string
Specifies the masking policy to set on a column. For more information about this resource, see docs.
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 This property is required. String
Specifies the masking policy to set on a column. For more information about this resource, see docs.
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 This property is required. string
Specifies the masking policy to set on a column. For more information about this resource, see docs.
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 This property is required. str
Specifies the masking policy to set on a column. For more information about this resource, see docs.
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 This property is required. String
Specifies the masking policy to set on a column. For more information about this resource, see docs.
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 This property is required. string
Specifies the projection policy to set on a column.
PolicyName This property is required. string
Specifies the projection policy to set on a column.
policyName This property is required. String
Specifies the projection policy to set on a column.
policyName This property is required. string
Specifies the projection policy to set on a column.
policy_name This property is required. str
Specifies the projection policy to set on a column.
policyName This property is required. String
Specifies the projection policy to set on a column.

ViewDataMetricFunction
, ViewDataMetricFunctionArgs

FunctionName This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. []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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 This property is required. 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 are 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 are 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 are 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 are 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 are 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 are 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 This property is required. List<string>
Defines which columns are affected by the policy.
PolicyName This property is required. string
Row access policy name. For more information about this resource, see docs.
Ons This property is required. []string
Defines which columns are affected by the policy.
PolicyName This property is required. string
Row access policy name. For more information about this resource, see docs.
ons This property is required. List<String>
Defines which columns are affected by the policy.
policyName This property is required. String
Row access policy name. For more information about this resource, see docs.
ons This property is required. string[]
Defines which columns are affected by the policy.
policyName This property is required. string
Row access policy name. For more information about this resource, see docs.
ons This property is required. Sequence[str]
Defines which columns are affected by the policy.
policy_name This property is required. str
Row access policy name. For more information about this resource, see docs.
ons This property is required. List<String>
Defines which columns are affected by the policy.
policyName This property is required. String
Row access policy name. For more information about this resource, see docs.

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.