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

snowflake.ExternalTable

Explore with Pulumi AI

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

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as snowflake from "@pulumi/snowflake";
    
    const externalTable = new snowflake.ExternalTable("external_table", {
        database: "db",
        schema: "schema",
        name: "external_table",
        comment: "External table",
        fileFormat: "TYPE = CSV FIELD_DELIMITER = '|'",
        columns: [
            {
                name: "id",
                type: "int",
            },
            {
                name: "data",
                type: "text",
            },
        ],
    });
    
    import pulumi
    import pulumi_snowflake as snowflake
    
    external_table = snowflake.ExternalTable("external_table",
        database="db",
        schema="schema",
        name="external_table",
        comment="External table",
        file_format="TYPE = CSV FIELD_DELIMITER = '|'",
        columns=[
            snowflake.ExternalTableColumnArgs(
                name="id",
                type="int",
            ),
            snowflake.ExternalTableColumnArgs(
                name="data",
                type="text",
            ),
        ])
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-snowflake/sdk/go/snowflake"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := snowflake.NewExternalTable(ctx, "external_table", &snowflake.ExternalTableArgs{
    			Database:   pulumi.String("db"),
    			Schema:     pulumi.String("schema"),
    			Name:       pulumi.String("external_table"),
    			Comment:    pulumi.String("External table"),
    			FileFormat: pulumi.String("TYPE = CSV FIELD_DELIMITER = '|'"),
    			Columns: snowflake.ExternalTableColumnArray{
    				&snowflake.ExternalTableColumnArgs{
    					Name: pulumi.String("id"),
    					Type: pulumi.String("int"),
    				},
    				&snowflake.ExternalTableColumnArgs{
    					Name: pulumi.String("data"),
    					Type: pulumi.String("text"),
    				},
    			},
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Snowflake = Pulumi.Snowflake;
    
    return await Deployment.RunAsync(() => 
    {
        var externalTable = new Snowflake.ExternalTable("external_table", new()
        {
            Database = "db",
            Schema = "schema",
            Name = "external_table",
            Comment = "External table",
            FileFormat = "TYPE = CSV FIELD_DELIMITER = '|'",
            Columns = new[]
            {
                new Snowflake.Inputs.ExternalTableColumnArgs
                {
                    Name = "id",
                    Type = "int",
                },
                new Snowflake.Inputs.ExternalTableColumnArgs
                {
                    Name = "data",
                    Type = "text",
                },
            },
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.snowflake.ExternalTable;
    import com.pulumi.snowflake.ExternalTableArgs;
    import com.pulumi.snowflake.inputs.ExternalTableColumnArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var externalTable = new ExternalTable("externalTable", ExternalTableArgs.builder()
                .database("db")
                .schema("schema")
                .name("external_table")
                .comment("External table")
                .fileFormat("TYPE = CSV FIELD_DELIMITER = '|'")
                .columns(            
                    ExternalTableColumnArgs.builder()
                        .name("id")
                        .type("int")
                        .build(),
                    ExternalTableColumnArgs.builder()
                        .name("data")
                        .type("text")
                        .build())
                .build());
    
        }
    }
    
    resources:
      externalTable:
        type: snowflake:ExternalTable
        name: external_table
        properties:
          database: db
          schema: schema
          name: external_table
          comment: External table
          fileFormat: TYPE = CSV FIELD_DELIMITER = '|'
          columns:
            - name: id
              type: int
            - name: data
              type: text
    

    Create ExternalTable Resource

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

    Constructor syntax

    new ExternalTable(name: string, args: ExternalTableArgs, opts?: CustomResourceOptions);
    @overload
    def ExternalTable(resource_name: str,
                      args: ExternalTableArgs,
                      opts: Optional[ResourceOptions] = None)
    
    @overload
    def ExternalTable(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      database: Optional[str] = None,
                      schema: Optional[str] = None,
                      columns: Optional[Sequence[ExternalTableColumnArgs]] = None,
                      location: Optional[str] = None,
                      file_format: Optional[str] = None,
                      comment: Optional[str] = None,
                      copy_grants: Optional[bool] = None,
                      auto_refresh: Optional[bool] = None,
                      name: Optional[str] = None,
                      partition_bies: Optional[Sequence[str]] = None,
                      pattern: Optional[str] = None,
                      refresh_on_create: Optional[bool] = None,
                      aws_sns_topic: Optional[str] = None,
                      table_format: Optional[str] = None,
                      tags: Optional[Sequence[ExternalTableTagArgs]] = None)
    func NewExternalTable(ctx *Context, name string, args ExternalTableArgs, opts ...ResourceOption) (*ExternalTable, error)
    public ExternalTable(string name, ExternalTableArgs args, CustomResourceOptions? opts = null)
    public ExternalTable(String name, ExternalTableArgs args)
    public ExternalTable(String name, ExternalTableArgs args, CustomResourceOptions options)
    
    type: snowflake:ExternalTable
    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 ExternalTableArgs
    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 ExternalTableArgs
    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 ExternalTableArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ExternalTableArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ExternalTableArgs
    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 externalTableResource = new Snowflake.ExternalTable("externalTableResource", new()
    {
        Database = "string",
        Schema = "string",
        Columns = new[]
        {
            new Snowflake.Inputs.ExternalTableColumnArgs
            {
                As = "string",
                Name = "string",
                Type = "string",
            },
        },
        Location = "string",
        FileFormat = "string",
        Comment = "string",
        CopyGrants = false,
        AutoRefresh = false,
        Name = "string",
        PartitionBies = new[]
        {
            "string",
        },
        Pattern = "string",
        RefreshOnCreate = false,
        AwsSnsTopic = "string",
        TableFormat = "string",
    });
    
    example, err := snowflake.NewExternalTable(ctx, "externalTableResource", &snowflake.ExternalTableArgs{
    	Database: pulumi.String("string"),
    	Schema:   pulumi.String("string"),
    	Columns: snowflake.ExternalTableColumnArray{
    		&snowflake.ExternalTableColumnArgs{
    			As:   pulumi.String("string"),
    			Name: pulumi.String("string"),
    			Type: pulumi.String("string"),
    		},
    	},
    	Location:    pulumi.String("string"),
    	FileFormat:  pulumi.String("string"),
    	Comment:     pulumi.String("string"),
    	CopyGrants:  pulumi.Bool(false),
    	AutoRefresh: pulumi.Bool(false),
    	Name:        pulumi.String("string"),
    	PartitionBies: pulumi.StringArray{
    		pulumi.String("string"),
    	},
    	Pattern:         pulumi.String("string"),
    	RefreshOnCreate: pulumi.Bool(false),
    	AwsSnsTopic:     pulumi.String("string"),
    	TableFormat:     pulumi.String("string"),
    })
    
    var externalTableResource = new ExternalTable("externalTableResource", ExternalTableArgs.builder()
        .database("string")
        .schema("string")
        .columns(ExternalTableColumnArgs.builder()
            .as("string")
            .name("string")
            .type("string")
            .build())
        .location("string")
        .fileFormat("string")
        .comment("string")
        .copyGrants(false)
        .autoRefresh(false)
        .name("string")
        .partitionBies("string")
        .pattern("string")
        .refreshOnCreate(false)
        .awsSnsTopic("string")
        .tableFormat("string")
        .build());
    
    external_table_resource = snowflake.ExternalTable("externalTableResource",
        database="string",
        schema="string",
        columns=[snowflake.ExternalTableColumnArgs(
            as_="string",
            name="string",
            type="string",
        )],
        location="string",
        file_format="string",
        comment="string",
        copy_grants=False,
        auto_refresh=False,
        name="string",
        partition_bies=["string"],
        pattern="string",
        refresh_on_create=False,
        aws_sns_topic="string",
        table_format="string")
    
    const externalTableResource = new snowflake.ExternalTable("externalTableResource", {
        database: "string",
        schema: "string",
        columns: [{
            as: "string",
            name: "string",
            type: "string",
        }],
        location: "string",
        fileFormat: "string",
        comment: "string",
        copyGrants: false,
        autoRefresh: false,
        name: "string",
        partitionBies: ["string"],
        pattern: "string",
        refreshOnCreate: false,
        awsSnsTopic: "string",
        tableFormat: "string",
    });
    
    type: snowflake:ExternalTable
    properties:
        autoRefresh: false
        awsSnsTopic: string
        columns:
            - as: string
              name: string
              type: string
        comment: string
        copyGrants: false
        database: string
        fileFormat: string
        location: string
        name: string
        partitionBies:
            - string
        pattern: string
        refreshOnCreate: false
        schema: string
        tableFormat: string
    

    ExternalTable Resource Properties

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

    Inputs

    The ExternalTable resource accepts the following input properties:

    Columns List<ExternalTableColumn>
    Definitions of a column to create in the external table. Minimum one required.
    Database string
    The database in which to create the external table.
    FileFormat string
    Specifies the file format for the external table.
    Location string
    Specifies a location for the external table.
    Schema string
    The schema in which to create the external table.
    AutoRefresh bool
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    AwsSnsTopic string
    Specifies the aws sns topic for the external table.
    Comment string
    Specifies a comment for the external table.
    CopyGrants bool
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    Name string
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    PartitionBies List<string>
    Specifies any partition columns to evaluate for the external table.
    Pattern string
    Specifies the file names and/or paths on the external stage to match.
    RefreshOnCreate bool
    Specifies weather to refresh when an external table is created.
    TableFormat string
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    Tags List<ExternalTableTag>
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    Columns []ExternalTableColumnArgs
    Definitions of a column to create in the external table. Minimum one required.
    Database string
    The database in which to create the external table.
    FileFormat string
    Specifies the file format for the external table.
    Location string
    Specifies a location for the external table.
    Schema string
    The schema in which to create the external table.
    AutoRefresh bool
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    AwsSnsTopic string
    Specifies the aws sns topic for the external table.
    Comment string
    Specifies a comment for the external table.
    CopyGrants bool
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    Name string
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    PartitionBies []string
    Specifies any partition columns to evaluate for the external table.
    Pattern string
    Specifies the file names and/or paths on the external stage to match.
    RefreshOnCreate bool
    Specifies weather to refresh when an external table is created.
    TableFormat string
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    Tags []ExternalTableTagArgs
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    columns List<ExternalTableColumn>
    Definitions of a column to create in the external table. Minimum one required.
    database String
    The database in which to create the external table.
    fileFormat String
    Specifies the file format for the external table.
    location String
    Specifies a location for the external table.
    schema String
    The schema in which to create the external table.
    autoRefresh Boolean
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    awsSnsTopic String
    Specifies the aws sns topic for the external table.
    comment String
    Specifies a comment for the external table.
    copyGrants Boolean
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    name String
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    partitionBies List<String>
    Specifies any partition columns to evaluate for the external table.
    pattern String
    Specifies the file names and/or paths on the external stage to match.
    refreshOnCreate Boolean
    Specifies weather to refresh when an external table is created.
    tableFormat String
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    tags List<ExternalTableTag>
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    columns ExternalTableColumn[]
    Definitions of a column to create in the external table. Minimum one required.
    database string
    The database in which to create the external table.
    fileFormat string
    Specifies the file format for the external table.
    location string
    Specifies a location for the external table.
    schema string
    The schema in which to create the external table.
    autoRefresh boolean
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    awsSnsTopic string
    Specifies the aws sns topic for the external table.
    comment string
    Specifies a comment for the external table.
    copyGrants boolean
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    name string
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    partitionBies string[]
    Specifies any partition columns to evaluate for the external table.
    pattern string
    Specifies the file names and/or paths on the external stage to match.
    refreshOnCreate boolean
    Specifies weather to refresh when an external table is created.
    tableFormat string
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    tags ExternalTableTag[]
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    columns Sequence[ExternalTableColumnArgs]
    Definitions of a column to create in the external table. Minimum one required.
    database str
    The database in which to create the external table.
    file_format str
    Specifies the file format for the external table.
    location str
    Specifies a location for the external table.
    schema str
    The schema in which to create the external table.
    auto_refresh bool
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    aws_sns_topic str
    Specifies the aws sns topic for the external table.
    comment str
    Specifies a comment for the external table.
    copy_grants bool
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    name str
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    partition_bies Sequence[str]
    Specifies any partition columns to evaluate for the external table.
    pattern str
    Specifies the file names and/or paths on the external stage to match.
    refresh_on_create bool
    Specifies weather to refresh when an external table is created.
    table_format str
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    tags Sequence[ExternalTableTagArgs]
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    columns List<Property Map>
    Definitions of a column to create in the external table. Minimum one required.
    database String
    The database in which to create the external table.
    fileFormat String
    Specifies the file format for the external table.
    location String
    Specifies a location for the external table.
    schema String
    The schema in which to create the external table.
    autoRefresh Boolean
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    awsSnsTopic String
    Specifies the aws sns topic for the external table.
    comment String
    Specifies a comment for the external table.
    copyGrants Boolean
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    name String
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    partitionBies List<String>
    Specifies any partition columns to evaluate for the external table.
    pattern String
    Specifies the file names and/or paths on the external stage to match.
    refreshOnCreate Boolean
    Specifies weather to refresh when an external table is created.
    tableFormat String
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    tags List<Property Map>
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    Outputs

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

    Id string
    The provider-assigned unique ID for this managed resource.
    Owner string
    Name of the role that owns the external table.
    Id string
    The provider-assigned unique ID for this managed resource.
    Owner string
    Name of the role that owns the external table.
    id String
    The provider-assigned unique ID for this managed resource.
    owner String
    Name of the role that owns the external table.
    id string
    The provider-assigned unique ID for this managed resource.
    owner string
    Name of the role that owns the external table.
    id str
    The provider-assigned unique ID for this managed resource.
    owner str
    Name of the role that owns the external table.
    id String
    The provider-assigned unique ID for this managed resource.
    owner String
    Name of the role that owns the external table.

    Look up Existing ExternalTable Resource

    Get an existing ExternalTable 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?: ExternalTableState, opts?: CustomResourceOptions): ExternalTable
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            auto_refresh: Optional[bool] = None,
            aws_sns_topic: Optional[str] = None,
            columns: Optional[Sequence[ExternalTableColumnArgs]] = None,
            comment: Optional[str] = None,
            copy_grants: Optional[bool] = None,
            database: Optional[str] = None,
            file_format: Optional[str] = None,
            location: Optional[str] = None,
            name: Optional[str] = None,
            owner: Optional[str] = None,
            partition_bies: Optional[Sequence[str]] = None,
            pattern: Optional[str] = None,
            refresh_on_create: Optional[bool] = None,
            schema: Optional[str] = None,
            table_format: Optional[str] = None,
            tags: Optional[Sequence[ExternalTableTagArgs]] = None) -> ExternalTable
    func GetExternalTable(ctx *Context, name string, id IDInput, state *ExternalTableState, opts ...ResourceOption) (*ExternalTable, error)
    public static ExternalTable Get(string name, Input<string> id, ExternalTableState? state, CustomResourceOptions? opts = null)
    public static ExternalTable get(String name, Output<String> id, ExternalTableState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AutoRefresh bool
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    AwsSnsTopic string
    Specifies the aws sns topic for the external table.
    Columns List<ExternalTableColumn>
    Definitions of a column to create in the external table. Minimum one required.
    Comment string
    Specifies a comment for the external table.
    CopyGrants bool
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    Database string
    The database in which to create the external table.
    FileFormat string
    Specifies the file format for the external table.
    Location string
    Specifies a location for the external table.
    Name string
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    Owner string
    Name of the role that owns the external table.
    PartitionBies List<string>
    Specifies any partition columns to evaluate for the external table.
    Pattern string
    Specifies the file names and/or paths on the external stage to match.
    RefreshOnCreate bool
    Specifies weather to refresh when an external table is created.
    Schema string
    The schema in which to create the external table.
    TableFormat string
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    Tags List<ExternalTableTag>
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    AutoRefresh bool
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    AwsSnsTopic string
    Specifies the aws sns topic for the external table.
    Columns []ExternalTableColumnArgs
    Definitions of a column to create in the external table. Minimum one required.
    Comment string
    Specifies a comment for the external table.
    CopyGrants bool
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    Database string
    The database in which to create the external table.
    FileFormat string
    Specifies the file format for the external table.
    Location string
    Specifies a location for the external table.
    Name string
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    Owner string
    Name of the role that owns the external table.
    PartitionBies []string
    Specifies any partition columns to evaluate for the external table.
    Pattern string
    Specifies the file names and/or paths on the external stage to match.
    RefreshOnCreate bool
    Specifies weather to refresh when an external table is created.
    Schema string
    The schema in which to create the external table.
    TableFormat string
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    Tags []ExternalTableTagArgs
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    autoRefresh Boolean
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    awsSnsTopic String
    Specifies the aws sns topic for the external table.
    columns List<ExternalTableColumn>
    Definitions of a column to create in the external table. Minimum one required.
    comment String
    Specifies a comment for the external table.
    copyGrants Boolean
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    database String
    The database in which to create the external table.
    fileFormat String
    Specifies the file format for the external table.
    location String
    Specifies a location for the external table.
    name String
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    owner String
    Name of the role that owns the external table.
    partitionBies List<String>
    Specifies any partition columns to evaluate for the external table.
    pattern String
    Specifies the file names and/or paths on the external stage to match.
    refreshOnCreate Boolean
    Specifies weather to refresh when an external table is created.
    schema String
    The schema in which to create the external table.
    tableFormat String
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    tags List<ExternalTableTag>
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    autoRefresh boolean
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    awsSnsTopic string
    Specifies the aws sns topic for the external table.
    columns ExternalTableColumn[]
    Definitions of a column to create in the external table. Minimum one required.
    comment string
    Specifies a comment for the external table.
    copyGrants boolean
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    database string
    The database in which to create the external table.
    fileFormat string
    Specifies the file format for the external table.
    location string
    Specifies a location for the external table.
    name string
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    owner string
    Name of the role that owns the external table.
    partitionBies string[]
    Specifies any partition columns to evaluate for the external table.
    pattern string
    Specifies the file names and/or paths on the external stage to match.
    refreshOnCreate boolean
    Specifies weather to refresh when an external table is created.
    schema string
    The schema in which to create the external table.
    tableFormat string
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    tags ExternalTableTag[]
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    auto_refresh bool
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    aws_sns_topic str
    Specifies the aws sns topic for the external table.
    columns Sequence[ExternalTableColumnArgs]
    Definitions of a column to create in the external table. Minimum one required.
    comment str
    Specifies a comment for the external table.
    copy_grants bool
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    database str
    The database in which to create the external table.
    file_format str
    Specifies the file format for the external table.
    location str
    Specifies a location for the external table.
    name str
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    owner str
    Name of the role that owns the external table.
    partition_bies Sequence[str]
    Specifies any partition columns to evaluate for the external table.
    pattern str
    Specifies the file names and/or paths on the external stage to match.
    refresh_on_create bool
    Specifies weather to refresh when an external table is created.
    schema str
    The schema in which to create the external table.
    table_format str
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    tags Sequence[ExternalTableTagArgs]
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    autoRefresh Boolean
    Specifies whether to automatically refresh the external table metadata once, immediately after the external table is created.
    awsSnsTopic String
    Specifies the aws sns topic for the external table.
    columns List<Property Map>
    Definitions of a column to create in the external table. Minimum one required.
    comment String
    Specifies a comment for the external table.
    copyGrants Boolean
    Specifies to retain the access permissions from the original table when an external table is recreated using the CREATE OR REPLACE TABLE variant
    database String
    The database in which to create the external table.
    fileFormat String
    Specifies the file format for the external table.
    location String
    Specifies a location for the external table.
    name String
    Specifies the identifier for the external table; must be unique for the database and schema in which the externalTable is created.
    owner String
    Name of the role that owns the external table.
    partitionBies List<String>
    Specifies any partition columns to evaluate for the external table.
    pattern String
    Specifies the file names and/or paths on the external stage to match.
    refreshOnCreate Boolean
    Specifies weather to refresh when an external table is created.
    schema String
    The schema in which to create the external table.
    tableFormat String
    Identifies the external table table type. For now, only "delta" for Delta Lake table format is supported.
    tags List<Property Map>
    Definitions of a tag to associate with the resource.

    Deprecated: Use the 'snowflake_tag_association' resource instead.

    Supporting Types

    ExternalTableColumn, ExternalTableColumnArgs

    As string
    String that specifies the expression for the column. When queried, the column returns results derived from this expression.
    Name string
    Column name
    Type string
    Column type, e.g. VARIANT
    As string
    String that specifies the expression for the column. When queried, the column returns results derived from this expression.
    Name string
    Column name
    Type string
    Column type, e.g. VARIANT
    as String
    String that specifies the expression for the column. When queried, the column returns results derived from this expression.
    name String
    Column name
    type String
    Column type, e.g. VARIANT
    as string
    String that specifies the expression for the column. When queried, the column returns results derived from this expression.
    name string
    Column name
    type string
    Column type, e.g. VARIANT
    as_ str
    String that specifies the expression for the column. When queried, the column returns results derived from this expression.
    name str
    Column name
    type str
    Column type, e.g. VARIANT
    as String
    String that specifies the expression for the column. When queried, the column returns results derived from this expression.
    name String
    Column name
    type String
    Column type, e.g. VARIANT

    ExternalTableTag, ExternalTableTagArgs

    Name string
    Tag name, e.g. department.
    Value string
    Tag value, e.g. marketing_info.
    Database string
    Name of the database that the tag was created in.
    Schema string
    Name of the schema that the tag was created in.
    Name string
    Tag name, e.g. department.
    Value string
    Tag value, e.g. marketing_info.
    Database string
    Name of the database that the tag was created in.
    Schema string
    Name of the schema that the tag was created in.
    name String
    Tag name, e.g. department.
    value String
    Tag value, e.g. marketing_info.
    database String
    Name of the database that the tag was created in.
    schema String
    Name of the schema that the tag was created in.
    name string
    Tag name, e.g. department.
    value string
    Tag value, e.g. marketing_info.
    database string
    Name of the database that the tag was created in.
    schema string
    Name of the schema that the tag was created in.
    name str
    Tag name, e.g. department.
    value str
    Tag value, e.g. marketing_info.
    database str
    Name of the database that the tag was created in.
    schema str
    Name of the schema that the tag was created in.
    name String
    Tag name, e.g. department.
    value String
    Tag value, e.g. marketing_info.
    database String
    Name of the database that the tag was created in.
    schema String
    Name of the schema that the tag was created in.

    Import

    format is database name | schema name | external table name

    $ pulumi import snowflake:index/externalTable:ExternalTable example 'dbName|schemaName|externalTableName'
    

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

    Package Details

    Repository
    Snowflake pulumi/pulumi-snowflake
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the snowflake Terraform Provider.
    snowflake logo
    Snowflake v0.55.0 published on Friday, Jun 7, 2024 by Pulumi