Sign in Dashboard Get started
  1. Registry
  2. Packages
  3. Snowflake Provider
  4. API Docs
  5. ProjectionPolicy
Viewing docs for Snowflake v2.23.0
published on Friday, Nov 6, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

snowflake.ProjectionPolicy

snowflake logo
Viewing docs for Snowflake v2.23.0
published on Friday, Nov 6, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

    Caution: Preview Feature This feature is considered a preview feature in the provider, regardless of the state of the resource in Snowflake. We do not guarantee its stability. It will be reworked and marked as a stable feature in future releases. Breaking changes are expected, even without bumping the major version. To use this feature, add the relevant feature name to previewFeaturesEnabled field in the provider configuration. Please always refer to the Getting Help section in our Github repo to best determine how to get help for your questions.

    Resource used to manage projection policies. For more information, check projection policy documentation.

    Example Usage

    Note Instead of using fully_qualified_name, you can reference objects managed outside Terraform by constructing a correct ID, consult identifiers guide.

    import * as pulumi from "@pulumi/pulumi";
import * as snowflake from "@pulumi/snowflake";

//# Minimal
const basic = new snowflake.ProjectionPolicy("basic", {
    database: "database_name",
    schema: "schema_name",
    name: "projection_policy_name",
    body: "PROJECTION_CONSTRAINT(ALLOW => false)",
});
//# Complete
const complete = new snowflake.ProjectionPolicy("complete", {
    database: "database_name",
    schema: "schema_name",
    name: "projection_policy_name",
    body: "PROJECTION_CONSTRAINT(ALLOW => true)",
    comment: "My projection policy",
});

    import pulumi
import pulumi_snowflake as snowflake

## Minimal
basic = snowflake.ProjectionPolicy("basic",
    database="database_name",
    schema="schema_name",
    name="projection_policy_name",
    body="PROJECTION_CONSTRAINT(ALLOW => false)")
## Complete
complete = snowflake.ProjectionPolicy("complete",
    database="database_name",
    schema="schema_name",
    name="projection_policy_name",
    body="PROJECTION_CONSTRAINT(ALLOW => true)",
    comment="My projection policy")

    package main

import (
	"github.com/pulumi/pulumi-snowflake/sdk/v2/go/snowflake"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		//# Minimal
		_, err := snowflake.NewProjectionPolicy(ctx, "basic", &snowflake.ProjectionPolicyArgs{
			Database: pulumi.String("database_name"),
			Schema:   pulumi.String("schema_name"),
			Name:     pulumi.String("projection_policy_name"),
			Body:     pulumi.String("PROJECTION_CONSTRAINT(ALLOW => false)"),
		})
		if err != nil {
			return err
		}
		//# Complete
		_, err = snowflake.NewProjectionPolicy(ctx, "complete", &snowflake.ProjectionPolicyArgs{
			Database: pulumi.String("database_name"),
			Schema:   pulumi.String("schema_name"),
			Name:     pulumi.String("projection_policy_name"),
			Body:     pulumi.String("PROJECTION_CONSTRAINT(ALLOW => true)"),
			Comment:  pulumi.String("My projection policy"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Snowflake = Pulumi.Snowflake;

return await Deployment.RunAsync(() => 
{
    //# Minimal
    var basic = new Snowflake.ProjectionPolicy("basic", new()
    {
        Database = "database_name",
        Schema = "schema_name",
        Name = "projection_policy_name",
        Body = "PROJECTION_CONSTRAINT(ALLOW => false)",
    });

    //# Complete
    var complete = new Snowflake.ProjectionPolicy("complete", new()
    {
        Database = "database_name",
        Schema = "schema_name",
        Name = "projection_policy_name",
        Body = "PROJECTION_CONSTRAINT(ALLOW => true)",
        Comment = "My projection policy",
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.ProjectionPolicy;
import com.pulumi.snowflake.ProjectionPolicyArgs;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        //# Minimal
        var basic = new ProjectionPolicy("basic", ProjectionPolicyArgs.builder()
            .database("database_name")
            .schema("schema_name")
            .name("projection_policy_name")
            .body("PROJECTION_CONSTRAINT(ALLOW => false)")
            .build());

        //# Complete
        var complete = new ProjectionPolicy("complete", ProjectionPolicyArgs.builder()
            .database("database_name")
            .schema("schema_name")
            .name("projection_policy_name")
            .body("PROJECTION_CONSTRAINT(ALLOW => true)")
            .comment("My projection policy")
            .build());

    }
}

    resources:
  ## Minimal
  basic:
    type: snowflake:ProjectionPolicy
    properties:
      database: database_name
      schema: schema_name
      name: projection_policy_name
      body: PROJECTION_CONSTRAINT(ALLOW => false)
  ## Complete
  complete:
    type: snowflake:ProjectionPolicy
    properties:
      database: database_name
      schema: schema_name
      name: projection_policy_name
      body: PROJECTION_CONSTRAINT(ALLOW => true)
      comment: My projection policy

    terraform {
  required_providers {
    snowflake = {
      source = "pulumi/snowflake"
    }
  }
}

## Minimal
resource "snowflake_projection_policy" "basic" {
  lifecycle {
    create_before_destroy = true
  }
  database = "database_name"
  schema   = "schema_name"
  name     = "projection_policy_name"
  body     = "PROJECTION_CONSTRAINT(ALLOW => false)"
}
## Complete
resource "snowflake_projection_policy" "complete" {
  lifecycle {
    create_before_destroy = true
  }
  database = "database_name"
  schema   = "schema_name"
  name     = "projection_policy_name"
  body     = "PROJECTION_CONSTRAINT(ALLOW => true)"
  comment  = "My projection policy"
}

    Note If a field has a default value, it is shown next to the type in the schema.

    Create ProjectionPolicy Resource

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

    Constructor syntax

    new ProjectionPolicy(name: string, args: ProjectionPolicyArgs, opts?: CustomResourceOptions);
    @overload
def ProjectionPolicy(resource_name: str,
                     args: ProjectionPolicyArgs,
                     opts: Optional[ResourceOptions] = None)

@overload
def ProjectionPolicy(resource_name: str,
                     opts: Optional[ResourceOptions] = None,
                     body: Optional[str] = None,
                     database: Optional[str] = None,
                     schema: Optional[str] = None,
                     comment: Optional[str] = None,
                     name: Optional[str] = None)
    func NewProjectionPolicy(ctx *Context, name string, args ProjectionPolicyArgs, opts ...ResourceOption) (*ProjectionPolicy, error)
    public ProjectionPolicy(string name, ProjectionPolicyArgs args, CustomResourceOptions? opts = null)
    public ProjectionPolicy(String name, ProjectionPolicyArgs args)
public ProjectionPolicy(String name, ProjectionPolicyArgs args, CustomResourceOptions options)

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


    resource "snowflake_projection_policy" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args ProjectionPolicyArgs
    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 ProjectionPolicyArgs
    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 ProjectionPolicyArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ProjectionPolicyArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ProjectionPolicyArgs
    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 projectionPolicyResource = new Snowflake.ProjectionPolicy("projectionPolicyResource", new()
{
    Body = "string",
    Database = "string",
    Schema = "string",
    Comment = "string",
    Name = "string",
});

    example, err := snowflake.NewProjectionPolicy(ctx, "projectionPolicyResource", &snowflake.ProjectionPolicyArgs{
	Body:     pulumi.String("string"),
	Database: pulumi.String("string"),
	Schema:   pulumi.String("string"),
	Comment:  pulumi.String("string"),
	Name:     pulumi.String("string"),
})

    resource "snowflake_projection_policy" "projectionPolicyResource" {
  lifecycle {
    create_before_destroy = true
  }
  body     = "string"
  database = "string"
  schema   = "string"
  comment  = "string"
  name     = "string"
}

    var projectionPolicyResource = new ProjectionPolicy("projectionPolicyResource", ProjectionPolicyArgs.builder()
    .body("string")
    .database("string")
    .schema("string")
    .comment("string")
    .name("string")
    .build());

    projection_policy_resource = snowflake.ProjectionPolicy("projectionPolicyResource",
    body="string",
    database="string",
    schema="string",
    comment="string",
    name="string")

    const projectionPolicyResource = new snowflake.ProjectionPolicy("projectionPolicyResource", {
    body: "string",
    database: "string",
    schema: "string",
    comment: "string",
    name: "string",
});

    type: snowflake:ProjectionPolicy
properties:
    body: string
    comment: string
    database: string
    name: string
    schema: string

    ProjectionPolicy 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 ProjectionPolicy resource accepts the following input properties:

    Body string
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    Database string
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Schema string
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Comment string
    Specifies a comment for the projection policy.
    Name string
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Body string
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    Database string
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Schema string
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Comment string
    Specifies a comment for the projection policy.
    Name string
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    body string
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    database string
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema string
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment string
    Specifies a comment for the projection policy.
    name string
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    body String
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    database String
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema String
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment String
    Specifies a comment for the projection policy.
    name String
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    body string
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    database string
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema string
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment string
    Specifies a comment for the projection policy.
    name string
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    body str
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    database str
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema str
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment str
    Specifies a comment for the projection policy.
    name str
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    body String
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    database String
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema String
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment String
    Specifies a comment for the projection policy.
    name String
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".

    Outputs

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

    DescribeOutputs List<ProjectionPolicyDescribeOutput>
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    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<ProjectionPolicyShowOutput>
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    DescribeOutputs []ProjectionPolicyDescribeOutput
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    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 []ProjectionPolicyShowOutput
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    describe_outputs list(object)
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    fully_qualified_name 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.
    show_outputs list(object)
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    describeOutputs List<ProjectionPolicyDescribeOutput>
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    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<ProjectionPolicyShowOutput>
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    describeOutputs ProjectionPolicyDescribeOutput[]
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    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 ProjectionPolicyShowOutput[]
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    describe_outputs Sequence[ProjectionPolicyDescribeOutput]
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    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[ProjectionPolicyShowOutput]
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    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 PROJECTION POLICIES for the given projection policy.

    Look up Existing ProjectionPolicy Resource

    Get an existing ProjectionPolicy 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?: ProjectionPolicyState, opts?: CustomResourceOptions): ProjectionPolicy
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        body: Optional[str] = None,
        comment: Optional[str] = None,
        database: Optional[str] = None,
        describe_outputs: Optional[Sequence[ProjectionPolicyDescribeOutputArgs]] = None,
        fully_qualified_name: Optional[str] = None,
        name: Optional[str] = None,
        schema: Optional[str] = None,
        show_outputs: Optional[Sequence[ProjectionPolicyShowOutputArgs]] = None) -> ProjectionPolicy
    func GetProjectionPolicy(ctx *Context, name string, id IDInput, state *ProjectionPolicyState, opts ...ResourceOption) (*ProjectionPolicy, error)
    public static ProjectionPolicy Get(string name, Input<string> id, ProjectionPolicyState? state, CustomResourceOptions? opts = null)
    public static ProjectionPolicy get(String name, Output<String> id, ProjectionPolicyState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:ProjectionPolicy    get:      id: ${id}
    import {
  to = snowflake_projection_policy.example
  id = "${id}"
}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Body string
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    Comment string
    Specifies a comment for the projection policy.
    Database string
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    DescribeOutputs List<ProjectionPolicyDescribeOutput>
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Name string
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Schema string
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    ShowOutputs List<ProjectionPolicyShowOutput>
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    Body string
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    Comment string
    Specifies a comment for the projection policy.
    Database string
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    DescribeOutputs []ProjectionPolicyDescribeOutputArgs
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Name string
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Schema string
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    ShowOutputs []ProjectionPolicyShowOutputArgs
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    body string
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    comment string
    Specifies a comment for the projection policy.
    database string
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describe_outputs list(object)
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    fully_qualified_name string
    Fully qualified name of the resource. For more information, see object name resolution.
    name string
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema string
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    show_outputs list(object)
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    body String
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    comment String
    Specifies a comment for the projection policy.
    database String
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs List<ProjectionPolicyDescribeOutput>
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    name String
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema String
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showOutputs List<ProjectionPolicyShowOutput>
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    body string
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    comment string
    Specifies a comment for the projection policy.
    database string
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs ProjectionPolicyDescribeOutput[]
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    name string
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema string
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showOutputs ProjectionPolicyShowOutput[]
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    body str
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    comment str
    Specifies a comment for the projection policy.
    database str
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describe_outputs Sequence[ProjectionPolicyDescribeOutputArgs]
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    name str
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema str
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    show_outputs Sequence[ProjectionPolicyShowOutputArgs]
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.
    body String
    SQL expression that determines whether to project a column. The expression must call PROJECTION_CONSTRAINT.
    comment String
    Specifies a comment for the projection policy.
    database String
    The database in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE PROJECTION POLICY for the given projection policy.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    name String
    Specifies the identifier for the projection policy; must be unique for the schema in which the projection policy is created. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    schema String
    The schema in which to create the projection policy. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showOutputs List<Property Map>
    Outputs the result of SHOW PROJECTION POLICIES for the given projection policy.

    Supporting Types

    ProjectionPolicyDescribeOutput, ProjectionPolicyDescribeOutputArgs

    Body string
    Name string
    ReturnType string
    Signature string
    Body string
    Name string
    ReturnType string
    Signature string
    body string
    name string
    return_type string
    signature string
    body String
    name String
    returnType String
    signature String
    body string
    name string
    returnType string
    signature string
    body String
    name String
    returnType String
    signature String

    ProjectionPolicyShowOutput, ProjectionPolicyShowOutputArgs

    Comment string
    CreatedOn string
    DatabaseName string
    Kind string
    Name string
    Options string
    Owner string
    OwnerRoleType string
    SchemaName string
    Comment string
    CreatedOn string
    DatabaseName string
    Kind string
    Name string
    Options string
    Owner string
    OwnerRoleType string
    SchemaName string
    comment string
    created_on string
    database_name string
    kind string
    name string
    options string
    owner string
    owner_role_type string
    schema_name string
    comment String
    createdOn String
    databaseName String
    kind String
    name String
    options String
    owner String
    ownerRoleType String
    schemaName String
    comment string
    createdOn string
    databaseName string
    kind string
    name string
    options string
    owner string
    ownerRoleType string
    schemaName string
    comment String
    createdOn String
    databaseName String
    kind String
    name String
    options String
    owner String
    ownerRoleType String
    schemaName String

    Import

    $ pulumi import snowflake:index/projectionPolicy:ProjectionPolicy example '"<database_name>"."<schema_name>"."<projection_policy_name>"'

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Viewing docs for Snowflake v2.23.0
    published on Friday, Nov 6, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-snowflake

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial