1. Packages
  2. Snowflake
  3. API Docs
  4. DynamicTable
Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi

snowflake.DynamicTable

Explore with Pulumi AI

snowflake logo
Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as snowflake from "@pulumi/snowflake";
    
    // https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table#examples
    const dt = new snowflake.DynamicTable("dt", {
        name: "product",
        database: "mydb",
        schema: "myschema",
        targetLag: {
            maximumDuration: "20 minutes",
        },
        warehouse: "mywh",
        query: "SELECT product_id, product_name FROM \"mydb\".\"myschema\".\"staging_table\"",
        comment: "example comment",
    });
    
    import pulumi
    import pulumi_snowflake as snowflake
    
    # https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table#examples
    dt = snowflake.DynamicTable("dt",
        name="product",
        database="mydb",
        schema="myschema",
        target_lag=snowflake.DynamicTableTargetLagArgs(
            maximum_duration="20 minutes",
        ),
        warehouse="mywh",
        query="SELECT product_id, product_name FROM \"mydb\".\"myschema\".\"staging_table\"",
        comment="example comment")
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-snowflake/sdk/go/snowflake"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		// https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table#examples
    		_, err := snowflake.NewDynamicTable(ctx, "dt", &snowflake.DynamicTableArgs{
    			Name:     pulumi.String("product"),
    			Database: pulumi.String("mydb"),
    			Schema:   pulumi.String("myschema"),
    			TargetLag: &snowflake.DynamicTableTargetLagArgs{
    				MaximumDuration: pulumi.String("20 minutes"),
    			},
    			Warehouse: pulumi.String("mywh"),
    			Query:     pulumi.String("SELECT product_id, product_name FROM \"mydb\".\"myschema\".\"staging_table\""),
    			Comment:   pulumi.String("example comment"),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Snowflake = Pulumi.Snowflake;
    
    return await Deployment.RunAsync(() => 
    {
        // https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table#examples
        var dt = new Snowflake.DynamicTable("dt", new()
        {
            Name = "product",
            Database = "mydb",
            Schema = "myschema",
            TargetLag = new Snowflake.Inputs.DynamicTableTargetLagArgs
            {
                MaximumDuration = "20 minutes",
            },
            Warehouse = "mywh",
            Query = "SELECT product_id, product_name FROM \"mydb\".\"myschema\".\"staging_table\"",
            Comment = "example comment",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.snowflake.DynamicTable;
    import com.pulumi.snowflake.DynamicTableArgs;
    import com.pulumi.snowflake.inputs.DynamicTableTargetLagArgs;
    import java.util.List;
    import java.util.ArrayList;
    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) {
            // https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table#examples
            var dt = new DynamicTable("dt", DynamicTableArgs.builder()
                .name("product")
                .database("mydb")
                .schema("myschema")
                .targetLag(DynamicTableTargetLagArgs.builder()
                    .maximumDuration("20 minutes")
                    .build())
                .warehouse("mywh")
                .query("SELECT product_id, product_name FROM \"mydb\".\"myschema\".\"staging_table\"")
                .comment("example comment")
                .build());
    
        }
    }
    
    resources:
      # https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table#examples
      dt:
        type: snowflake:DynamicTable
        properties:
          name: product
          database: mydb
          schema: myschema
          targetLag:
            maximumDuration: 20 minutes
          warehouse: mywh
          query: SELECT product_id, product_name FROM "mydb"."myschema"."staging_table"
          comment: example comment
    

    Create DynamicTable Resource

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

    Constructor syntax

    new DynamicTable(name: string, args: DynamicTableArgs, opts?: CustomResourceOptions);
    @overload
    def DynamicTable(resource_name: str,
                     args: DynamicTableArgs,
                     opts: Optional[ResourceOptions] = None)
    
    @overload
    def DynamicTable(resource_name: str,
                     opts: Optional[ResourceOptions] = None,
                     database: Optional[str] = None,
                     query: Optional[str] = None,
                     schema: Optional[str] = None,
                     target_lag: Optional[DynamicTableTargetLagArgs] = None,
                     warehouse: Optional[str] = None,
                     comment: Optional[str] = None,
                     initialize: Optional[str] = None,
                     name: Optional[str] = None,
                     or_replace: Optional[bool] = None,
                     refresh_mode: Optional[str] = None)
    func NewDynamicTable(ctx *Context, name string, args DynamicTableArgs, opts ...ResourceOption) (*DynamicTable, error)
    public DynamicTable(string name, DynamicTableArgs args, CustomResourceOptions? opts = null)
    public DynamicTable(String name, DynamicTableArgs args)
    public DynamicTable(String name, DynamicTableArgs args, CustomResourceOptions options)
    
    type: snowflake:DynamicTable
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    

    Parameters

    name string
    The unique name of the resource.
    args DynamicTableArgs
    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 DynamicTableArgs
    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 DynamicTableArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DynamicTableArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DynamicTableArgs
    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 dynamicTableResource = new Snowflake.DynamicTable("dynamicTableResource", new()
    {
        Database = "string",
        Query = "string",
        Schema = "string",
        TargetLag = new Snowflake.Inputs.DynamicTableTargetLagArgs
        {
            Downstream = false,
            MaximumDuration = "string",
        },
        Warehouse = "string",
        Comment = "string",
        Initialize = "string",
        Name = "string",
        OrReplace = false,
        RefreshMode = "string",
    });
    
    example, err := snowflake.NewDynamicTable(ctx, "dynamicTableResource", &snowflake.DynamicTableArgs{
    	Database: pulumi.String("string"),
    	Query:    pulumi.String("string"),
    	Schema:   pulumi.String("string"),
    	TargetLag: &snowflake.DynamicTableTargetLagArgs{
    		Downstream:      pulumi.Bool(false),
    		MaximumDuration: pulumi.String("string"),
    	},
    	Warehouse:   pulumi.String("string"),
    	Comment:     pulumi.String("string"),
    	Initialize:  pulumi.String("string"),
    	Name:        pulumi.String("string"),
    	OrReplace:   pulumi.Bool(false),
    	RefreshMode: pulumi.String("string"),
    })
    
    var dynamicTableResource = new DynamicTable("dynamicTableResource", DynamicTableArgs.builder()
        .database("string")
        .query("string")
        .schema("string")
        .targetLag(DynamicTableTargetLagArgs.builder()
            .downstream(false)
            .maximumDuration("string")
            .build())
        .warehouse("string")
        .comment("string")
        .initialize("string")
        .name("string")
        .orReplace(false)
        .refreshMode("string")
        .build());
    
    dynamic_table_resource = snowflake.DynamicTable("dynamicTableResource",
        database="string",
        query="string",
        schema="string",
        target_lag=snowflake.DynamicTableTargetLagArgs(
            downstream=False,
            maximum_duration="string",
        ),
        warehouse="string",
        comment="string",
        initialize="string",
        name="string",
        or_replace=False,
        refresh_mode="string")
    
    const dynamicTableResource = new snowflake.DynamicTable("dynamicTableResource", {
        database: "string",
        query: "string",
        schema: "string",
        targetLag: {
            downstream: false,
            maximumDuration: "string",
        },
        warehouse: "string",
        comment: "string",
        initialize: "string",
        name: "string",
        orReplace: false,
        refreshMode: "string",
    });
    
    type: snowflake:DynamicTable
    properties:
        comment: string
        database: string
        initialize: string
        name: string
        orReplace: false
        query: string
        refreshMode: string
        schema: string
        targetLag:
            downstream: false
            maximumDuration: string
        warehouse: string
    

    DynamicTable Resource Properties

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

    Inputs

    The DynamicTable resource accepts the following input properties:

    Database string
    The database in which to create the dynamic table.
    Query string
    Specifies the query to use to populate the dynamic table.
    Schema string
    The schema in which to create the dynamic table.
    TargetLag DynamicTableTargetLag
    Specifies the target lag time for the dynamic table.
    Warehouse string
    The warehouse in which to create the dynamic table.
    Comment string
    Specifies a comment for the dynamic table.
    Initialize string
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    Name string
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    OrReplace bool
    Specifies whether to replace the dynamic table if it already exists.
    RefreshMode string
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    Database string
    The database in which to create the dynamic table.
    Query string
    Specifies the query to use to populate the dynamic table.
    Schema string
    The schema in which to create the dynamic table.
    TargetLag DynamicTableTargetLagArgs
    Specifies the target lag time for the dynamic table.
    Warehouse string
    The warehouse in which to create the dynamic table.
    Comment string
    Specifies a comment for the dynamic table.
    Initialize string
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    Name string
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    OrReplace bool
    Specifies whether to replace the dynamic table if it already exists.
    RefreshMode string
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    database String
    The database in which to create the dynamic table.
    query String
    Specifies the query to use to populate the dynamic table.
    schema String
    The schema in which to create the dynamic table.
    targetLag DynamicTableTargetLag
    Specifies the target lag time for the dynamic table.
    warehouse String
    The warehouse in which to create the dynamic table.
    comment String
    Specifies a comment for the dynamic table.
    initialize String
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    name String
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    orReplace Boolean
    Specifies whether to replace the dynamic table if it already exists.
    refreshMode String
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    database string
    The database in which to create the dynamic table.
    query string
    Specifies the query to use to populate the dynamic table.
    schema string
    The schema in which to create the dynamic table.
    targetLag DynamicTableTargetLag
    Specifies the target lag time for the dynamic table.
    warehouse string
    The warehouse in which to create the dynamic table.
    comment string
    Specifies a comment for the dynamic table.
    initialize string
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    name string
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    orReplace boolean
    Specifies whether to replace the dynamic table if it already exists.
    refreshMode string
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    database str
    The database in which to create the dynamic table.
    query str
    Specifies the query to use to populate the dynamic table.
    schema str
    The schema in which to create the dynamic table.
    target_lag DynamicTableTargetLagArgs
    Specifies the target lag time for the dynamic table.
    warehouse str
    The warehouse in which to create the dynamic table.
    comment str
    Specifies a comment for the dynamic table.
    initialize str
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    name str
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    or_replace bool
    Specifies whether to replace the dynamic table if it already exists.
    refresh_mode str
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    database String
    The database in which to create the dynamic table.
    query String
    Specifies the query to use to populate the dynamic table.
    schema String
    The schema in which to create the dynamic table.
    targetLag Property Map
    Specifies the target lag time for the dynamic table.
    warehouse String
    The warehouse in which to create the dynamic table.
    comment String
    Specifies a comment for the dynamic table.
    initialize String
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    name String
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    orReplace Boolean
    Specifies whether to replace the dynamic table if it already exists.
    refreshMode String
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.

    Outputs

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

    AutomaticClustering bool
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    Bytes int
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    ClusterBy string
    The clustering key for the dynamic table.
    CreatedOn string
    Time when this dynamic table was created.
    DataTimestamp string
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    Id string
    The provider-assigned unique ID for this managed resource.
    IsClone bool
    TRUE if the dynamic table has been cloned, else FALSE.
    IsReplica bool
    TRUE if the dynamic table is a replica. else FALSE.
    LastSuspendedOn string
    Timestamp of last suspension.
    Owner string
    Role that owns the dynamic table.
    RefreshModeReason string
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    Rows int
    Number of rows in the table.
    SchedulingState string
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    AutomaticClustering bool
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    Bytes int
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    ClusterBy string
    The clustering key for the dynamic table.
    CreatedOn string
    Time when this dynamic table was created.
    DataTimestamp string
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    Id string
    The provider-assigned unique ID for this managed resource.
    IsClone bool
    TRUE if the dynamic table has been cloned, else FALSE.
    IsReplica bool
    TRUE if the dynamic table is a replica. else FALSE.
    LastSuspendedOn string
    Timestamp of last suspension.
    Owner string
    Role that owns the dynamic table.
    RefreshModeReason string
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    Rows int
    Number of rows in the table.
    SchedulingState string
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    automaticClustering Boolean
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    bytes Integer
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    clusterBy String
    The clustering key for the dynamic table.
    createdOn String
    Time when this dynamic table was created.
    dataTimestamp String
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    id String
    The provider-assigned unique ID for this managed resource.
    isClone Boolean
    TRUE if the dynamic table has been cloned, else FALSE.
    isReplica Boolean
    TRUE if the dynamic table is a replica. else FALSE.
    lastSuspendedOn String
    Timestamp of last suspension.
    owner String
    Role that owns the dynamic table.
    refreshModeReason String
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    rows Integer
    Number of rows in the table.
    schedulingState String
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    automaticClustering boolean
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    bytes number
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    clusterBy string
    The clustering key for the dynamic table.
    createdOn string
    Time when this dynamic table was created.
    dataTimestamp string
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    id string
    The provider-assigned unique ID for this managed resource.
    isClone boolean
    TRUE if the dynamic table has been cloned, else FALSE.
    isReplica boolean
    TRUE if the dynamic table is a replica. else FALSE.
    lastSuspendedOn string
    Timestamp of last suspension.
    owner string
    Role that owns the dynamic table.
    refreshModeReason string
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    rows number
    Number of rows in the table.
    schedulingState string
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    automatic_clustering bool
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    bytes int
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    cluster_by str
    The clustering key for the dynamic table.
    created_on str
    Time when this dynamic table was created.
    data_timestamp str
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    id str
    The provider-assigned unique ID for this managed resource.
    is_clone bool
    TRUE if the dynamic table has been cloned, else FALSE.
    is_replica bool
    TRUE if the dynamic table is a replica. else FALSE.
    last_suspended_on str
    Timestamp of last suspension.
    owner str
    Role that owns the dynamic table.
    refresh_mode_reason str
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    rows int
    Number of rows in the table.
    scheduling_state str
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    automaticClustering Boolean
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    bytes Number
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    clusterBy String
    The clustering key for the dynamic table.
    createdOn String
    Time when this dynamic table was created.
    dataTimestamp String
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    id String
    The provider-assigned unique ID for this managed resource.
    isClone Boolean
    TRUE if the dynamic table has been cloned, else FALSE.
    isReplica Boolean
    TRUE if the dynamic table is a replica. else FALSE.
    lastSuspendedOn String
    Timestamp of last suspension.
    owner String
    Role that owns the dynamic table.
    refreshModeReason String
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    rows Number
    Number of rows in the table.
    schedulingState String
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.

    Look up Existing DynamicTable Resource

    Get an existing DynamicTable 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?: DynamicTableState, opts?: CustomResourceOptions): DynamicTable
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            automatic_clustering: Optional[bool] = None,
            bytes: Optional[int] = None,
            cluster_by: Optional[str] = None,
            comment: Optional[str] = None,
            created_on: Optional[str] = None,
            data_timestamp: Optional[str] = None,
            database: Optional[str] = None,
            initialize: Optional[str] = None,
            is_clone: Optional[bool] = None,
            is_replica: Optional[bool] = None,
            last_suspended_on: Optional[str] = None,
            name: Optional[str] = None,
            or_replace: Optional[bool] = None,
            owner: Optional[str] = None,
            query: Optional[str] = None,
            refresh_mode: Optional[str] = None,
            refresh_mode_reason: Optional[str] = None,
            rows: Optional[int] = None,
            scheduling_state: Optional[str] = None,
            schema: Optional[str] = None,
            target_lag: Optional[DynamicTableTargetLagArgs] = None,
            warehouse: Optional[str] = None) -> DynamicTable
    func GetDynamicTable(ctx *Context, name string, id IDInput, state *DynamicTableState, opts ...ResourceOption) (*DynamicTable, error)
    public static DynamicTable Get(string name, Input<string> id, DynamicTableState? state, CustomResourceOptions? opts = null)
    public static DynamicTable get(String name, Output<String> id, DynamicTableState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AutomaticClustering bool
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    Bytes int
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    ClusterBy string
    The clustering key for the dynamic table.
    Comment string
    Specifies a comment for the dynamic table.
    CreatedOn string
    Time when this dynamic table was created.
    DataTimestamp string
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    Database string
    The database in which to create the dynamic table.
    Initialize string
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    IsClone bool
    TRUE if the dynamic table has been cloned, else FALSE.
    IsReplica bool
    TRUE if the dynamic table is a replica. else FALSE.
    LastSuspendedOn string
    Timestamp of last suspension.
    Name string
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    OrReplace bool
    Specifies whether to replace the dynamic table if it already exists.
    Owner string
    Role that owns the dynamic table.
    Query string
    Specifies the query to use to populate the dynamic table.
    RefreshMode string
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    RefreshModeReason string
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    Rows int
    Number of rows in the table.
    SchedulingState string
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    Schema string
    The schema in which to create the dynamic table.
    TargetLag DynamicTableTargetLag
    Specifies the target lag time for the dynamic table.
    Warehouse string
    The warehouse in which to create the dynamic table.
    AutomaticClustering bool
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    Bytes int
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    ClusterBy string
    The clustering key for the dynamic table.
    Comment string
    Specifies a comment for the dynamic table.
    CreatedOn string
    Time when this dynamic table was created.
    DataTimestamp string
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    Database string
    The database in which to create the dynamic table.
    Initialize string
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    IsClone bool
    TRUE if the dynamic table has been cloned, else FALSE.
    IsReplica bool
    TRUE if the dynamic table is a replica. else FALSE.
    LastSuspendedOn string
    Timestamp of last suspension.
    Name string
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    OrReplace bool
    Specifies whether to replace the dynamic table if it already exists.
    Owner string
    Role that owns the dynamic table.
    Query string
    Specifies the query to use to populate the dynamic table.
    RefreshMode string
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    RefreshModeReason string
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    Rows int
    Number of rows in the table.
    SchedulingState string
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    Schema string
    The schema in which to create the dynamic table.
    TargetLag DynamicTableTargetLagArgs
    Specifies the target lag time for the dynamic table.
    Warehouse string
    The warehouse in which to create the dynamic table.
    automaticClustering Boolean
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    bytes Integer
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    clusterBy String
    The clustering key for the dynamic table.
    comment String
    Specifies a comment for the dynamic table.
    createdOn String
    Time when this dynamic table was created.
    dataTimestamp String
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    database String
    The database in which to create the dynamic table.
    initialize String
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    isClone Boolean
    TRUE if the dynamic table has been cloned, else FALSE.
    isReplica Boolean
    TRUE if the dynamic table is a replica. else FALSE.
    lastSuspendedOn String
    Timestamp of last suspension.
    name String
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    orReplace Boolean
    Specifies whether to replace the dynamic table if it already exists.
    owner String
    Role that owns the dynamic table.
    query String
    Specifies the query to use to populate the dynamic table.
    refreshMode String
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    refreshModeReason String
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    rows Integer
    Number of rows in the table.
    schedulingState String
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    schema String
    The schema in which to create the dynamic table.
    targetLag DynamicTableTargetLag
    Specifies the target lag time for the dynamic table.
    warehouse String
    The warehouse in which to create the dynamic table.
    automaticClustering boolean
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    bytes number
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    clusterBy string
    The clustering key for the dynamic table.
    comment string
    Specifies a comment for the dynamic table.
    createdOn string
    Time when this dynamic table was created.
    dataTimestamp string
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    database string
    The database in which to create the dynamic table.
    initialize string
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    isClone boolean
    TRUE if the dynamic table has been cloned, else FALSE.
    isReplica boolean
    TRUE if the dynamic table is a replica. else FALSE.
    lastSuspendedOn string
    Timestamp of last suspension.
    name string
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    orReplace boolean
    Specifies whether to replace the dynamic table if it already exists.
    owner string
    Role that owns the dynamic table.
    query string
    Specifies the query to use to populate the dynamic table.
    refreshMode string
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    refreshModeReason string
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    rows number
    Number of rows in the table.
    schedulingState string
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    schema string
    The schema in which to create the dynamic table.
    targetLag DynamicTableTargetLag
    Specifies the target lag time for the dynamic table.
    warehouse string
    The warehouse in which to create the dynamic table.
    automatic_clustering bool
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    bytes int
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    cluster_by str
    The clustering key for the dynamic table.
    comment str
    Specifies a comment for the dynamic table.
    created_on str
    Time when this dynamic table was created.
    data_timestamp str
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    database str
    The database in which to create the dynamic table.
    initialize str
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    is_clone bool
    TRUE if the dynamic table has been cloned, else FALSE.
    is_replica bool
    TRUE if the dynamic table is a replica. else FALSE.
    last_suspended_on str
    Timestamp of last suspension.
    name str
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    or_replace bool
    Specifies whether to replace the dynamic table if it already exists.
    owner str
    Role that owns the dynamic table.
    query str
    Specifies the query to use to populate the dynamic table.
    refresh_mode str
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    refresh_mode_reason str
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    rows int
    Number of rows in the table.
    scheduling_state str
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    schema str
    The schema in which to create the dynamic table.
    target_lag DynamicTableTargetLagArgs
    Specifies the target lag time for the dynamic table.
    warehouse str
    The warehouse in which to create the dynamic table.
    automaticClustering Boolean
    Whether auto-clustering is enabled on the dynamic table. Not currently supported for dynamic tables.
    bytes Number
    Number of bytes that will be scanned if the entire dynamic table is scanned in a query.
    clusterBy String
    The clustering key for the dynamic table.
    comment String
    Specifies a comment for the dynamic table.
    createdOn String
    Time when this dynamic table was created.
    dataTimestamp String
    Timestamp of the data in the base object(s) that is included in the dynamic table.
    database String
    The database in which to create the dynamic table.
    initialize String
    Initialize trigger for the dynamic table. Can only be set on creation. Available options are ONCREATE and ONSCHEDULE.
    isClone Boolean
    TRUE if the dynamic table has been cloned, else FALSE.
    isReplica Boolean
    TRUE if the dynamic table is a replica. else FALSE.
    lastSuspendedOn String
    Timestamp of last suspension.
    name String
    Specifies the identifier (i.e. name) for the dynamic table; must be unique for the schema in which the dynamic table is created.
    orReplace Boolean
    Specifies whether to replace the dynamic table if it already exists.
    owner String
    Role that owns the dynamic table.
    query String
    Specifies the query to use to populate the dynamic table.
    refreshMode String
    INCREMENTAL to use incremental refreshes, FULL to recompute the whole table on every refresh, or AUTO to let Snowflake decide.
    refreshModeReason String
    Explanation for why FULL refresh mode was chosen. NULL if refresh mode is not FULL.
    rows Number
    Number of rows in the table.
    schedulingState String
    Displays ACTIVE for dynamic tables that are actively scheduling refreshes and SUSPENDED for suspended dynamic tables.
    schema String
    The schema in which to create the dynamic table.
    targetLag Property Map
    Specifies the target lag time for the dynamic table.
    warehouse String
    The warehouse in which to create the dynamic table.

    Supporting Types

    DynamicTableTargetLag, DynamicTableTargetLagArgs

    Downstream bool
    Specifies whether the target lag time is downstream.
    MaximumDuration string
    Specifies the maximum target lag time for the dynamic table.
    Downstream bool
    Specifies whether the target lag time is downstream.
    MaximumDuration string
    Specifies the maximum target lag time for the dynamic table.
    downstream Boolean
    Specifies whether the target lag time is downstream.
    maximumDuration String
    Specifies the maximum target lag time for the dynamic table.
    downstream boolean
    Specifies whether the target lag time is downstream.
    maximumDuration string
    Specifies the maximum target lag time for the dynamic table.
    downstream bool
    Specifies whether the target lag time is downstream.
    maximum_duration str
    Specifies the maximum target lag time for the dynamic table.
    downstream Boolean
    Specifies whether the target lag time is downstream.
    maximumDuration String
    Specifies the maximum target lag time for the dynamic table.

    Import

    $ pulumi import snowflake:index/dynamicTable:DynamicTable dt "mydb|myschema|product"
    

    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
    Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi