Sign in Dashboard Get started
  1. Registry
  2. Packages
  3. Snowflake Provider
  4. API Docs
  5. HybridTable
Viewing docs for Snowflake v2.20.0
published on Saturday, Aug 22, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-snowflake

snowflake.HybridTable

snowflake logo
Viewing docs for Snowflake v2.20.0
published on Saturday, Aug 22, 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.

    Note primaryKeyConstraint, uniqueConstraint, and foreignKeyConstraint can only be set at creation time; changing or removing them recreates the whole table.

    Resource used to manage hybrid tables. For more information, check hybrid tables documentation.

    Example Usage

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

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

// basic resource
const basic = new snowflake.HybridTable("basic", {
    database: "DATABASE",
    schema: "SCHEMA",
    name: "HYBRID_TABLE",
    columns: [{
        name: "ID",
        type: "NUMBER(38,0)",
        notNull: true,
    }],
    primaryKeyConstraint: {
        columns: ["ID"],
    },
});
// complete resource
const complete = new snowflake.HybridTable("complete", {
    database: "DATABASE",
    schema: "SCHEMA",
    name: "HYBRID_TABLE",
    comment: "A hybrid table for HTAP workloads",
    dataRetentionTimeInDays: 7,
    maxDataExtensionTimeInDays: 14,
    columns: [
        {
            name: "ID",
            type: "NUMBER(38,0)",
            notNull: true,
        },
        {
            name: "NAME",
            type: "VARCHAR(256)",
            notNull: false,
            collate: "en-ci",
            comment: "Name column",
        },
        {
            name: "CREATED_AT",
            type: "TIMESTAMP_NTZ",
            notNull: true,
            "default": {
                expression: "CURRENT_TIMESTAMP()",
            },
        },
        {
            name: "STATUS",
            type: "VARCHAR(256)",
            "default": {
                constant: "ACTIVE",
            },
        },
        {
            name: "SEQ_ID",
            type: "NUMBER(38,0)",
            "default": {
                sequence: "DATABASE.SCHEMA.MY_SEQUENCE",
            },
        },
        {
            name: "PARENT_ID",
            type: "NUMBER(38,0)",
            notNull: true,
        },
    ],
    primaryKeyConstraint: {
        name: "pk_hybrid_table",
        columns: ["ID"],
    },
    uniqueConstraints: [{
        name: "uq_name",
        columns: ["NAME"],
    }],
    foreignKeyConstraints: [{
        name: "fk_parent",
        columns: ["PARENT_ID"],
        tableName: "DATABASE.SCHEMA.PARENT_HYBRID_TABLE",
        refColumns: ["ID"],
    }],
    indices: [
        {
            name: "idx_name",
            columns: ["NAME"],
        },
        {
            name: "idx_name_created_at",
            columns: ["NAME"],
            includeColumns: ["CREATED_AT"],
        },
    ],
});

    import pulumi
import pulumi_snowflake as snowflake

# basic resource
basic = snowflake.HybridTable("basic",
    database="DATABASE",
    schema="SCHEMA",
    name="HYBRID_TABLE",
    columns=[{
        "name": "ID",
        "type": "NUMBER(38,0)",
        "not_null": True,
    }],
    primary_key_constraint={
        "columns": ["ID"],
    })
# complete resource
complete = snowflake.HybridTable("complete",
    database="DATABASE",
    schema="SCHEMA",
    name="HYBRID_TABLE",
    comment="A hybrid table for HTAP workloads",
    data_retention_time_in_days=7,
    max_data_extension_time_in_days=14,
    columns=[
        {
            "name": "ID",
            "type": "NUMBER(38,0)",
            "not_null": True,
        },
        {
            "name": "NAME",
            "type": "VARCHAR(256)",
            "not_null": False,
            "collate": "en-ci",
            "comment": "Name column",
        },
        {
            "name": "CREATED_AT",
            "type": "TIMESTAMP_NTZ",
            "not_null": True,
            "default": {
                "expression": "CURRENT_TIMESTAMP()",
            },
        },
        {
            "name": "STATUS",
            "type": "VARCHAR(256)",
            "default": {
                "constant": "ACTIVE",
            },
        },
        {
            "name": "SEQ_ID",
            "type": "NUMBER(38,0)",
            "default": {
                "sequence": "DATABASE.SCHEMA.MY_SEQUENCE",
            },
        },
        {
            "name": "PARENT_ID",
            "type": "NUMBER(38,0)",
            "not_null": True,
        },
    ],
    primary_key_constraint={
        "name": "pk_hybrid_table",
        "columns": ["ID"],
    },
    unique_constraints=[{
        "name": "uq_name",
        "columns": ["NAME"],
    }],
    foreign_key_constraints=[{
        "name": "fk_parent",
        "columns": ["PARENT_ID"],
        "table_name": "DATABASE.SCHEMA.PARENT_HYBRID_TABLE",
        "ref_columns": ["ID"],
    }],
    indices=[
        {
            "name": "idx_name",
            "columns": ["NAME"],
        },
        {
            "name": "idx_name_created_at",
            "columns": ["NAME"],
            "include_columns": ["CREATED_AT"],
        },
    ])

    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 {
		// basic resource
		_, err := snowflake.NewHybridTable(ctx, "basic", &snowflake.HybridTableArgs{
			Database: pulumi.String("DATABASE"),
			Schema:   pulumi.String("SCHEMA"),
			Name:     pulumi.String("HYBRID_TABLE"),
			Columns: snowflake.HybridTableColumnArray{
				&snowflake.HybridTableColumnArgs{
					Name:    pulumi.String("ID"),
					Type:    pulumi.String("NUMBER(38,0)"),
					NotNull: pulumi.Bool(true),
				},
			},
			PrimaryKeyConstraint: &snowflake.HybridTablePrimaryKeyConstraintArgs{
				Columns: pulumi.StringArray{
					pulumi.String("ID"),
				},
			},
		})
		if err != nil {
			return err
		}
		// complete resource
		_, err = snowflake.NewHybridTable(ctx, "complete", &snowflake.HybridTableArgs{
			Database:                   pulumi.String("DATABASE"),
			Schema:                     pulumi.String("SCHEMA"),
			Name:                       pulumi.String("HYBRID_TABLE"),
			Comment:                    pulumi.String("A hybrid table for HTAP workloads"),
			DataRetentionTimeInDays:    pulumi.Int(7),
			MaxDataExtensionTimeInDays: pulumi.Int(14),
			Columns: snowflake.HybridTableColumnArray{
				&snowflake.HybridTableColumnArgs{
					Name:    pulumi.String("ID"),
					Type:    pulumi.String("NUMBER(38,0)"),
					NotNull: pulumi.Bool(true),
				},
				&snowflake.HybridTableColumnArgs{
					Name:    pulumi.String("NAME"),
					Type:    pulumi.String("VARCHAR(256)"),
					NotNull: pulumi.Bool(false),
					Collate: pulumi.String("en-ci"),
					Comment: pulumi.String("Name column"),
				},
				&snowflake.HybridTableColumnArgs{
					Name:    pulumi.String("CREATED_AT"),
					Type:    pulumi.String("TIMESTAMP_NTZ"),
					NotNull: pulumi.Bool(true),
					Default: &snowflake.HybridTableColumnDefaultArgs{
						Expression: pulumi.String("CURRENT_TIMESTAMP()"),
					},
				},
				&snowflake.HybridTableColumnArgs{
					Name: pulumi.String("STATUS"),
					Type: pulumi.String("VARCHAR(256)"),
					Default: &snowflake.HybridTableColumnDefaultArgs{
						Constant: pulumi.String("ACTIVE"),
					},
				},
				&snowflake.HybridTableColumnArgs{
					Name: pulumi.String("SEQ_ID"),
					Type: pulumi.String("NUMBER(38,0)"),
					Default: &snowflake.HybridTableColumnDefaultArgs{
						Sequence: pulumi.String("DATABASE.SCHEMA.MY_SEQUENCE"),
					},
				},
				&snowflake.HybridTableColumnArgs{
					Name:    pulumi.String("PARENT_ID"),
					Type:    pulumi.String("NUMBER(38,0)"),
					NotNull: pulumi.Bool(true),
				},
			},
			PrimaryKeyConstraint: &snowflake.HybridTablePrimaryKeyConstraintArgs{
				Name: pulumi.String("pk_hybrid_table"),
				Columns: pulumi.StringArray{
					pulumi.String("ID"),
				},
			},
			UniqueConstraints: snowflake.HybridTableUniqueConstraintArray{
				&snowflake.HybridTableUniqueConstraintArgs{
					Name: pulumi.String("uq_name"),
					Columns: pulumi.StringArray{
						pulumi.String("NAME"),
					},
				},
			},
			ForeignKeyConstraints: snowflake.HybridTableForeignKeyConstraintArray{
				&snowflake.HybridTableForeignKeyConstraintArgs{
					Name: pulumi.String("fk_parent"),
					Columns: pulumi.StringArray{
						pulumi.String("PARENT_ID"),
					},
					TableName: pulumi.String("DATABASE.SCHEMA.PARENT_HYBRID_TABLE"),
					RefColumns: pulumi.StringArray{
						pulumi.String("ID"),
					},
				},
			},
			Indices: snowflake.HybridTableIndexArray{
				&snowflake.HybridTableIndexArgs{
					Name: pulumi.String("idx_name"),
					Columns: pulumi.StringArray{
						pulumi.String("NAME"),
					},
				},
				&snowflake.HybridTableIndexArgs{
					Name: pulumi.String("idx_name_created_at"),
					Columns: pulumi.StringArray{
						pulumi.String("NAME"),
					},
					IncludeColumns: pulumi.StringArray{
						pulumi.String("CREATED_AT"),
					},
				},
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    // basic resource
    var basic = new Snowflake.HybridTable("basic", new()
    {
        Database = "DATABASE",
        Schema = "SCHEMA",
        Name = "HYBRID_TABLE",
        Columns = new[]
        {
            new Snowflake.Inputs.HybridTableColumnArgs
            {
                Name = "ID",
                Type = "NUMBER(38,0)",
                NotNull = true,
            },
        },
        PrimaryKeyConstraint = new Snowflake.Inputs.HybridTablePrimaryKeyConstraintArgs
        {
            Columns = new[]
            {
                "ID",
            },
        },
    });

    // complete resource
    var complete = new Snowflake.HybridTable("complete", new()
    {
        Database = "DATABASE",
        Schema = "SCHEMA",
        Name = "HYBRID_TABLE",
        Comment = "A hybrid table for HTAP workloads",
        DataRetentionTimeInDays = 7,
        MaxDataExtensionTimeInDays = 14,
        Columns = new[]
        {
            new Snowflake.Inputs.HybridTableColumnArgs
            {
                Name = "ID",
                Type = "NUMBER(38,0)",
                NotNull = true,
            },
            new Snowflake.Inputs.HybridTableColumnArgs
            {
                Name = "NAME",
                Type = "VARCHAR(256)",
                NotNull = false,
                Collate = "en-ci",
                Comment = "Name column",
            },
            new Snowflake.Inputs.HybridTableColumnArgs
            {
                Name = "CREATED_AT",
                Type = "TIMESTAMP_NTZ",
                NotNull = true,
                Default = new Snowflake.Inputs.HybridTableColumnDefaultArgs
                {
                    Expression = "CURRENT_TIMESTAMP()",
                },
            },
            new Snowflake.Inputs.HybridTableColumnArgs
            {
                Name = "STATUS",
                Type = "VARCHAR(256)",
                Default = new Snowflake.Inputs.HybridTableColumnDefaultArgs
                {
                    Constant = "ACTIVE",
                },
            },
            new Snowflake.Inputs.HybridTableColumnArgs
            {
                Name = "SEQ_ID",
                Type = "NUMBER(38,0)",
                Default = new Snowflake.Inputs.HybridTableColumnDefaultArgs
                {
                    Sequence = "DATABASE.SCHEMA.MY_SEQUENCE",
                },
            },
            new Snowflake.Inputs.HybridTableColumnArgs
            {
                Name = "PARENT_ID",
                Type = "NUMBER(38,0)",
                NotNull = true,
            },
        },
        PrimaryKeyConstraint = new Snowflake.Inputs.HybridTablePrimaryKeyConstraintArgs
        {
            Name = "pk_hybrid_table",
            Columns = new[]
            {
                "ID",
            },
        },
        UniqueConstraints = new[]
        {
            new Snowflake.Inputs.HybridTableUniqueConstraintArgs
            {
                Name = "uq_name",
                Columns = new[]
                {
                    "NAME",
                },
            },
        },
        ForeignKeyConstraints = new[]
        {
            new Snowflake.Inputs.HybridTableForeignKeyConstraintArgs
            {
                Name = "fk_parent",
                Columns = new[]
                {
                    "PARENT_ID",
                },
                TableName = "DATABASE.SCHEMA.PARENT_HYBRID_TABLE",
                RefColumns = new[]
                {
                    "ID",
                },
            },
        },
        Indices = new[]
        {
            new Snowflake.Inputs.HybridTableIndexArgs
            {
                Name = "idx_name",
                Columns = new[]
                {
                    "NAME",
                },
            },
            new Snowflake.Inputs.HybridTableIndexArgs
            {
                Name = "idx_name_created_at",
                Columns = new[]
                {
                    "NAME",
                },
                IncludeColumns = new[]
                {
                    "CREATED_AT",
                },
            },
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.HybridTable;
import com.pulumi.snowflake.HybridTableArgs;
import com.pulumi.snowflake.inputs.HybridTableColumnArgs;
import com.pulumi.snowflake.inputs.HybridTablePrimaryKeyConstraintArgs;
import com.pulumi.snowflake.inputs.HybridTableColumnDefaultArgs;
import com.pulumi.snowflake.inputs.HybridTableUniqueConstraintArgs;
import com.pulumi.snowflake.inputs.HybridTableForeignKeyConstraintArgs;
import com.pulumi.snowflake.inputs.HybridTableIndexArgs;
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) {
        // basic resource
        var basic = new HybridTable("basic", HybridTableArgs.builder()
            .database("DATABASE")
            .schema("SCHEMA")
            .name("HYBRID_TABLE")
            .columns(HybridTableColumnArgs.builder()
                .name("ID")
                .type("NUMBER(38,0)")
                .notNull(true)
                .build())
            .primaryKeyConstraint(HybridTablePrimaryKeyConstraintArgs.builder()
                .columns("ID")
                .build())
            .build());

        // complete resource
        var complete = new HybridTable("complete", HybridTableArgs.builder()
            .database("DATABASE")
            .schema("SCHEMA")
            .name("HYBRID_TABLE")
            .comment("A hybrid table for HTAP workloads")
            .dataRetentionTimeInDays(7)
            .maxDataExtensionTimeInDays(14)
            .columns(            
                HybridTableColumnArgs.builder()
                    .name("ID")
                    .type("NUMBER(38,0)")
                    .notNull(true)
                    .build(),
                HybridTableColumnArgs.builder()
                    .name("NAME")
                    .type("VARCHAR(256)")
                    .notNull(false)
                    .collate("en-ci")
                    .comment("Name column")
                    .build(),
                HybridTableColumnArgs.builder()
                    .name("CREATED_AT")
                    .type("TIMESTAMP_NTZ")
                    .notNull(true)
                    .default_(HybridTableColumnDefaultArgs.builder()
                        .expression("CURRENT_TIMESTAMP()")
                        .build())
                    .build(),
                HybridTableColumnArgs.builder()
                    .name("STATUS")
                    .type("VARCHAR(256)")
                    .default_(HybridTableColumnDefaultArgs.builder()
                        .constant("ACTIVE")
                        .build())
                    .build(),
                HybridTableColumnArgs.builder()
                    .name("SEQ_ID")
                    .type("NUMBER(38,0)")
                    .default_(HybridTableColumnDefaultArgs.builder()
                        .sequence("DATABASE.SCHEMA.MY_SEQUENCE")
                        .build())
                    .build(),
                HybridTableColumnArgs.builder()
                    .name("PARENT_ID")
                    .type("NUMBER(38,0)")
                    .notNull(true)
                    .build())
            .primaryKeyConstraint(HybridTablePrimaryKeyConstraintArgs.builder()
                .name("pk_hybrid_table")
                .columns("ID")
                .build())
            .uniqueConstraints(HybridTableUniqueConstraintArgs.builder()
                .name("uq_name")
                .columns("NAME")
                .build())
            .foreignKeyConstraints(HybridTableForeignKeyConstraintArgs.builder()
                .name("fk_parent")
                .columns("PARENT_ID")
                .tableName("DATABASE.SCHEMA.PARENT_HYBRID_TABLE")
                .refColumns("ID")
                .build())
            .indices(            
                HybridTableIndexArgs.builder()
                    .name("idx_name")
                    .columns("NAME")
                    .build(),
                HybridTableIndexArgs.builder()
                    .name("idx_name_created_at")
                    .columns("NAME")
                    .includeColumns("CREATED_AT")
                    .build())
            .build());

    }
}

    resources:
  # basic resource
  basic:
    type: snowflake:HybridTable
    properties:
      database: DATABASE
      schema: SCHEMA
      name: HYBRID_TABLE
      columns:
        - name: ID
          type: NUMBER(38,0)
          notNull: true
      primaryKeyConstraint:
        columns:
          - ID
  # complete resource
  complete:
    type: snowflake:HybridTable
    properties:
      database: DATABASE
      schema: SCHEMA
      name: HYBRID_TABLE
      comment: A hybrid table for HTAP workloads
      dataRetentionTimeInDays: 7
      maxDataExtensionTimeInDays: 14
      columns:
        - name: ID
          type: NUMBER(38,0)
          notNull: true
        - name: NAME
          type: VARCHAR(256)
          notNull: false
          collate: en-ci
          comment: Name column
        - name: CREATED_AT
          type: TIMESTAMP_NTZ
          notNull: true
          default:
            expression: CURRENT_TIMESTAMP()
        - name: STATUS
          type: VARCHAR(256)
          default:
            constant: ACTIVE
        - name: SEQ_ID
          type: NUMBER(38,0)
          default:
            sequence: DATABASE.SCHEMA.MY_SEQUENCE
        - name: PARENT_ID
          type: NUMBER(38,0)
          notNull: true
      primaryKeyConstraint:
        name: pk_hybrid_table
        columns:
          - ID
      uniqueConstraints:
        - name: uq_name
          columns:
            - NAME
      foreignKeyConstraints:
        - name: fk_parent
          columns:
            - PARENT_ID
          tableName: DATABASE.SCHEMA.PARENT_HYBRID_TABLE
          refColumns:
            - ID
      indices:
        - name: idx_name
          columns:
            - NAME
        - name: idx_name_created_at
          columns:
            - NAME
          includeColumns:
            - CREATED_AT

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

# basic resource
resource "snowflake_hybridtable" "basic" {
  database = "DATABASE"
  schema   = "SCHEMA"
  name     = "HYBRID_TABLE"
  columns {
    name     = "ID"
    type     = "NUMBER(38,0)"
    not_null = true
  }
  primary_key_constraint = {
    columns = ["ID"]
  }
}
# complete resource
resource "snowflake_hybridtable" "complete" {
  database                        = "DATABASE"
  schema                          = "SCHEMA"
  name                            = "HYBRID_TABLE"
  comment                         = "A hybrid table for HTAP workloads"
  data_retention_time_in_days     = 7
  max_data_extension_time_in_days = 14
  columns {
    name     = "ID"
    type     = "NUMBER(38,0)"
    not_null = true
  }
  columns {
    name     = "NAME"
    type     = "VARCHAR(256)"
    not_null = false
    collate  = "en-ci"
    comment  = "Name column"
  }
  columns {
    name     = "CREATED_AT"
    type     = "TIMESTAMP_NTZ"
    not_null = true
    default = {
      expression = "CURRENT_TIMESTAMP()"
    }
  }
  columns {
    name = "STATUS"
    type = "VARCHAR(256)"
    default = {
      constant = "ACTIVE"
    }
  }
  columns {
    name = "SEQ_ID"
    type = "NUMBER(38,0)"
    default = {
      sequence = "DATABASE.SCHEMA.MY_SEQUENCE"
    }
  }
  columns {
    name     = "PARENT_ID"
    type     = "NUMBER(38,0)"
    not_null = true
  }
  primary_key_constraint = {
    name    = "pk_hybrid_table"
    columns = ["ID"]
  }
  unique_constraints {
    name    = "uq_name"
    columns = ["NAME"]
  }
  foreign_key_constraints {
    name        = "fk_parent"
    columns     = ["PARENT_ID"]
    table_name  = "DATABASE.SCHEMA.PARENT_HYBRID_TABLE"
    ref_columns = ["ID"]
  }
  indices {
    name    = "idx_name"
    columns = ["NAME"]
  }
  indices {
    name            = "idx_name_created_at"
    columns         = ["NAME"]
    include_columns = ["CREATED_AT"]
  }
}

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

    Create HybridTable Resource

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

    Constructor syntax

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

@overload
def HybridTable(resource_name: str,
                opts: Optional[ResourceOptions] = None,
                columns: Optional[Sequence[HybridTableColumnArgs]] = None,
                database: Optional[str] = None,
                primary_key_constraint: Optional[HybridTablePrimaryKeyConstraintArgs] = None,
                schema: Optional[str] = None,
                comment: Optional[str] = None,
                data_retention_time_in_days: Optional[int] = None,
                foreign_key_constraints: Optional[Sequence[HybridTableForeignKeyConstraintArgs]] = None,
                indices: Optional[Sequence[HybridTableIndexArgs]] = None,
                max_data_extension_time_in_days: Optional[int] = None,
                name: Optional[str] = None,
                unique_constraints: Optional[Sequence[HybridTableUniqueConstraintArgs]] = None)
    func NewHybridTable(ctx *Context, name string, args HybridTableArgs, opts ...ResourceOption) (*HybridTable, error)
    public HybridTable(string name, HybridTableArgs args, CustomResourceOptions? opts = null)
    public HybridTable(String name, HybridTableArgs args)
public HybridTable(String name, HybridTableArgs args, CustomResourceOptions options)

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


    resource "snowflake_hybrid_table" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args HybridTableArgs
    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 HybridTableArgs
    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 HybridTableArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args HybridTableArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args HybridTableArgs
    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 hybridTableResource = new Snowflake.HybridTable("hybridTableResource", new()
{
    Columns = new[]
    {
        new Snowflake.Inputs.HybridTableColumnArgs
        {
            Name = "string",
            Type = "string",
            Collate = "string",
            Comment = "string",
            Default = new Snowflake.Inputs.HybridTableColumnDefaultArgs
            {
                Constant = "string",
                Expression = "string",
                Sequence = "string",
            },
            NotNull = false,
        },
    },
    Database = "string",
    PrimaryKeyConstraint = new Snowflake.Inputs.HybridTablePrimaryKeyConstraintArgs
    {
        Columns = new[]
        {
            "string",
        },
        Name = "string",
    },
    Schema = "string",
    Comment = "string",
    DataRetentionTimeInDays = 0,
    ForeignKeyConstraints = new[]
    {
        new Snowflake.Inputs.HybridTableForeignKeyConstraintArgs
        {
            Columns = new[]
            {
                "string",
            },
            RefColumns = new[]
            {
                "string",
            },
            TableName = "string",
            Name = "string",
        },
    },
    Indices = new[]
    {
        new Snowflake.Inputs.HybridTableIndexArgs
        {
            Columns = new[]
            {
                "string",
            },
            Name = "string",
            IncludeColumns = new[]
            {
                "string",
            },
        },
    },
    MaxDataExtensionTimeInDays = 0,
    Name = "string",
    UniqueConstraints = new[]
    {
        new Snowflake.Inputs.HybridTableUniqueConstraintArgs
        {
            Columns = new[]
            {
                "string",
            },
            Name = "string",
        },
    },
});

    example, err := snowflake.NewHybridTable(ctx, "hybridTableResource", &snowflake.HybridTableArgs{
	Columns: snowflake.HybridTableColumnArray{
		&snowflake.HybridTableColumnArgs{
			Name:    pulumi.String("string"),
			Type:    pulumi.String("string"),
			Collate: pulumi.String("string"),
			Comment: pulumi.String("string"),
			Default: &snowflake.HybridTableColumnDefaultArgs{
				Constant:   pulumi.String("string"),
				Expression: pulumi.String("string"),
				Sequence:   pulumi.String("string"),
			},
			NotNull: pulumi.Bool(false),
		},
	},
	Database: pulumi.String("string"),
	PrimaryKeyConstraint: &snowflake.HybridTablePrimaryKeyConstraintArgs{
		Columns: pulumi.StringArray{
			pulumi.String("string"),
		},
		Name: pulumi.String("string"),
	},
	Schema:                  pulumi.String("string"),
	Comment:                 pulumi.String("string"),
	DataRetentionTimeInDays: pulumi.Int(0),
	ForeignKeyConstraints: snowflake.HybridTableForeignKeyConstraintArray{
		&snowflake.HybridTableForeignKeyConstraintArgs{
			Columns: pulumi.StringArray{
				pulumi.String("string"),
			},
			RefColumns: pulumi.StringArray{
				pulumi.String("string"),
			},
			TableName: pulumi.String("string"),
			Name:      pulumi.String("string"),
		},
	},
	Indices: snowflake.HybridTableIndexArray{
		&snowflake.HybridTableIndexArgs{
			Columns: pulumi.StringArray{
				pulumi.String("string"),
			},
			Name: pulumi.String("string"),
			IncludeColumns: pulumi.StringArray{
				pulumi.String("string"),
			},
		},
	},
	MaxDataExtensionTimeInDays: pulumi.Int(0),
	Name:                       pulumi.String("string"),
	UniqueConstraints: snowflake.HybridTableUniqueConstraintArray{
		&snowflake.HybridTableUniqueConstraintArgs{
			Columns: pulumi.StringArray{
				pulumi.String("string"),
			},
			Name: pulumi.String("string"),
		},
	},
})

    resource "snowflake_hybrid_table" "hybridTableResource" {
  lifecycle {
    create_before_destroy = true
  }
  columns {
    name    = "string"
    type    = "string"
    collate = "string"
    comment = "string"
    default = {
      constant   = "string"
      expression = "string"
      sequence   = "string"
    }
    not_null = false
  }
  database = "string"
  primary_key_constraint = {
    columns = ["string"]
    name    = "string"
  }
  schema                      = "string"
  comment                     = "string"
  data_retention_time_in_days = 0
  foreign_key_constraints {
    columns     = ["string"]
    ref_columns = ["string"]
    table_name  = "string"
    name        = "string"
  }
  indices {
    columns         = ["string"]
    name            = "string"
    include_columns = ["string"]
  }
  max_data_extension_time_in_days = 0
  name                            = "string"
  unique_constraints {
    columns = ["string"]
    name    = "string"
  }
}

    var hybridTableResource = new HybridTable("hybridTableResource", HybridTableArgs.builder()
    .columns(HybridTableColumnArgs.builder()
        .name("string")
        .type("string")
        .collate("string")
        .comment("string")
        .default_(HybridTableColumnDefaultArgs.builder()
            .constant("string")
            .expression("string")
            .sequence("string")
            .build())
        .notNull(false)
        .build())
    .database("string")
    .primaryKeyConstraint(HybridTablePrimaryKeyConstraintArgs.builder()
        .columns("string")
        .name("string")
        .build())
    .schema("string")
    .comment("string")
    .dataRetentionTimeInDays(0)
    .foreignKeyConstraints(HybridTableForeignKeyConstraintArgs.builder()
        .columns("string")
        .refColumns("string")
        .tableName("string")
        .name("string")
        .build())
    .indices(HybridTableIndexArgs.builder()
        .columns("string")
        .name("string")
        .includeColumns("string")
        .build())
    .maxDataExtensionTimeInDays(0)
    .name("string")
    .uniqueConstraints(HybridTableUniqueConstraintArgs.builder()
        .columns("string")
        .name("string")
        .build())
    .build());

    hybrid_table_resource = snowflake.HybridTable("hybridTableResource",
    columns=[{
        "name": "string",
        "type": "string",
        "collate": "string",
        "comment": "string",
        "default": {
            "constant": "string",
            "expression": "string",
            "sequence": "string",
        },
        "not_null": False,
    }],
    database="string",
    primary_key_constraint={
        "columns": ["string"],
        "name": "string",
    },
    schema="string",
    comment="string",
    data_retention_time_in_days=0,
    foreign_key_constraints=[{
        "columns": ["string"],
        "ref_columns": ["string"],
        "table_name": "string",
        "name": "string",
    }],
    indices=[{
        "columns": ["string"],
        "name": "string",
        "include_columns": ["string"],
    }],
    max_data_extension_time_in_days=0,
    name="string",
    unique_constraints=[{
        "columns": ["string"],
        "name": "string",
    }])

    const hybridTableResource = new snowflake.HybridTable("hybridTableResource", {
    columns: [{
        name: "string",
        type: "string",
        collate: "string",
        comment: "string",
        "default": {
            constant: "string",
            expression: "string",
            sequence: "string",
        },
        notNull: false,
    }],
    database: "string",
    primaryKeyConstraint: {
        columns: ["string"],
        name: "string",
    },
    schema: "string",
    comment: "string",
    dataRetentionTimeInDays: 0,
    foreignKeyConstraints: [{
        columns: ["string"],
        refColumns: ["string"],
        tableName: "string",
        name: "string",
    }],
    indices: [{
        columns: ["string"],
        name: "string",
        includeColumns: ["string"],
    }],
    maxDataExtensionTimeInDays: 0,
    name: "string",
    uniqueConstraints: [{
        columns: ["string"],
        name: "string",
    }],
});

    type: snowflake:HybridTable
properties:
    columns:
        - collate: string
          comment: string
          default:
            constant: string
            expression: string
            sequence: string
          name: string
          notNull: false
          type: string
    comment: string
    dataRetentionTimeInDays: 0
    database: string
    foreignKeyConstraints:
        - columns:
            - string
          name: string
          refColumns:
            - string
          tableName: string
    indices:
        - columns:
            - string
          includeColumns:
            - string
          name: string
    maxDataExtensionTimeInDays: 0
    name: string
    primaryKeyConstraint:
        columns:
            - string
        name: string
    schema: string
    uniqueConstraints:
        - columns:
            - string
          name: string

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

    Columns List<HybridTableColumn>
    Definitions of a column to create in the hybrid table. Minimum one required.
    Database string
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PrimaryKeyConstraint HybridTablePrimaryKeyConstraint
    Defines the primary key constraint for the hybrid table.
    Schema string
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Comment string
    Specifies a comment for the hybrid table.
    DataRetentionTimeInDays int
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    ForeignKeyConstraints List<HybridTableForeignKeyConstraint>
    Defines FOREIGN KEY constraints.
    Indices List<HybridTableIndex>
    Defines secondary indexes on the hybrid table.
    MaxDataExtensionTimeInDays int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    Name string
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    UniqueConstraints List<HybridTableUniqueConstraint>
    Defines UNIQUE constraints.
    Columns []HybridTableColumnArgs
    Definitions of a column to create in the hybrid table. Minimum one required.
    Database string
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PrimaryKeyConstraint HybridTablePrimaryKeyConstraintArgs
    Defines the primary key constraint for the hybrid table.
    Schema string
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    Comment string
    Specifies a comment for the hybrid table.
    DataRetentionTimeInDays int
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    ForeignKeyConstraints []HybridTableForeignKeyConstraintArgs
    Defines FOREIGN KEY constraints.
    Indices []HybridTableIndexArgs
    Defines secondary indexes on the hybrid table.
    MaxDataExtensionTimeInDays int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    Name string
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    UniqueConstraints []HybridTableUniqueConstraintArgs
    Defines UNIQUE constraints.
    columns list(object)
    Definitions of a column to create in the hybrid table. Minimum one required.
    database string
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primary_key_constraint object
    Defines the primary key constraint for the hybrid table.
    schema string
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment string
    Specifies a comment for the hybrid table.
    data_retention_time_in_days number
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    foreign_key_constraints list(object)
    Defines FOREIGN KEY constraints.
    indices list(object)
    Defines secondary indexes on the hybrid table.
    max_data_extension_time_in_days number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name string
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    unique_constraints list(object)
    Defines UNIQUE constraints.
    columns List<HybridTableColumn>
    Definitions of a column to create in the hybrid table. Minimum one required.
    database String
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primaryKeyConstraint HybridTablePrimaryKeyConstraint
    Defines the primary key constraint for the hybrid table.
    schema String
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment String
    Specifies a comment for the hybrid table.
    dataRetentionTimeInDays Integer
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    foreignKeyConstraints List<HybridTableForeignKeyConstraint>
    Defines FOREIGN KEY constraints.
    indices List<HybridTableIndex>
    Defines secondary indexes on the hybrid table.
    maxDataExtensionTimeInDays Integer
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name String
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    uniqueConstraints List<HybridTableUniqueConstraint>
    Defines UNIQUE constraints.
    columns HybridTableColumn[]
    Definitions of a column to create in the hybrid table. Minimum one required.
    database string
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primaryKeyConstraint HybridTablePrimaryKeyConstraint
    Defines the primary key constraint for the hybrid table.
    schema string
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment string
    Specifies a comment for the hybrid table.
    dataRetentionTimeInDays number
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    foreignKeyConstraints HybridTableForeignKeyConstraint[]
    Defines FOREIGN KEY constraints.
    indices HybridTableIndex[]
    Defines secondary indexes on the hybrid table.
    maxDataExtensionTimeInDays number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name string
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    uniqueConstraints HybridTableUniqueConstraint[]
    Defines UNIQUE constraints.
    columns Sequence[HybridTableColumnArgs]
    Definitions of a column to create in the hybrid table. Minimum one required.
    database str
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primary_key_constraint HybridTablePrimaryKeyConstraintArgs
    Defines the primary key constraint for the hybrid table.
    schema str
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment str
    Specifies a comment for the hybrid table.
    data_retention_time_in_days int
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    foreign_key_constraints Sequence[HybridTableForeignKeyConstraintArgs]
    Defines FOREIGN KEY constraints.
    indices Sequence[HybridTableIndexArgs]
    Defines secondary indexes on the hybrid table.
    max_data_extension_time_in_days int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name str
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    unique_constraints Sequence[HybridTableUniqueConstraintArgs]
    Defines UNIQUE constraints.
    columns List<Property Map>
    Definitions of a column to create in the hybrid table. Minimum one required.
    database String
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primaryKeyConstraint Property Map
    Defines the primary key constraint for the hybrid table.
    schema String
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    comment String
    Specifies a comment for the hybrid table.
    dataRetentionTimeInDays Number
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    foreignKeyConstraints List<Property Map>
    Defines FOREIGN KEY constraints.
    indices List<Property Map>
    Defines secondary indexes on the hybrid table.
    maxDataExtensionTimeInDays Number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name String
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    uniqueConstraints List<Property Map>
    Defines UNIQUE constraints.

    Outputs

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

    DescribeOutputs List<HybridTableDescribeOutput>
    Outputs the result of DESCRIBE TABLE for the given hybrid 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.
    ShowKeysOutputs List<HybridTableShowKeysOutput>
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    ShowOutputs List<HybridTableShowOutput>
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    DescribeOutputs []HybridTableDescribeOutput
    Outputs the result of DESCRIBE TABLE for the given hybrid 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.
    ShowKeysOutputs []HybridTableShowKeysOutput
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    ShowOutputs []HybridTableShowOutput
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    describe_outputs list(object)
    Outputs the result of DESCRIBE TABLE for the given hybrid table.
    fully_qualified_name string
    Fully qualified name of the resource. For more information, see object name resolution.
    id string
    The provider-assigned unique ID for this managed resource.
    show_keys_outputs list(object)
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    show_outputs list(object)
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    describeOutputs List<HybridTableDescribeOutput>
    Outputs the result of DESCRIBE TABLE for the given hybrid 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.
    showKeysOutputs List<HybridTableShowKeysOutput>
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    showOutputs List<HybridTableShowOutput>
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    describeOutputs HybridTableDescribeOutput[]
    Outputs the result of DESCRIBE TABLE for the given hybrid 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.
    showKeysOutputs HybridTableShowKeysOutput[]
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    showOutputs HybridTableShowOutput[]
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    describe_outputs Sequence[HybridTableDescribeOutput]
    Outputs the result of DESCRIBE TABLE for the given hybrid 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.
    show_keys_outputs Sequence[HybridTableShowKeysOutput]
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    show_outputs Sequence[HybridTableShowOutput]
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE TABLE for the given hybrid 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.
    showKeysOutputs List<Property Map>
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    showOutputs List<Property Map>
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.

    Look up Existing HybridTable Resource

    Get an existing HybridTable 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?: HybridTableState, opts?: CustomResourceOptions): HybridTable
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        columns: Optional[Sequence[HybridTableColumnArgs]] = None,
        comment: Optional[str] = None,
        data_retention_time_in_days: Optional[int] = None,
        database: Optional[str] = None,
        describe_outputs: Optional[Sequence[HybridTableDescribeOutputArgs]] = None,
        foreign_key_constraints: Optional[Sequence[HybridTableForeignKeyConstraintArgs]] = None,
        fully_qualified_name: Optional[str] = None,
        indices: Optional[Sequence[HybridTableIndexArgs]] = None,
        max_data_extension_time_in_days: Optional[int] = None,
        name: Optional[str] = None,
        primary_key_constraint: Optional[HybridTablePrimaryKeyConstraintArgs] = None,
        schema: Optional[str] = None,
        show_keys_outputs: Optional[Sequence[HybridTableShowKeysOutputArgs]] = None,
        show_outputs: Optional[Sequence[HybridTableShowOutputArgs]] = None,
        unique_constraints: Optional[Sequence[HybridTableUniqueConstraintArgs]] = None) -> HybridTable
    func GetHybridTable(ctx *Context, name string, id IDInput, state *HybridTableState, opts ...ResourceOption) (*HybridTable, error)
    public static HybridTable Get(string name, Input<string> id, HybridTableState? state, CustomResourceOptions? opts = null)
    public static HybridTable get(String name, Output<String> id, HybridTableState state, CustomResourceOptions options)
    resources:  _:    type: snowflake:HybridTable    get:      id: ${id}
    import {
  to = snowflake_hybrid_table.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:
    Columns List<HybridTableColumn>
    Definitions of a column to create in the hybrid table. Minimum one required.
    Comment string
    Specifies a comment for the hybrid table.
    DataRetentionTimeInDays int
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    Database string
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    DescribeOutputs List<HybridTableDescribeOutput>
    Outputs the result of DESCRIBE TABLE for the given hybrid table.
    ForeignKeyConstraints List<HybridTableForeignKeyConstraint>
    Defines FOREIGN KEY constraints.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Indices List<HybridTableIndex>
    Defines secondary indexes on the hybrid table.
    MaxDataExtensionTimeInDays int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    Name string
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PrimaryKeyConstraint HybridTablePrimaryKeyConstraint
    Defines the primary key constraint for the hybrid table.
    Schema string
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    ShowKeysOutputs List<HybridTableShowKeysOutput>
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    ShowOutputs List<HybridTableShowOutput>
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    UniqueConstraints List<HybridTableUniqueConstraint>
    Defines UNIQUE constraints.
    Columns []HybridTableColumnArgs
    Definitions of a column to create in the hybrid table. Minimum one required.
    Comment string
    Specifies a comment for the hybrid table.
    DataRetentionTimeInDays int
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    Database string
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    DescribeOutputs []HybridTableDescribeOutputArgs
    Outputs the result of DESCRIBE TABLE for the given hybrid table.
    ForeignKeyConstraints []HybridTableForeignKeyConstraintArgs
    Defines FOREIGN KEY constraints.
    FullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    Indices []HybridTableIndexArgs
    Defines secondary indexes on the hybrid table.
    MaxDataExtensionTimeInDays int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    Name string
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    PrimaryKeyConstraint HybridTablePrimaryKeyConstraintArgs
    Defines the primary key constraint for the hybrid table.
    Schema string
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    ShowKeysOutputs []HybridTableShowKeysOutputArgs
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    ShowOutputs []HybridTableShowOutputArgs
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    UniqueConstraints []HybridTableUniqueConstraintArgs
    Defines UNIQUE constraints.
    columns list(object)
    Definitions of a column to create in the hybrid table. Minimum one required.
    comment string
    Specifies a comment for the hybrid table.
    data_retention_time_in_days number
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    database string
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describe_outputs list(object)
    Outputs the result of DESCRIBE TABLE for the given hybrid table.
    foreign_key_constraints list(object)
    Defines FOREIGN KEY constraints.
    fully_qualified_name string
    Fully qualified name of the resource. For more information, see object name resolution.
    indices list(object)
    Defines secondary indexes on the hybrid table.
    max_data_extension_time_in_days number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name string
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primary_key_constraint object
    Defines the primary key constraint for the hybrid table.
    schema string
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    show_keys_outputs list(object)
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    show_outputs list(object)
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    unique_constraints list(object)
    Defines UNIQUE constraints.
    columns List<HybridTableColumn>
    Definitions of a column to create in the hybrid table. Minimum one required.
    comment String
    Specifies a comment for the hybrid table.
    dataRetentionTimeInDays Integer
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    database String
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs List<HybridTableDescribeOutput>
    Outputs the result of DESCRIBE TABLE for the given hybrid table.
    foreignKeyConstraints List<HybridTableForeignKeyConstraint>
    Defines FOREIGN KEY constraints.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    indices List<HybridTableIndex>
    Defines secondary indexes on the hybrid table.
    maxDataExtensionTimeInDays Integer
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name String
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primaryKeyConstraint HybridTablePrimaryKeyConstraint
    Defines the primary key constraint for the hybrid table.
    schema String
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showKeysOutputs List<HybridTableShowKeysOutput>
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    showOutputs List<HybridTableShowOutput>
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    uniqueConstraints List<HybridTableUniqueConstraint>
    Defines UNIQUE constraints.
    columns HybridTableColumn[]
    Definitions of a column to create in the hybrid table. Minimum one required.
    comment string
    Specifies a comment for the hybrid table.
    dataRetentionTimeInDays number
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    database string
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs HybridTableDescribeOutput[]
    Outputs the result of DESCRIBE TABLE for the given hybrid table.
    foreignKeyConstraints HybridTableForeignKeyConstraint[]
    Defines FOREIGN KEY constraints.
    fullyQualifiedName string
    Fully qualified name of the resource. For more information, see object name resolution.
    indices HybridTableIndex[]
    Defines secondary indexes on the hybrid table.
    maxDataExtensionTimeInDays number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name string
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primaryKeyConstraint HybridTablePrimaryKeyConstraint
    Defines the primary key constraint for the hybrid table.
    schema string
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showKeysOutputs HybridTableShowKeysOutput[]
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    showOutputs HybridTableShowOutput[]
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    uniqueConstraints HybridTableUniqueConstraint[]
    Defines UNIQUE constraints.
    columns Sequence[HybridTableColumnArgs]
    Definitions of a column to create in the hybrid table. Minimum one required.
    comment str
    Specifies a comment for the hybrid table.
    data_retention_time_in_days int
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    database str
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describe_outputs Sequence[HybridTableDescribeOutputArgs]
    Outputs the result of DESCRIBE TABLE for the given hybrid table.
    foreign_key_constraints Sequence[HybridTableForeignKeyConstraintArgs]
    Defines FOREIGN KEY constraints.
    fully_qualified_name str
    Fully qualified name of the resource. For more information, see object name resolution.
    indices Sequence[HybridTableIndexArgs]
    Defines secondary indexes on the hybrid table.
    max_data_extension_time_in_days int
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name str
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primary_key_constraint HybridTablePrimaryKeyConstraintArgs
    Defines the primary key constraint for the hybrid table.
    schema str
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    show_keys_outputs Sequence[HybridTableShowKeysOutputArgs]
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    show_outputs Sequence[HybridTableShowOutputArgs]
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    unique_constraints Sequence[HybridTableUniqueConstraintArgs]
    Defines UNIQUE constraints.
    columns List<Property Map>
    Definitions of a column to create in the hybrid table. Minimum one required.
    comment String
    Specifies a comment for the hybrid table.
    dataRetentionTimeInDays Number
    Specifies the retention period for the hybrid table so that Time Travel actions can be performed on historical data. For more information, check DATARETENTIONTIMEINDAYS docs.
    database String
    The database in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    describeOutputs List<Property Map>
    Outputs the result of DESCRIBE TABLE for the given hybrid table.
    foreignKeyConstraints List<Property Map>
    Defines FOREIGN KEY constraints.
    fullyQualifiedName String
    Fully qualified name of the resource. For more information, see object name resolution.
    indices List<Property Map>
    Defines secondary indexes on the hybrid table.
    maxDataExtensionTimeInDays Number
    Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for the hybrid table to prevent streams on it from becoming stale. For more information, check MAXDATAEXTENSIONTIMEIN_DAYS docs.
    name String
    Specifies the identifier for the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    primaryKeyConstraint Property Map
    Defines the primary key constraint for the hybrid table.
    schema String
    The schema in which to create the hybrid table. Due to technical limitations (read more here), avoid using the following characters: |, ., ".
    showKeysOutputs List<Property Map>
    Outputs the result of SHOW PRIMARY KEYS, SHOW UNIQUE KEYS, and SHOW IMPORTED KEYS for the given hybrid table, merged and grouped by constraint name and ordered by kind, then by column names. The referencedTable, referencedColumns, deleteRule, and updateRule fields are populated for FOREIGN KEY constraints only.
    showOutputs List<Property Map>
    Outputs the result of SHOW HYBRID TABLES for the given hybrid table.
    uniqueConstraints List<Property Map>
    Defines UNIQUE constraints.

    Supporting Types

    HybridTableColumn, HybridTableColumnArgs

    Name string
    Column name.
    Type string
    Column type. See Snowflake data types for supported values. Example: VARCHAR(256), NUMBER(38,0).
    Collate string
    Column collation specification, e.g. en-ci. Case-insensitive (en-ci and EN-CI are treated as equal).
    Comment string
    Column-level comment.
    Default HybridTableColumnDefault
    Defines the column default value. Only one of constant, expression, or sequence may be set.
    NotNull bool
    Whether to restrict the column to NOT NULL values. Changing this on an existing column forces recreation. Primary key columns must set this to true because NOT NULL is implied by the primary key.
    Name string
    Column name.
    Type string
    Column type. See Snowflake data types for supported values. Example: VARCHAR(256), NUMBER(38,0).
    Collate string
    Column collation specification, e.g. en-ci. Case-insensitive (en-ci and EN-CI are treated as equal).
    Comment string
    Column-level comment.
    Default HybridTableColumnDefault
    Defines the column default value. Only one of constant, expression, or sequence may be set.
    NotNull bool
    Whether to restrict the column to NOT NULL values. Changing this on an existing column forces recreation. Primary key columns must set this to true because NOT NULL is implied by the primary key.
    name string
    Column name.
    type string
    Column type. See Snowflake data types for supported values. Example: VARCHAR(256), NUMBER(38,0).
    collate string
    Column collation specification, e.g. en-ci. Case-insensitive (en-ci and EN-CI are treated as equal).
    comment string
    Column-level comment.
    default object
    Defines the column default value. Only one of constant, expression, or sequence may be set.
    not_null bool
    Whether to restrict the column to NOT NULL values. Changing this on an existing column forces recreation. Primary key columns must set this to true because NOT NULL is implied by the primary key.
    name String
    Column name.
    type String
    Column type. See Snowflake data types for supported values. Example: VARCHAR(256), NUMBER(38,0).
    collate String
    Column collation specification, e.g. en-ci. Case-insensitive (en-ci and EN-CI are treated as equal).
    comment String
    Column-level comment.
    default_ HybridTableColumnDefault
    Defines the column default value. Only one of constant, expression, or sequence may be set.
    notNull Boolean
    Whether to restrict the column to NOT NULL values. Changing this on an existing column forces recreation. Primary key columns must set this to true because NOT NULL is implied by the primary key.
    name string
    Column name.
    type string
    Column type. See Snowflake data types for supported values. Example: VARCHAR(256), NUMBER(38,0).
    collate string
    Column collation specification, e.g. en-ci. Case-insensitive (en-ci and EN-CI are treated as equal).
    comment string
    Column-level comment.
    default HybridTableColumnDefault
    Defines the column default value. Only one of constant, expression, or sequence may be set.
    notNull boolean
    Whether to restrict the column to NOT NULL values. Changing this on an existing column forces recreation. Primary key columns must set this to true because NOT NULL is implied by the primary key.
    name str
    Column name.
    type str
    Column type. See Snowflake data types for supported values. Example: VARCHAR(256), NUMBER(38,0).
    collate str
    Column collation specification, e.g. en-ci. Case-insensitive (en-ci and EN-CI are treated as equal).
    comment str
    Column-level comment.
    default HybridTableColumnDefault
    Defines the column default value. Only one of constant, expression, or sequence may be set.
    not_null bool
    Whether to restrict the column to NOT NULL values. Changing this on an existing column forces recreation. Primary key columns must set this to true because NOT NULL is implied by the primary key.
    name String
    Column name.
    type String
    Column type. See Snowflake data types for supported values. Example: VARCHAR(256), NUMBER(38,0).
    collate String
    Column collation specification, e.g. en-ci. Case-insensitive (en-ci and EN-CI are treated as equal).
    comment String
    Column-level comment.
    default Property Map
    Defines the column default value. Only one of constant, expression, or sequence may be set.
    notNull Boolean
    Whether to restrict the column to NOT NULL values. Changing this on an existing column forces recreation. Primary key columns must set this to true because NOT NULL is implied by the primary key.

    HybridTableColumnDefault, HybridTableColumnDefaultArgs

    Constant string
    A constant default value for the column.
    Expression string
    A SQL expression default value for the column.
    Sequence string
    The default sequence for the column (uses NEXTVAL).
    Constant string
    A constant default value for the column.
    Expression string
    A SQL expression default value for the column.
    Sequence string
    The default sequence for the column (uses NEXTVAL).
    constant string
    A constant default value for the column.
    expression string
    A SQL expression default value for the column.
    sequence string
    The default sequence for the column (uses NEXTVAL).
    constant String
    A constant default value for the column.
    expression String
    A SQL expression default value for the column.
    sequence String
    The default sequence for the column (uses NEXTVAL).
    constant string
    A constant default value for the column.
    expression string
    A SQL expression default value for the column.
    sequence string
    The default sequence for the column (uses NEXTVAL).
    constant str
    A constant default value for the column.
    expression str
    A SQL expression default value for the column.
    sequence str
    The default sequence for the column (uses NEXTVAL).
    constant String
    A constant default value for the column.
    expression String
    A SQL expression default value for the column.
    sequence String
    The default sequence for the column (uses NEXTVAL).

    HybridTableDescribeOutput, HybridTableDescribeOutputArgs

    Check string
    Collation string
    Comment string
    Default string
    Expression string
    IsNullable bool
    Kind string
    Name string
    PolicyName string
    PrimaryKey bool
    PrivacyDomain string
    SchemaEvolutionRecord string
    Type string
    UniqueKey bool
    Check string
    Collation string
    Comment string
    Default string
    Expression string
    IsNullable bool
    Kind string
    Name string
    PolicyName string
    PrimaryKey bool
    PrivacyDomain string
    SchemaEvolutionRecord string
    Type string
    UniqueKey bool
    check string
    collation string
    comment string
    default string
    expression string
    is_nullable bool
    kind string
    name string
    policy_name string
    primary_key bool
    privacy_domain string
    schema_evolution_record string
    type string
    unique_key bool
    check String
    collation String
    comment String
    default_ String
    expression String
    isNullable Boolean
    kind String
    name String
    policyName String
    primaryKey Boolean
    privacyDomain String
    schemaEvolutionRecord String
    type String
    uniqueKey Boolean
    check string
    collation string
    comment string
    default string
    expression string
    isNullable boolean
    kind string
    name string
    policyName string
    primaryKey boolean
    privacyDomain string
    schemaEvolutionRecord string
    type string
    uniqueKey boolean
    check String
    collation String
    comment String
    default String
    expression String
    isNullable Boolean
    kind String
    name String
    policyName String
    primaryKey Boolean
    privacyDomain String
    schemaEvolutionRecord String
    type String
    uniqueKey Boolean

    HybridTableForeignKeyConstraint, HybridTableForeignKeyConstraintArgs

    Columns List<string>
    The local column(s) the foreign key is defined on.
    RefColumns List<string>
    The column(s) in the referenced table that the foreign key references.
    TableName string
    The table that the foreign key references.
    Name string
    Name of the constraint.
    Columns []string
    The local column(s) the foreign key is defined on.
    RefColumns []string
    The column(s) in the referenced table that the foreign key references.
    TableName string
    The table that the foreign key references.
    Name string
    Name of the constraint.
    columns list(string)
    The local column(s) the foreign key is defined on.
    ref_columns list(string)
    The column(s) in the referenced table that the foreign key references.
    table_name string
    The table that the foreign key references.
    name string
    Name of the constraint.
    columns List<String>
    The local column(s) the foreign key is defined on.
    refColumns List<String>
    The column(s) in the referenced table that the foreign key references.
    tableName String
    The table that the foreign key references.
    name String
    Name of the constraint.
    columns string[]
    The local column(s) the foreign key is defined on.
    refColumns string[]
    The column(s) in the referenced table that the foreign key references.
    tableName string
    The table that the foreign key references.
    name string
    Name of the constraint.
    columns Sequence[str]
    The local column(s) the foreign key is defined on.
    ref_columns Sequence[str]
    The column(s) in the referenced table that the foreign key references.
    table_name str
    The table that the foreign key references.
    name str
    Name of the constraint.
    columns List<String>
    The local column(s) the foreign key is defined on.
    refColumns List<String>
    The column(s) in the referenced table that the foreign key references.
    tableName String
    The table that the foreign key references.
    name String
    Name of the constraint.

    HybridTableIndex, HybridTableIndexArgs

    Columns List<string>
    Index key columns, in order. Order is semantically meaningful.
    Name string
    Name of the secondary index.
    IncludeColumns List<string>
    Columns included in the index payload via INCLUDE (...). Order carries no meaning.
    Columns []string
    Index key columns, in order. Order is semantically meaningful.
    Name string
    Name of the secondary index.
    IncludeColumns []string
    Columns included in the index payload via INCLUDE (...). Order carries no meaning.
    columns list(string)
    Index key columns, in order. Order is semantically meaningful.
    name string
    Name of the secondary index.
    include_columns list(string)
    Columns included in the index payload via INCLUDE (...). Order carries no meaning.
    columns List<String>
    Index key columns, in order. Order is semantically meaningful.
    name String
    Name of the secondary index.
    includeColumns List<String>
    Columns included in the index payload via INCLUDE (...). Order carries no meaning.
    columns string[]
    Index key columns, in order. Order is semantically meaningful.
    name string
    Name of the secondary index.
    includeColumns string[]
    Columns included in the index payload via INCLUDE (...). Order carries no meaning.
    columns Sequence[str]
    Index key columns, in order. Order is semantically meaningful.
    name str
    Name of the secondary index.
    include_columns Sequence[str]
    Columns included in the index payload via INCLUDE (...). Order carries no meaning.
    columns List<String>
    Index key columns, in order. Order is semantically meaningful.
    name String
    Name of the secondary index.
    includeColumns List<String>
    Columns included in the index payload via INCLUDE (...). Order carries no meaning.

    HybridTablePrimaryKeyConstraint, HybridTablePrimaryKeyConstraintArgs

    Columns List<string>
    The column(s) the constraint applies to.
    Name string
    Name of the constraint.
    Columns []string
    The column(s) the constraint applies to.
    Name string
    Name of the constraint.
    columns list(string)
    The column(s) the constraint applies to.
    name string
    Name of the constraint.
    columns List<String>
    The column(s) the constraint applies to.
    name String
    Name of the constraint.
    columns string[]
    The column(s) the constraint applies to.
    name string
    Name of the constraint.
    columns Sequence[str]
    The column(s) the constraint applies to.
    name str
    Name of the constraint.
    columns List<String>
    The column(s) the constraint applies to.
    name String
    Name of the constraint.

    HybridTableShowKeysOutput, HybridTableShowKeysOutputArgs

    Columns List<string>
    DeleteRule string
    Kind string
    Name string
    ReferencedColumns List<string>
    ReferencedTable string
    UpdateRule string
    Columns []string
    DeleteRule string
    Kind string
    Name string
    ReferencedColumns []string
    ReferencedTable string
    UpdateRule string
    columns list(string)
    delete_rule string
    kind string
    name string
    referenced_columns list(string)
    referenced_table string
    update_rule string
    columns List<String>
    deleteRule String
    kind String
    name String
    referencedColumns List<String>
    referencedTable String
    updateRule String
    columns string[]
    deleteRule string
    kind string
    name string
    referencedColumns string[]
    referencedTable string
    updateRule string
    columns Sequence[str]
    delete_rule str
    kind str
    name str
    referenced_columns Sequence[str]
    referenced_table str
    update_rule str
    columns List<String>
    deleteRule String
    kind String
    name String
    referencedColumns List<String>
    referencedTable String
    updateRule String

    HybridTableShowOutput, HybridTableShowOutputArgs

    Bytes int
    Comment string
    CreatedOn string
    DatabaseName string
    Name string
    Owner string
    OwnerRoleType string
    Rows int
    SchemaName string
    Bytes int
    Comment string
    CreatedOn string
    DatabaseName string
    Name string
    Owner string
    OwnerRoleType string
    Rows int
    SchemaName string
    bytes number
    comment string
    created_on string
    database_name string
    name string
    owner string
    owner_role_type string
    rows number
    schema_name string
    bytes Integer
    comment String
    createdOn String
    databaseName String
    name String
    owner String
    ownerRoleType String
    rows Integer
    schemaName String
    bytes number
    comment string
    createdOn string
    databaseName string
    name string
    owner string
    ownerRoleType string
    rows number
    schemaName string
    bytes Number
    comment String
    createdOn String
    databaseName String
    name String
    owner String
    ownerRoleType String
    rows Number
    schemaName String

    HybridTableUniqueConstraint, HybridTableUniqueConstraintArgs

    Columns List<string>
    The column(s) the constraint applies to.
    Name string
    Name of the constraint.
    Columns []string
    The column(s) the constraint applies to.
    Name string
    Name of the constraint.
    columns list(string)
    The column(s) the constraint applies to.
    name string
    Name of the constraint.
    columns List<String>
    The column(s) the constraint applies to.
    name String
    Name of the constraint.
    columns string[]
    The column(s) the constraint applies to.
    name string
    Name of the constraint.
    columns Sequence[str]
    The column(s) the constraint applies to.
    name str
    Name of the constraint.
    columns List<String>
    The column(s) the constraint applies to.
    name String
    Name of the constraint.

    Import

    $ pulumi import snowflake:index/hybridTable:HybridTable example '"<db_name>"."<schema_name>"."<hybrid_table_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.20.0
    published on Saturday, Aug 22, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-snowflake

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial