Snowflake v1.3.0, Apr 23 25

Snowflake v1.3.0 published on Wednesday, Apr 23, 2025 by Pulumi

snowflake.DynamicTable

Explore with Pulumi AI

Snowflake v1.3.0 published on Wednesday, Apr 23, 2025 by Pulumi

Import

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

Create DynamicTable Resource

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

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.

TypeScript
Python
Go
C#
Java
YAML

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={
        "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

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

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: (Default: ON_CREATE) 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: (Default: false) Specifies whether to replace the dynamic table if it already exists.
RefreshMode string: (Default: AUTO) 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: (Default: ON_CREATE) 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: (Default: false) Specifies whether to replace the dynamic table if it already exists.
RefreshMode string: (Default: AUTO) 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: (Default: ON_CREATE) 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: (Default: false) Specifies whether to replace the dynamic table if it already exists.
refreshMode String: (Default: AUTO) 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: (Default: ON_CREATE) 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: (Default: false) Specifies whether to replace the dynamic table if it already exists.
refreshMode string: (Default: AUTO) 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: (Default: ON_CREATE) 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: (Default: false) Specifies whether to replace the dynamic table if it already exists.
refresh_mode str: (Default: AUTO) 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: (Default: ON_CREATE) 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: (Default: false) Specifies whether to replace the dynamic table if it already exists.
refreshMode String: (Default: AUTO) 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

TypeScript
Python
Go
C#
Java
YAML

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,
        fully_qualified_name: 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)

resources:  _:    type: snowflake:DynamicTable    get:      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:

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.
FullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
Initialize string: (Default: ON_CREATE) 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: (Default: false) 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: (Default: AUTO) 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.
FullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
Initialize string: (Default: ON_CREATE) 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: (Default: false) 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: (Default: AUTO) 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.
fullyQualifiedName String: Fully qualified name of the resource. For more information, see object name resolution.
initialize String: (Default: ON_CREATE) 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: (Default: false) 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: (Default: AUTO) 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.
fullyQualifiedName string: Fully qualified name of the resource. For more information, see object name resolution.
initialize string: (Default: ON_CREATE) 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: (Default: false) 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: (Default: AUTO) 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.
fully_qualified_name str: Fully qualified name of the resource. For more information, see object name resolution.
initialize str: (Default: ON_CREATE) 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: (Default: false) 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: (Default: AUTO) 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.
fullyQualifiedName String: Fully qualified name of the resource. For more information, see object name resolution.
initialize String: (Default: ON_CREATE) 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: (Default: false) 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: (Default: AUTO) 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.

Package Details

Repository: Snowflake pulumi/pulumi-snowflake
License: Apache-2.0
Notes: This Pulumi package is based on the snowflake Terraform Provider.

Snowflake v1.3.0 published on Wednesday, Apr 23, 2025 by Pulumi

pulumi/pulumi-snowflake

snowflake.DynamicTable

On this page

On this page

Import

Create DynamicTable Resource

Constructor syntax

Parameters

Constructor example

DynamicTable Resource Properties

Inputs

Outputs

Look up Existing DynamicTable Resource

Supporting Types

DynamicTableTargetLag
, DynamicTableTargetLagArgs

Package Details

On this page

On this page

snowflake.DynamicTable

On this page

On this page

Import

Create DynamicTable Resource

Constructor syntax

Parameters

Constructor example

DynamicTable Resource Properties

Inputs

Outputs

Look up Existing DynamicTable Resource

Supporting Types

DynamicTableTargetLag, DynamicTableTargetLagArgs

Package Details

On this page

On this page

DynamicTableTargetLag
, DynamicTableTargetLagArgs