Sign in Dashboard Get started
  1. Packages
  2. Packages
  3. Snowflake Provider
  4. API Docs
  5. TableStorageLifecyclePolicyAttachment
Viewing docs for Snowflake v2.18.0
published on Wednesday, Jul 8, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

snowflake.TableStorageLifecyclePolicyAttachment

snowflake logo
Viewing docs for Snowflake v2.18.0
published on Wednesday, Jul 8, 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.

    Required warehouse For this resource, the provider uses policy references to get information about policies attached to tables. This function requires a warehouse in the connection. Please, make sure you have either set a DEFAULT_WAREHOUSE for the user, or specified a warehouse in the provider configuration.

    Specifies the storage lifecycle policy to attach to a table or a dynamic table.

    Example Usage

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

const slp = new snowflake.StorageLifecyclePolicy("slp", {
    database: "prod",
    schema: "security",
    name: "default_storage_lifecycle_policy",
    arguments: [{
        name: "VAL",
        type: "VARCHAR",
    }],
    body: "LENGTH(VAL) > 0",
});
const table = new snowflake.Table("table", {
    database: "prod",
    schema: "security",
    name: "my_table",
    columns: [{
        name: "VAL",
        type: "VARCHAR",
    }],
});
const dynamicTable = new snowflake.DynamicTable("dynamic_table", {
    database: "prod",
    schema: "security",
    name: "my_dynamic_table",
    targetLag: {
        maximumDuration: "20 minutes",
    },
    warehouse: "my_warehouse",
    query: "SELECT VAL FROM \"prod\".\"security\".\"my_table\"",
});
// Attaching a storage lifecycle policy to a table
const tableAttachment = new snowflake.TableStorageLifecyclePolicyAttachment("table_attachment", {
    tableName: table.fullyQualifiedName,
    tableType: "TABLE",
    storageLifecyclePolicyName: slp.fullyQualifiedName,
    ons: ["VAL"],
});
// Attaching a storage lifecycle policy to a dynamic table
const dynamicTableAttachment = new snowflake.TableStorageLifecyclePolicyAttachment("dynamic_table_attachment", {
    tableName: dynamicTable.fullyQualifiedName,
    tableType: "DYNAMIC_TABLE",
    storageLifecyclePolicyName: slp.fullyQualifiedName,
    ons: ["VAL"],
});

    import pulumi
import pulumi_snowflake as snowflake

slp = snowflake.StorageLifecyclePolicy("slp",
    database="prod",
    schema="security",
    name="default_storage_lifecycle_policy",
    arguments=[{
        "name": "VAL",
        "type": "VARCHAR",
    }],
    body="LENGTH(VAL) > 0")
table = snowflake.Table("table",
    database="prod",
    schema="security",
    name="my_table",
    columns=[{
        "name": "VAL",
        "type": "VARCHAR",
    }])
dynamic_table = snowflake.DynamicTable("dynamic_table",
    database="prod",
    schema="security",
    name="my_dynamic_table",
    target_lag={
        "maximum_duration": "20 minutes",
    },
    warehouse="my_warehouse",
    query="SELECT VAL FROM \"prod\".\"security\".\"my_table\"")
# Attaching a storage lifecycle policy to a table
table_attachment = snowflake.TableStorageLifecyclePolicyAttachment("table_attachment",
    table_name=table.fully_qualified_name,
    table_type="TABLE",
    storage_lifecycle_policy_name=slp.fully_qualified_name,
    ons=["VAL"])
# Attaching a storage lifecycle policy to a dynamic table
dynamic_table_attachment = snowflake.TableStorageLifecyclePolicyAttachment("dynamic_table_attachment",
    table_name=dynamic_table.fully_qualified_name,
    table_type="DYNAMIC_TABLE",
    storage_lifecycle_policy_name=slp.fully_qualified_name,
    ons=["VAL"])

    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 {
		slp, err := snowflake.NewStorageLifecyclePolicy(ctx, "slp", &snowflake.StorageLifecyclePolicyArgs{
			Database: pulumi.String("prod"),
			Schema:   pulumi.String("security"),
			Name:     pulumi.String("default_storage_lifecycle_policy"),
			Arguments: snowflake.StorageLifecyclePolicyArgumentArray{
				&snowflake.StorageLifecyclePolicyArgumentArgs{
					Name: pulumi.String("VAL"),
					Type: pulumi.String("VARCHAR"),
				},
			},
			Body: pulumi.String("LENGTH(VAL) > 0"),
		})
		if err != nil {
			return err
		}
		table, err := snowflake.NewTable(ctx, "table", &snowflake.TableArgs{
			Database: pulumi.String("prod"),
			Schema:   pulumi.String("security"),
			Name:     pulumi.String("my_table"),
			Columns: snowflake.TableColumnArray{
				&snowflake.TableColumnArgs{
					Name: pulumi.String("VAL"),
					Type: pulumi.String("VARCHAR"),
				},
			},
		})
		if err != nil {
			return err
		}
		dynamicTable, err := snowflake.NewDynamicTable(ctx, "dynamic_table", &snowflake.DynamicTableArgs{
			Database: pulumi.String("prod"),
			Schema:   pulumi.String("security"),
			Name:     pulumi.String("my_dynamic_table"),
			TargetLag: &snowflake.DynamicTableTargetLagArgs{
				MaximumDuration: pulumi.String("20 minutes"),
			},
			Warehouse: pulumi.String("my_warehouse"),
			Query:     pulumi.String("SELECT VAL FROM \"prod\".\"security\".\"my_table\""),
		})
		if err != nil {
			return err
		}
		// Attaching a storage lifecycle policy to a table
		_, err = snowflake.NewTableStorageLifecyclePolicyAttachment(ctx, "table_attachment", &snowflake.TableStorageLifecyclePolicyAttachmentArgs{
			TableName:                  table.FullyQualifiedName,
			TableType:                  pulumi.String("TABLE"),
			StorageLifecyclePolicyName: slp.FullyQualifiedName,
			Ons: pulumi.StringArray{
				pulumi.String("VAL"),
			},
		})
		if err != nil {
			return err
		}
		// Attaching a storage lifecycle policy to a dynamic table
		_, err = snowflake.NewTableStorageLifecyclePolicyAttachment(ctx, "dynamic_table_attachment", &snowflake.TableStorageLifecyclePolicyAttachmentArgs{
			TableName:                  dynamicTable.FullyQualifiedName,
			TableType:                  pulumi.String("DYNAMIC_TABLE"),
			StorageLifecyclePolicyName: slp.FullyQualifiedName,
			Ons: pulumi.StringArray{
				pulumi.String("VAL"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var slp = new Snowflake.StorageLifecyclePolicy("slp", new()
    {
        Database = "prod",
        Schema = "security",
        Name = "default_storage_lifecycle_policy",
        Arguments = new[]
        {
            new Snowflake.Inputs.StorageLifecyclePolicyArgumentArgs
            {
                Name = "VAL",
                Type = "VARCHAR",
            },
        },
        Body = "LENGTH(VAL) > 0",
    });

    var table = new Snowflake.Table("table", new()
    {
        Database = "prod",
        Schema = "security",
        Name = "my_table",
        Columns = new[]
        {
            new Snowflake.Inputs.TableColumnArgs
            {
                Name = "VAL",
                Type = "VARCHAR",
            },
        },
    });

    var dynamicTable = new Snowflake.DynamicTable("dynamic_table", new()
    {
        Database = "prod",
        Schema = "security",
        Name = "my_dynamic_table",
        TargetLag = new Snowflake.Inputs.DynamicTableTargetLagArgs
        {
            MaximumDuration = "20 minutes",
        },
        Warehouse = "my_warehouse",
        Query = "SELECT VAL FROM \"prod\".\"security\".\"my_table\"",
    });

    // Attaching a storage lifecycle policy to a table
    var tableAttachment = new Snowflake.TableStorageLifecyclePolicyAttachment("table_attachment", new()
    {
        TableName = table.FullyQualifiedName,
        TableType = "TABLE",
        StorageLifecyclePolicyName = slp.FullyQualifiedName,
        Ons = new[]
        {
            "VAL",
        },
    });

    // Attaching a storage lifecycle policy to a dynamic table
    var dynamicTableAttachment = new Snowflake.TableStorageLifecyclePolicyAttachment("dynamic_table_attachment", new()
    {
        TableName = dynamicTable.FullyQualifiedName,
        TableType = "DYNAMIC_TABLE",
        StorageLifecyclePolicyName = slp.FullyQualifiedName,
        Ons = new[]
        {
            "VAL",
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.StorageLifecyclePolicy;
import com.pulumi.snowflake.StorageLifecyclePolicyArgs;
import com.pulumi.snowflake.inputs.StorageLifecyclePolicyArgumentArgs;
import com.pulumi.snowflake.Table;
import com.pulumi.snowflake.TableArgs;
import com.pulumi.snowflake.inputs.TableColumnArgs;
import com.pulumi.snowflake.DynamicTable;
import com.pulumi.snowflake.DynamicTableArgs;
import com.pulumi.snowflake.inputs.DynamicTableTargetLagArgs;
import com.pulumi.snowflake.TableStorageLifecyclePolicyAttachment;
import com.pulumi.snowflake.TableStorageLifecyclePolicyAttachmentArgs;
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) {
        var slp = new StorageLifecyclePolicy("slp", StorageLifecyclePolicyArgs.builder()
            .database("prod")
            .schema("security")
            .name("default_storage_lifecycle_policy")
            .arguments(StorageLifecyclePolicyArgumentArgs.builder()
                .name("VAL")
                .type("VARCHAR")
                .build())
            .body("LENGTH(VAL) > 0")
            .build());

        var table = new Table("table", TableArgs.builder()
            .database("prod")
            .schema("security")
            .name("my_table")
            .columns(TableColumnArgs.builder()
                .name("VAL")
                .type("VARCHAR")
                .build())
            .build());

        var dynamicTable = new DynamicTable("dynamicTable", DynamicTableArgs.builder()
            .database("prod")
            .schema("security")
            .name("my_dynamic_table")
            .targetLag(DynamicTableTargetLagArgs.builder()
                .maximumDuration("20 minutes")
                .build())
            .warehouse("my_warehouse")
            .query("SELECT VAL FROM \"prod\".\"security\".\"my_table\"")
            .build());

        // Attaching a storage lifecycle policy to a table
        var tableAttachment = new TableStorageLifecyclePolicyAttachment("tableAttachment", TableStorageLifecyclePolicyAttachmentArgs.builder()
            .tableName(table.fullyQualifiedName())
            .tableType("TABLE")
            .storageLifecyclePolicyName(slp.fullyQualifiedName())
            .ons("VAL")
            .build());

        // Attaching a storage lifecycle policy to a dynamic table
        var dynamicTableAttachment = new TableStorageLifecyclePolicyAttachment("dynamicTableAttachment", TableStorageLifecyclePolicyAttachmentArgs.builder()
            .tableName(dynamicTable.fullyQualifiedName())
            .tableType("DYNAMIC_TABLE")
            .storageLifecyclePolicyName(slp.fullyQualifiedName())
            .ons("VAL")
            .build());

    }
}

    resources:
  slp:
    type: snowflake:StorageLifecyclePolicy
    properties:
      database: prod
      schema: security
      name: default_storage_lifecycle_policy
      arguments:
        - name: VAL
          type: VARCHAR
      body: LENGTH(VAL) > 0
  table:
    type: snowflake:Table
    properties:
      database: prod
      schema: security
      name: my_table
      columns:
        - name: VAL
          type: VARCHAR
  dynamicTable:
    type: snowflake:DynamicTable
    name: dynamic_table
    properties:
      database: prod
      schema: security
      name: my_dynamic_table
      targetLag:
        maximumDuration: 20 minutes
      warehouse: my_warehouse
      query: SELECT VAL FROM "prod"."security"."my_table"
  # Attaching a storage lifecycle policy to a table
  tableAttachment:
    type: snowflake:TableStorageLifecyclePolicyAttachment
    name: table_attachment
    properties:
      tableName: ${table.fullyQualifiedName}
      tableType: TABLE
      storageLifecyclePolicyName: ${slp.fullyQualifiedName}
      ons:
        - VAL
  # Attaching a storage lifecycle policy to a dynamic table
  dynamicTableAttachment:
    type: snowflake:TableStorageLifecyclePolicyAttachment
    name: dynamic_table_attachment
    properties:
      tableName: ${dynamicTable.fullyQualifiedName}
      tableType: DYNAMIC_TABLE
      storageLifecyclePolicyName: ${slp.fullyQualifiedName}
      ons:
        - VAL

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

resource "snowflake_storagelifecyclepolicy" "slp" {
  database = "prod"
  schema   = "security"
  name     = "default_storage_lifecycle_policy"
  arguments {
    name = "VAL"
    type = "VARCHAR"
  }
  body = "LENGTH(VAL) > 0"
}
resource "snowflake_table" "table" {
  database = "prod"
  schema   = "security"
  name     = "my_table"
  columns {
    name = "VAL"
    type = "VARCHAR"
  }
}
resource "snowflake_dynamictable" "dynamic_table" {
  database = "prod"
  schema   = "security"
  name     = "my_dynamic_table"
  target_lag = {
    maximum_duration = "20 minutes"
  }
  warehouse = "my_warehouse"
  query     = "SELECT VAL FROM \"prod\".\"security\".\"my_table\""
}
# Attaching a storage lifecycle policy to a table
resource "snowflake_tablestoragelifecyclepolicyattachment" "table_attachment" {
  table_name                    = snowflake_table.table.fully_qualified_name
  table_type                    = "TABLE"
  storage_lifecycle_policy_name = snowflake_storagelifecyclepolicy.slp.fully_qualified_name
  ons                           = ["VAL"]
}
# Attaching a storage lifecycle policy to a dynamic table
resource "snowflake_tablestoragelifecyclepolicyattachment" "dynamic_table_attachment" {
  table_name                    = snowflake_dynamictable.dynamic_table.fully_qualified_name
  table_type                    = "DYNAMIC_TABLE"
  storage_lifecycle_policy_name = snowflake_storagelifecyclepolicy.slp.fully_qualified_name
  ons                           = ["VAL"]
}

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

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

    Create TableStorageLifecyclePolicyAttachment Resource

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

    Constructor syntax

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

@overload
def TableStorageLifecyclePolicyAttachment(resource_name: str,
                                          opts: Optional[ResourceOptions] = None,
                                          ons: Optional[Sequence[str]] = None,
                                          storage_lifecycle_policy_name: Optional[str] = None,
                                          table_name: Optional[str] = None,
                                          table_type: Optional[str] = None)
    func NewTableStorageLifecyclePolicyAttachment(ctx *Context, name string, args TableStorageLifecyclePolicyAttachmentArgs, opts ...ResourceOption) (*TableStorageLifecyclePolicyAttachment, error)
    public TableStorageLifecyclePolicyAttachment(string name, TableStorageLifecyclePolicyAttachmentArgs args, CustomResourceOptions? opts = null)
    public TableStorageLifecyclePolicyAttachment(String name, TableStorageLifecyclePolicyAttachmentArgs args)
public TableStorageLifecyclePolicyAttachment(String name, TableStorageLifecyclePolicyAttachmentArgs args, CustomResourceOptions options)

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


    resource "snowflake_tablestoragelifecyclepolicyattachment" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args TableStorageLifecyclePolicyAttachmentArgs
    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 TableStorageLifecyclePolicyAttachmentArgs
    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 TableStorageLifecyclePolicyAttachmentArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args TableStorageLifecyclePolicyAttachmentArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args TableStorageLifecyclePolicyAttachmentArgs
    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 tableStorageLifecyclePolicyAttachmentResource = new Snowflake.TableStorageLifecyclePolicyAttachment("tableStorageLifecyclePolicyAttachmentResource", new()
{
    Ons = new[]
    {
        "string",
    },
    StorageLifecyclePolicyName = "string",
    TableName = "string",
    TableType = "string",
});

    example, err := snowflake.NewTableStorageLifecyclePolicyAttachment(ctx, "tableStorageLifecyclePolicyAttachmentResource", &snowflake.TableStorageLifecyclePolicyAttachmentArgs{
	Ons: pulumi.StringArray{
		pulumi.String("string"),
	},
	StorageLifecyclePolicyName: pulumi.String("string"),
	TableName:                  pulumi.String("string"),
	TableType:                  pulumi.String("string"),
})

    resource "snowflake_tablestoragelifecyclepolicyattachment" "tableStorageLifecyclePolicyAttachmentResource" {
  ons                           = ["string"]
  storage_lifecycle_policy_name = "string"
  table_name                    = "string"
  table_type                    = "string"
}

    var tableStorageLifecyclePolicyAttachmentResource = new TableStorageLifecyclePolicyAttachment("tableStorageLifecyclePolicyAttachmentResource", TableStorageLifecyclePolicyAttachmentArgs.builder()
    .ons("string")
    .storageLifecyclePolicyName("string")
    .tableName("string")
    .tableType("string")
    .build());

    table_storage_lifecycle_policy_attachment_resource = snowflake.TableStorageLifecyclePolicyAttachment("tableStorageLifecyclePolicyAttachmentResource",
    ons=["string"],
    storage_lifecycle_policy_name="string",
    table_name="string",
    table_type="string")

    const tableStorageLifecyclePolicyAttachmentResource = new snowflake.TableStorageLifecyclePolicyAttachment("tableStorageLifecyclePolicyAttachmentResource", {
    ons: ["string"],
    storageLifecyclePolicyName: "string",
    tableName: "string",
    tableType: "string",
});

    type: snowflake:TableStorageLifecyclePolicyAttachment
properties:
    ons:
        - string
    storageLifecyclePolicyName: string
    tableName: string
    tableType: string

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

    Ons List<string>
    List of the columns the storage lifecycle policy applies to.
    StorageLifecyclePolicyName string
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    TableName string
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    TableType string
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    Ons []string
    List of the columns the storage lifecycle policy applies to.
    StorageLifecyclePolicyName string
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    TableName string
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    TableType string
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons list(string)
    List of the columns the storage lifecycle policy applies to.
    storage_lifecycle_policy_name string
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    table_name string
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    table_type string
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons List<String>
    List of the columns the storage lifecycle policy applies to.
    storageLifecyclePolicyName String
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    tableName String
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    tableType String
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons string[]
    List of the columns the storage lifecycle policy applies to.
    storageLifecyclePolicyName string
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    tableName string
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    tableType string
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons Sequence[str]
    List of the columns the storage lifecycle policy applies to.
    storage_lifecycle_policy_name str
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    table_name str
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    table_type str
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons List<String>
    List of the columns the storage lifecycle policy applies to.
    storageLifecyclePolicyName String
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    tableName String
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    tableType String
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.

    Outputs

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

    Id string
    The provider-assigned unique ID for this managed resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing TableStorageLifecyclePolicyAttachment Resource

    Get an existing TableStorageLifecyclePolicyAttachment 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?: TableStorageLifecyclePolicyAttachmentState, opts?: CustomResourceOptions): TableStorageLifecyclePolicyAttachment
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        ons: Optional[Sequence[str]] = None,
        storage_lifecycle_policy_name: Optional[str] = None,
        table_name: Optional[str] = None,
        table_type: Optional[str] = None) -> TableStorageLifecyclePolicyAttachment
    func GetTableStorageLifecyclePolicyAttachment(ctx *Context, name string, id IDInput, state *TableStorageLifecyclePolicyAttachmentState, opts ...ResourceOption) (*TableStorageLifecyclePolicyAttachment, error)
    public static TableStorageLifecyclePolicyAttachment Get(string name, Input<string> id, TableStorageLifecyclePolicyAttachmentState? state, CustomResourceOptions? opts = null)
    public static TableStorageLifecyclePolicyAttachment get(String name, Output<String> id, TableStorageLifecyclePolicyAttachmentState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:TableStorageLifecyclePolicyAttachment    get:      id: ${id}
    import {
  to = snowflake_tablestoragelifecyclepolicyattachment.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:
    Ons List<string>
    List of the columns the storage lifecycle policy applies to.
    StorageLifecyclePolicyName string
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    TableName string
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    TableType string
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    Ons []string
    List of the columns the storage lifecycle policy applies to.
    StorageLifecyclePolicyName string
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    TableName string
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    TableType string
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons list(string)
    List of the columns the storage lifecycle policy applies to.
    storage_lifecycle_policy_name string
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    table_name string
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    table_type string
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons List<String>
    List of the columns the storage lifecycle policy applies to.
    storageLifecyclePolicyName String
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    tableName String
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    tableType String
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons string[]
    List of the columns the storage lifecycle policy applies to.
    storageLifecyclePolicyName string
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    tableName string
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    tableType string
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons Sequence[str]
    List of the columns the storage lifecycle policy applies to.
    storage_lifecycle_policy_name str
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    table_name str
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    table_type str
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.
    ons List<String>
    List of the columns the storage lifecycle policy applies to.
    storageLifecyclePolicyName String
    Fully qualified name of the storage lifecycle policy to attach to the table. Due to technical limitations (read more here), avoid using pipes (|).
    tableName String
    Fully qualified name of the table (or dynamic table) the storage lifecycle policy is attached to. Due to technical limitations (read more here), avoid using pipes (|).
    tableType String
    Specifies the type of the table referenced in tableName. Valid values are (case-insensitive): TABLE | DYNAMIC_TABLE.

    Import

    $ pulumi import snowflake:index/tableStorageLifecyclePolicyAttachment:TableStorageLifecyclePolicyAttachment example '"<database_name>"."<schema_name>"."<table_name>"|"<database_name>"."<schema_name>"."<storage_lifecycle_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.18.0
    published on Wednesday, Jul 8, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-snowflake

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial