!> 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 preview_features_enabled 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 Temporary stages are not supported because they result in per-session objects.
Note External changes detection on the
encryptionanddirectory.notification_integrationfields are not supported because Snowflake does not return such settings in DESCRIBE or SHOW STAGE output.
Note Due to Snowflake limitations, when
directory.auto_refreshis set to a new value in the configuration, the resource is recreated. When it is unset, the provider alters the wholedirectoryfield with theenablevalue from the configuration.
Resource used to manage external GCS stages. For more information, check external stage 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 with storage integration (required for GCS)
const basic = new snowflake.StageExternalGcs("basic", {
name: "my_gcs_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
});
// Complete resource with all options
const complete = new snowflake.StageExternalGcs("complete", {
name: "complete_gcs_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
encryption: {
gcsSseKms: {
kmsKeyId: gcsKmsKeyId,
},
},
directory: {
enable: true,
refreshOnCreate: "true",
autoRefresh: "false",
},
comment: "Fully configured GCS external stage",
});
// Resource with encryption set to none
const noEncryption = new snowflake.StageExternalGcs("no_encryption", {
name: "gcs_stage_no_encryption",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
encryption: {
none: {},
},
});
// Resource with GCS SSE KMS encryption without specifying key
const defaultKms = new snowflake.StageExternalGcs("default_kms", {
name: "gcs_stage_default_kms",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
encryption: {
gcsSseKms: {},
},
});
// resource with inline CSV file format
const withCsvFormat = new snowflake.StageExternalGcs("with_csv_format", {
name: "gcs_csv_format_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
fileFormat: {
csv: {
compression: "GZIP",
recordDelimiter: "\n",
fieldDelimiter: "|",
multiLine: "false",
fileExtension: ".csv",
skipHeader: 1,
skipBlankLines: "true",
dateFormat: "AUTO",
timeFormat: "AUTO",
timestampFormat: "AUTO",
binaryFormat: "HEX",
escape: "\\",
escapeUnenclosedField: "\\",
trimSpace: "false",
fieldOptionallyEnclosedBy: "\"",
nullIfs: [
"NULL",
"",
],
errorOnColumnCountMismatch: "true",
replaceInvalidCharacters: "false",
emptyFieldAsNull: "true",
skipByteOrderMark: "true",
encoding: "UTF8",
},
},
});
// resource with inline JSON file format
const withJsonFormat = new snowflake.StageExternalGcs("with_json_format", {
name: "gcs_json_format_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
fileFormat: {
json: {
compression: "AUTO",
dateFormat: "AUTO",
timeFormat: "AUTO",
timestampFormat: "AUTO",
binaryFormat: "HEX",
trimSpace: "false",
multiLine: "false",
nullIfs: [
"NULL",
"",
],
fileExtension: ".json",
enableOctal: "false",
allowDuplicate: "false",
stripOuterArray: "false",
stripNullValues: "false",
replaceInvalidCharacters: "false",
skipByteOrderMark: "false",
},
},
});
// resource with inline AVRO file format
const withAvroFormat = new snowflake.StageExternalGcs("with_avro_format", {
name: "gcs_avro_format_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
fileFormat: {
avro: {
compression: "GZIP",
trimSpace: "false",
replaceInvalidCharacters: "false",
nullIfs: [
"NULL",
"",
],
},
},
});
// resource with inline ORC file format
const withOrcFormat = new snowflake.StageExternalGcs("with_orc_format", {
name: "gcs_orc_format_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
fileFormat: {
orc: {
trimSpace: "false",
replaceInvalidCharacters: "false",
nullIfs: [
"NULL",
"",
],
},
},
});
// resource with inline Parquet file format
const withParquetFormat = new snowflake.StageExternalGcs("with_parquet_format", {
name: "gcs_parquet_format_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
fileFormat: {
parquet: {
compression: "SNAPPY",
binaryAsText: "true",
useLogicalType: "true",
trimSpace: "false",
useVectorizedScanner: "false",
replaceInvalidCharacters: "false",
nullIfs: [
"NULL",
"",
],
},
},
});
// resource with inline XML file format
const withXmlFormat = new snowflake.StageExternalGcs("with_xml_format", {
name: "gcs_xml_format_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
fileFormat: {
xml: {
compression: "AUTO",
preserveSpace: "false",
stripOuterElement: "false",
disableAutoConvert: "false",
replaceInvalidCharacters: "false",
skipByteOrderMark: "false",
},
},
});
// resource with named file format
const withNamedFormat = new snowflake.StageExternalGcs("with_named_format", {
name: "gcs_named_format_stage",
database: "my_database",
schema: "my_schema",
url: "gcs://mybucket/mypath/",
storageIntegration: gcs.name,
fileFormat: {
formatName: test.fullyQualifiedName,
},
});
import pulumi
import pulumi_snowflake as snowflake
# Basic resource with storage integration (required for GCS)
basic = snowflake.StageExternalGcs("basic",
name="my_gcs_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"])
# Complete resource with all options
complete = snowflake.StageExternalGcs("complete",
name="complete_gcs_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
encryption={
"gcs_sse_kms": {
"kms_key_id": gcs_kms_key_id,
},
},
directory={
"enable": True,
"refresh_on_create": "true",
"auto_refresh": "false",
},
comment="Fully configured GCS external stage")
# Resource with encryption set to none
no_encryption = snowflake.StageExternalGcs("no_encryption",
name="gcs_stage_no_encryption",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
encryption={
"none": {},
})
# Resource with GCS SSE KMS encryption without specifying key
default_kms = snowflake.StageExternalGcs("default_kms",
name="gcs_stage_default_kms",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
encryption={
"gcs_sse_kms": {},
})
# resource with inline CSV file format
with_csv_format = snowflake.StageExternalGcs("with_csv_format",
name="gcs_csv_format_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
file_format={
"csv": {
"compression": "GZIP",
"record_delimiter": "\n",
"field_delimiter": "|",
"multi_line": "false",
"file_extension": ".csv",
"skip_header": 1,
"skip_blank_lines": "true",
"date_format": "AUTO",
"time_format": "AUTO",
"timestamp_format": "AUTO",
"binary_format": "HEX",
"escape": "\\",
"escape_unenclosed_field": "\\",
"trim_space": "false",
"field_optionally_enclosed_by": "\"",
"null_ifs": [
"NULL",
"",
],
"error_on_column_count_mismatch": "true",
"replace_invalid_characters": "false",
"empty_field_as_null": "true",
"skip_byte_order_mark": "true",
"encoding": "UTF8",
},
})
# resource with inline JSON file format
with_json_format = snowflake.StageExternalGcs("with_json_format",
name="gcs_json_format_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
file_format={
"json": {
"compression": "AUTO",
"date_format": "AUTO",
"time_format": "AUTO",
"timestamp_format": "AUTO",
"binary_format": "HEX",
"trim_space": "false",
"multi_line": "false",
"null_ifs": [
"NULL",
"",
],
"file_extension": ".json",
"enable_octal": "false",
"allow_duplicate": "false",
"strip_outer_array": "false",
"strip_null_values": "false",
"replace_invalid_characters": "false",
"skip_byte_order_mark": "false",
},
})
# resource with inline AVRO file format
with_avro_format = snowflake.StageExternalGcs("with_avro_format",
name="gcs_avro_format_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
file_format={
"avro": {
"compression": "GZIP",
"trim_space": "false",
"replace_invalid_characters": "false",
"null_ifs": [
"NULL",
"",
],
},
})
# resource with inline ORC file format
with_orc_format = snowflake.StageExternalGcs("with_orc_format",
name="gcs_orc_format_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
file_format={
"orc": {
"trim_space": "false",
"replace_invalid_characters": "false",
"null_ifs": [
"NULL",
"",
],
},
})
# resource with inline Parquet file format
with_parquet_format = snowflake.StageExternalGcs("with_parquet_format",
name="gcs_parquet_format_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
file_format={
"parquet": {
"compression": "SNAPPY",
"binary_as_text": "true",
"use_logical_type": "true",
"trim_space": "false",
"use_vectorized_scanner": "false",
"replace_invalid_characters": "false",
"null_ifs": [
"NULL",
"",
],
},
})
# resource with inline XML file format
with_xml_format = snowflake.StageExternalGcs("with_xml_format",
name="gcs_xml_format_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
file_format={
"xml": {
"compression": "AUTO",
"preserve_space": "false",
"strip_outer_element": "false",
"disable_auto_convert": "false",
"replace_invalid_characters": "false",
"skip_byte_order_mark": "false",
},
})
# resource with named file format
with_named_format = snowflake.StageExternalGcs("with_named_format",
name="gcs_named_format_stage",
database="my_database",
schema="my_schema",
url="gcs://mybucket/mypath/",
storage_integration=gcs["name"],
file_format={
"format_name": test["fullyQualifiedName"],
})
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 with storage integration (required for GCS)
_, err := snowflake.NewStageExternalGcs(ctx, "basic", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("my_gcs_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
})
if err != nil {
return err
}
// Complete resource with all options
_, err = snowflake.NewStageExternalGcs(ctx, "complete", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("complete_gcs_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
Encryption: &snowflake.StageExternalGcsEncryptionArgs{
GcsSseKms: &snowflake.StageExternalGcsEncryptionGcsSseKmsArgs{
KmsKeyId: pulumi.Any(gcsKmsKeyId),
},
},
Directory: &snowflake.StageExternalGcsDirectoryArgs{
Enable: pulumi.Bool(true),
RefreshOnCreate: pulumi.String("true"),
AutoRefresh: pulumi.String("false"),
},
Comment: pulumi.String("Fully configured GCS external stage"),
})
if err != nil {
return err
}
// Resource with encryption set to none
_, err = snowflake.NewStageExternalGcs(ctx, "no_encryption", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_stage_no_encryption"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
Encryption: &snowflake.StageExternalGcsEncryptionArgs{
None: &snowflake.StageExternalGcsEncryptionNoneArgs{},
},
})
if err != nil {
return err
}
// Resource with GCS SSE KMS encryption without specifying key
_, err = snowflake.NewStageExternalGcs(ctx, "default_kms", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_stage_default_kms"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
Encryption: &snowflake.StageExternalGcsEncryptionArgs{
GcsSseKms: &snowflake.StageExternalGcsEncryptionGcsSseKmsArgs{},
},
})
if err != nil {
return err
}
// resource with inline CSV file format
_, err = snowflake.NewStageExternalGcs(ctx, "with_csv_format", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_csv_format_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
FileFormat: &snowflake.StageExternalGcsFileFormatArgs{
Csv: &snowflake.StageExternalGcsFileFormatCsvArgs{
Compression: pulumi.String("GZIP"),
RecordDelimiter: pulumi.String("\n"),
FieldDelimiter: pulumi.String("|"),
MultiLine: pulumi.String("false"),
FileExtension: pulumi.String(".csv"),
SkipHeader: pulumi.Int(1),
SkipBlankLines: pulumi.String("true"),
DateFormat: pulumi.String("AUTO"),
TimeFormat: pulumi.String("AUTO"),
TimestampFormat: pulumi.String("AUTO"),
BinaryFormat: pulumi.String("HEX"),
Escape: pulumi.String("\\"),
EscapeUnenclosedField: pulumi.String("\\"),
TrimSpace: pulumi.String("false"),
FieldOptionallyEnclosedBy: pulumi.String("\""),
NullIfs: pulumi.StringArray{
pulumi.String("NULL"),
pulumi.String(""),
},
ErrorOnColumnCountMismatch: pulumi.String("true"),
ReplaceInvalidCharacters: pulumi.String("false"),
EmptyFieldAsNull: pulumi.String("true"),
SkipByteOrderMark: pulumi.String("true"),
Encoding: pulumi.String("UTF8"),
},
},
})
if err != nil {
return err
}
// resource with inline JSON file format
_, err = snowflake.NewStageExternalGcs(ctx, "with_json_format", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_json_format_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
FileFormat: &snowflake.StageExternalGcsFileFormatArgs{
Json: &snowflake.StageExternalGcsFileFormatJsonArgs{
Compression: pulumi.String("AUTO"),
DateFormat: pulumi.String("AUTO"),
TimeFormat: pulumi.String("AUTO"),
TimestampFormat: pulumi.String("AUTO"),
BinaryFormat: pulumi.String("HEX"),
TrimSpace: pulumi.String("false"),
MultiLine: pulumi.String("false"),
NullIfs: pulumi.StringArray{
pulumi.String("NULL"),
pulumi.String(""),
},
FileExtension: pulumi.String(".json"),
EnableOctal: pulumi.String("false"),
AllowDuplicate: pulumi.String("false"),
StripOuterArray: pulumi.String("false"),
StripNullValues: pulumi.String("false"),
ReplaceInvalidCharacters: pulumi.String("false"),
SkipByteOrderMark: pulumi.String("false"),
},
},
})
if err != nil {
return err
}
// resource with inline AVRO file format
_, err = snowflake.NewStageExternalGcs(ctx, "with_avro_format", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_avro_format_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
FileFormat: &snowflake.StageExternalGcsFileFormatArgs{
Avro: &snowflake.StageExternalGcsFileFormatAvroArgs{
Compression: pulumi.String("GZIP"),
TrimSpace: pulumi.String("false"),
ReplaceInvalidCharacters: pulumi.String("false"),
NullIfs: pulumi.StringArray{
pulumi.String("NULL"),
pulumi.String(""),
},
},
},
})
if err != nil {
return err
}
// resource with inline ORC file format
_, err = snowflake.NewStageExternalGcs(ctx, "with_orc_format", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_orc_format_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
FileFormat: &snowflake.StageExternalGcsFileFormatArgs{
Orc: &snowflake.StageExternalGcsFileFormatOrcArgs{
TrimSpace: pulumi.String("false"),
ReplaceInvalidCharacters: pulumi.String("false"),
NullIfs: pulumi.StringArray{
pulumi.String("NULL"),
pulumi.String(""),
},
},
},
})
if err != nil {
return err
}
// resource with inline Parquet file format
_, err = snowflake.NewStageExternalGcs(ctx, "with_parquet_format", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_parquet_format_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
FileFormat: &snowflake.StageExternalGcsFileFormatArgs{
Parquet: &snowflake.StageExternalGcsFileFormatParquetArgs{
Compression: pulumi.String("SNAPPY"),
BinaryAsText: pulumi.String("true"),
UseLogicalType: pulumi.String("true"),
TrimSpace: pulumi.String("false"),
UseVectorizedScanner: pulumi.String("false"),
ReplaceInvalidCharacters: pulumi.String("false"),
NullIfs: pulumi.StringArray{
pulumi.String("NULL"),
pulumi.String(""),
},
},
},
})
if err != nil {
return err
}
// resource with inline XML file format
_, err = snowflake.NewStageExternalGcs(ctx, "with_xml_format", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_xml_format_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
FileFormat: &snowflake.StageExternalGcsFileFormatArgs{
Xml: &snowflake.StageExternalGcsFileFormatXmlArgs{
Compression: pulumi.String("AUTO"),
PreserveSpace: pulumi.String("false"),
StripOuterElement: pulumi.String("false"),
DisableAutoConvert: pulumi.String("false"),
ReplaceInvalidCharacters: pulumi.String("false"),
SkipByteOrderMark: pulumi.String("false"),
},
},
})
if err != nil {
return err
}
// resource with named file format
_, err = snowflake.NewStageExternalGcs(ctx, "with_named_format", &snowflake.StageExternalGcsArgs{
Name: pulumi.String("gcs_named_format_stage"),
Database: pulumi.String("my_database"),
Schema: pulumi.String("my_schema"),
Url: pulumi.String("gcs://mybucket/mypath/"),
StorageIntegration: pulumi.Any(gcs.Name),
FileFormat: &snowflake.StageExternalGcsFileFormatArgs{
FormatName: pulumi.Any(test.FullyQualifiedName),
},
})
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 with storage integration (required for GCS)
var basic = new Snowflake.StageExternalGcs("basic", new()
{
Name = "my_gcs_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
});
// Complete resource with all options
var complete = new Snowflake.StageExternalGcs("complete", new()
{
Name = "complete_gcs_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
Encryption = new Snowflake.Inputs.StageExternalGcsEncryptionArgs
{
GcsSseKms = new Snowflake.Inputs.StageExternalGcsEncryptionGcsSseKmsArgs
{
KmsKeyId = gcsKmsKeyId,
},
},
Directory = new Snowflake.Inputs.StageExternalGcsDirectoryArgs
{
Enable = true,
RefreshOnCreate = "true",
AutoRefresh = "false",
},
Comment = "Fully configured GCS external stage",
});
// Resource with encryption set to none
var noEncryption = new Snowflake.StageExternalGcs("no_encryption", new()
{
Name = "gcs_stage_no_encryption",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
Encryption = new Snowflake.Inputs.StageExternalGcsEncryptionArgs
{
None = null,
},
});
// Resource with GCS SSE KMS encryption without specifying key
var defaultKms = new Snowflake.StageExternalGcs("default_kms", new()
{
Name = "gcs_stage_default_kms",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
Encryption = new Snowflake.Inputs.StageExternalGcsEncryptionArgs
{
GcsSseKms = null,
},
});
// resource with inline CSV file format
var withCsvFormat = new Snowflake.StageExternalGcs("with_csv_format", new()
{
Name = "gcs_csv_format_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
FileFormat = new Snowflake.Inputs.StageExternalGcsFileFormatArgs
{
Csv = new Snowflake.Inputs.StageExternalGcsFileFormatCsvArgs
{
Compression = "GZIP",
RecordDelimiter = @"
",
FieldDelimiter = "|",
MultiLine = "false",
FileExtension = ".csv",
SkipHeader = 1,
SkipBlankLines = "true",
DateFormat = "AUTO",
TimeFormat = "AUTO",
TimestampFormat = "AUTO",
BinaryFormat = "HEX",
Escape = "\\",
EscapeUnenclosedField = "\\",
TrimSpace = "false",
FieldOptionallyEnclosedBy = "\"",
NullIfs = new[]
{
"NULL",
"",
},
ErrorOnColumnCountMismatch = "true",
ReplaceInvalidCharacters = "false",
EmptyFieldAsNull = "true",
SkipByteOrderMark = "true",
Encoding = "UTF8",
},
},
});
// resource with inline JSON file format
var withJsonFormat = new Snowflake.StageExternalGcs("with_json_format", new()
{
Name = "gcs_json_format_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
FileFormat = new Snowflake.Inputs.StageExternalGcsFileFormatArgs
{
Json = new Snowflake.Inputs.StageExternalGcsFileFormatJsonArgs
{
Compression = "AUTO",
DateFormat = "AUTO",
TimeFormat = "AUTO",
TimestampFormat = "AUTO",
BinaryFormat = "HEX",
TrimSpace = "false",
MultiLine = "false",
NullIfs = new[]
{
"NULL",
"",
},
FileExtension = ".json",
EnableOctal = "false",
AllowDuplicate = "false",
StripOuterArray = "false",
StripNullValues = "false",
ReplaceInvalidCharacters = "false",
SkipByteOrderMark = "false",
},
},
});
// resource with inline AVRO file format
var withAvroFormat = new Snowflake.StageExternalGcs("with_avro_format", new()
{
Name = "gcs_avro_format_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
FileFormat = new Snowflake.Inputs.StageExternalGcsFileFormatArgs
{
Avro = new Snowflake.Inputs.StageExternalGcsFileFormatAvroArgs
{
Compression = "GZIP",
TrimSpace = "false",
ReplaceInvalidCharacters = "false",
NullIfs = new[]
{
"NULL",
"",
},
},
},
});
// resource with inline ORC file format
var withOrcFormat = new Snowflake.StageExternalGcs("with_orc_format", new()
{
Name = "gcs_orc_format_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
FileFormat = new Snowflake.Inputs.StageExternalGcsFileFormatArgs
{
Orc = new Snowflake.Inputs.StageExternalGcsFileFormatOrcArgs
{
TrimSpace = "false",
ReplaceInvalidCharacters = "false",
NullIfs = new[]
{
"NULL",
"",
},
},
},
});
// resource with inline Parquet file format
var withParquetFormat = new Snowflake.StageExternalGcs("with_parquet_format", new()
{
Name = "gcs_parquet_format_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
FileFormat = new Snowflake.Inputs.StageExternalGcsFileFormatArgs
{
Parquet = new Snowflake.Inputs.StageExternalGcsFileFormatParquetArgs
{
Compression = "SNAPPY",
BinaryAsText = "true",
UseLogicalType = "true",
TrimSpace = "false",
UseVectorizedScanner = "false",
ReplaceInvalidCharacters = "false",
NullIfs = new[]
{
"NULL",
"",
},
},
},
});
// resource with inline XML file format
var withXmlFormat = new Snowflake.StageExternalGcs("with_xml_format", new()
{
Name = "gcs_xml_format_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
FileFormat = new Snowflake.Inputs.StageExternalGcsFileFormatArgs
{
Xml = new Snowflake.Inputs.StageExternalGcsFileFormatXmlArgs
{
Compression = "AUTO",
PreserveSpace = "false",
StripOuterElement = "false",
DisableAutoConvert = "false",
ReplaceInvalidCharacters = "false",
SkipByteOrderMark = "false",
},
},
});
// resource with named file format
var withNamedFormat = new Snowflake.StageExternalGcs("with_named_format", new()
{
Name = "gcs_named_format_stage",
Database = "my_database",
Schema = "my_schema",
Url = "gcs://mybucket/mypath/",
StorageIntegration = gcs.Name,
FileFormat = new Snowflake.Inputs.StageExternalGcsFileFormatArgs
{
FormatName = test.FullyQualifiedName,
},
});
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.snowflake.StageExternalGcs;
import com.pulumi.snowflake.StageExternalGcsArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsEncryptionArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsEncryptionGcsSseKmsArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsDirectoryArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsEncryptionNoneArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsFileFormatArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsFileFormatCsvArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsFileFormatJsonArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsFileFormatAvroArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsFileFormatOrcArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsFileFormatParquetArgs;
import com.pulumi.snowflake.inputs.StageExternalGcsFileFormatXmlArgs;
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) {
// Basic resource with storage integration (required for GCS)
var basic = new StageExternalGcs("basic", StageExternalGcsArgs.builder()
.name("my_gcs_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.build());
// Complete resource with all options
var complete = new StageExternalGcs("complete", StageExternalGcsArgs.builder()
.name("complete_gcs_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.encryption(StageExternalGcsEncryptionArgs.builder()
.gcsSseKms(StageExternalGcsEncryptionGcsSseKmsArgs.builder()
.kmsKeyId(gcsKmsKeyId)
.build())
.build())
.directory(StageExternalGcsDirectoryArgs.builder()
.enable(true)
.refreshOnCreate("true")
.autoRefresh("false")
.build())
.comment("Fully configured GCS external stage")
.build());
// Resource with encryption set to none
var noEncryption = new StageExternalGcs("noEncryption", StageExternalGcsArgs.builder()
.name("gcs_stage_no_encryption")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.encryption(StageExternalGcsEncryptionArgs.builder()
.none(StageExternalGcsEncryptionNoneArgs.builder()
.build())
.build())
.build());
// Resource with GCS SSE KMS encryption without specifying key
var defaultKms = new StageExternalGcs("defaultKms", StageExternalGcsArgs.builder()
.name("gcs_stage_default_kms")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.encryption(StageExternalGcsEncryptionArgs.builder()
.gcsSseKms(StageExternalGcsEncryptionGcsSseKmsArgs.builder()
.build())
.build())
.build());
// resource with inline CSV file format
var withCsvFormat = new StageExternalGcs("withCsvFormat", StageExternalGcsArgs.builder()
.name("gcs_csv_format_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.fileFormat(StageExternalGcsFileFormatArgs.builder()
.csv(StageExternalGcsFileFormatCsvArgs.builder()
.compression("GZIP")
.recordDelimiter("""
""")
.fieldDelimiter("|")
.multiLine("false")
.fileExtension(".csv")
.skipHeader(1)
.skipBlankLines("true")
.dateFormat("AUTO")
.timeFormat("AUTO")
.timestampFormat("AUTO")
.binaryFormat("HEX")
.escape("\\")
.escapeUnenclosedField("\\")
.trimSpace("false")
.fieldOptionallyEnclosedBy("\"")
.nullIfs(
"NULL",
"")
.errorOnColumnCountMismatch("true")
.replaceInvalidCharacters("false")
.emptyFieldAsNull("true")
.skipByteOrderMark("true")
.encoding("UTF8")
.build())
.build())
.build());
// resource with inline JSON file format
var withJsonFormat = new StageExternalGcs("withJsonFormat", StageExternalGcsArgs.builder()
.name("gcs_json_format_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.fileFormat(StageExternalGcsFileFormatArgs.builder()
.json(StageExternalGcsFileFormatJsonArgs.builder()
.compression("AUTO")
.dateFormat("AUTO")
.timeFormat("AUTO")
.timestampFormat("AUTO")
.binaryFormat("HEX")
.trimSpace("false")
.multiLine("false")
.nullIfs(
"NULL",
"")
.fileExtension(".json")
.enableOctal("false")
.allowDuplicate("false")
.stripOuterArray("false")
.stripNullValues("false")
.replaceInvalidCharacters("false")
.skipByteOrderMark("false")
.build())
.build())
.build());
// resource with inline AVRO file format
var withAvroFormat = new StageExternalGcs("withAvroFormat", StageExternalGcsArgs.builder()
.name("gcs_avro_format_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.fileFormat(StageExternalGcsFileFormatArgs.builder()
.avro(StageExternalGcsFileFormatAvroArgs.builder()
.compression("GZIP")
.trimSpace("false")
.replaceInvalidCharacters("false")
.nullIfs(
"NULL",
"")
.build())
.build())
.build());
// resource with inline ORC file format
var withOrcFormat = new StageExternalGcs("withOrcFormat", StageExternalGcsArgs.builder()
.name("gcs_orc_format_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.fileFormat(StageExternalGcsFileFormatArgs.builder()
.orc(StageExternalGcsFileFormatOrcArgs.builder()
.trimSpace("false")
.replaceInvalidCharacters("false")
.nullIfs(
"NULL",
"")
.build())
.build())
.build());
// resource with inline Parquet file format
var withParquetFormat = new StageExternalGcs("withParquetFormat", StageExternalGcsArgs.builder()
.name("gcs_parquet_format_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.fileFormat(StageExternalGcsFileFormatArgs.builder()
.parquet(StageExternalGcsFileFormatParquetArgs.builder()
.compression("SNAPPY")
.binaryAsText("true")
.useLogicalType("true")
.trimSpace("false")
.useVectorizedScanner("false")
.replaceInvalidCharacters("false")
.nullIfs(
"NULL",
"")
.build())
.build())
.build());
// resource with inline XML file format
var withXmlFormat = new StageExternalGcs("withXmlFormat", StageExternalGcsArgs.builder()
.name("gcs_xml_format_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.fileFormat(StageExternalGcsFileFormatArgs.builder()
.xml(StageExternalGcsFileFormatXmlArgs.builder()
.compression("AUTO")
.preserveSpace("false")
.stripOuterElement("false")
.disableAutoConvert("false")
.replaceInvalidCharacters("false")
.skipByteOrderMark("false")
.build())
.build())
.build());
// resource with named file format
var withNamedFormat = new StageExternalGcs("withNamedFormat", StageExternalGcsArgs.builder()
.name("gcs_named_format_stage")
.database("my_database")
.schema("my_schema")
.url("gcs://mybucket/mypath/")
.storageIntegration(gcs.name())
.fileFormat(StageExternalGcsFileFormatArgs.builder()
.formatName(test.fullyQualifiedName())
.build())
.build());
}
}
resources:
# Basic resource with storage integration (required for GCS)
basic:
type: snowflake:StageExternalGcs
properties:
name: my_gcs_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
# Complete resource with all options
complete:
type: snowflake:StageExternalGcs
properties:
name: complete_gcs_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
encryption:
gcsSseKms:
kmsKeyId: ${gcsKmsKeyId}
directory:
enable: true
refreshOnCreate: true
autoRefresh: false
comment: Fully configured GCS external stage
# Resource with encryption set to none
noEncryption:
type: snowflake:StageExternalGcs
name: no_encryption
properties:
name: gcs_stage_no_encryption
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
encryption:
none: {}
# Resource with GCS SSE KMS encryption without specifying key
defaultKms:
type: snowflake:StageExternalGcs
name: default_kms
properties:
name: gcs_stage_default_kms
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
encryption:
gcsSseKms: {}
# resource with inline CSV file format
withCsvFormat:
type: snowflake:StageExternalGcs
name: with_csv_format
properties:
name: gcs_csv_format_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
fileFormat:
csv:
compression: GZIP
recordDelimiter: |2+
fieldDelimiter: '|'
multiLine: 'false'
fileExtension: .csv
skipHeader: 1
skipBlankLines: 'true'
dateFormat: AUTO
timeFormat: AUTO
timestampFormat: AUTO
binaryFormat: HEX
escape: \
escapeUnenclosedField: \
trimSpace: 'false'
fieldOptionallyEnclosedBy: '"'
nullIfs:
- NULL
- ""
errorOnColumnCountMismatch: 'true'
replaceInvalidCharacters: 'false'
emptyFieldAsNull: 'true'
skipByteOrderMark: 'true'
encoding: UTF8
# resource with inline JSON file format
withJsonFormat:
type: snowflake:StageExternalGcs
name: with_json_format
properties:
name: gcs_json_format_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
fileFormat:
json:
compression: AUTO
dateFormat: AUTO
timeFormat: AUTO
timestampFormat: AUTO
binaryFormat: HEX
trimSpace: 'false'
multiLine: 'false'
nullIfs:
- NULL
- ""
fileExtension: .json
enableOctal: 'false'
allowDuplicate: 'false'
stripOuterArray: 'false'
stripNullValues: 'false'
replaceInvalidCharacters: 'false'
skipByteOrderMark: 'false'
# resource with inline AVRO file format
withAvroFormat:
type: snowflake:StageExternalGcs
name: with_avro_format
properties:
name: gcs_avro_format_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
fileFormat:
avro:
compression: GZIP
trimSpace: 'false'
replaceInvalidCharacters: 'false'
nullIfs:
- NULL
- ""
# resource with inline ORC file format
withOrcFormat:
type: snowflake:StageExternalGcs
name: with_orc_format
properties:
name: gcs_orc_format_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
fileFormat:
orc:
trimSpace: 'false'
replaceInvalidCharacters: 'false'
nullIfs:
- NULL
- ""
# resource with inline Parquet file format
withParquetFormat:
type: snowflake:StageExternalGcs
name: with_parquet_format
properties:
name: gcs_parquet_format_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
fileFormat:
parquet:
compression: SNAPPY
binaryAsText: 'true'
useLogicalType: 'true'
trimSpace: 'false'
useVectorizedScanner: 'false'
replaceInvalidCharacters: 'false'
nullIfs:
- NULL
- ""
# resource with inline XML file format
withXmlFormat:
type: snowflake:StageExternalGcs
name: with_xml_format
properties:
name: gcs_xml_format_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
fileFormat:
xml:
compression: AUTO
preserveSpace: 'false'
stripOuterElement: 'false'
disableAutoConvert: 'false'
replaceInvalidCharacters: 'false'
skipByteOrderMark: 'false'
# resource with named file format
withNamedFormat:
type: snowflake:StageExternalGcs
name: with_named_format
properties:
name: gcs_named_format_stage
database: my_database
schema: my_schema
url: gcs://mybucket/mypath/
storageIntegration: ${gcs.name}
fileFormat:
formatName: ${test.fullyQualifiedName}
Note If a field has a default value, it is shown next to the type in the schema.
Create StageExternalGcs Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new StageExternalGcs(name: string, args: StageExternalGcsArgs, opts?: CustomResourceOptions);@overload
def StageExternalGcs(resource_name: str,
args: StageExternalGcsArgs,
opts: Optional[ResourceOptions] = None)
@overload
def StageExternalGcs(resource_name: str,
opts: Optional[ResourceOptions] = None,
database: Optional[str] = None,
schema: Optional[str] = None,
storage_integration: Optional[str] = None,
url: Optional[str] = None,
comment: Optional[str] = None,
directory: Optional[StageExternalGcsDirectoryArgs] = None,
encryption: Optional[StageExternalGcsEncryptionArgs] = None,
file_format: Optional[StageExternalGcsFileFormatArgs] = None,
name: Optional[str] = None)func NewStageExternalGcs(ctx *Context, name string, args StageExternalGcsArgs, opts ...ResourceOption) (*StageExternalGcs, error)public StageExternalGcs(string name, StageExternalGcsArgs args, CustomResourceOptions? opts = null)
public StageExternalGcs(String name, StageExternalGcsArgs args)
public StageExternalGcs(String name, StageExternalGcsArgs args, CustomResourceOptions options)
type: snowflake:StageExternalGcs
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 StageExternalGcsArgs
- 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 StageExternalGcsArgs
- 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 StageExternalGcsArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args StageExternalGcsArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args StageExternalGcsArgs
- 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 stageExternalGcsResource = new Snowflake.StageExternalGcs("stageExternalGcsResource", new()
{
Database = "string",
Schema = "string",
StorageIntegration = "string",
Url = "string",
Comment = "string",
Directory = new Snowflake.Inputs.StageExternalGcsDirectoryArgs
{
Enable = false,
AutoRefresh = "string",
NotificationIntegration = "string",
RefreshOnCreate = "string",
},
Encryption = new Snowflake.Inputs.StageExternalGcsEncryptionArgs
{
GcsSseKms = new Snowflake.Inputs.StageExternalGcsEncryptionGcsSseKmsArgs
{
KmsKeyId = "string",
},
None = null,
},
FileFormat = new Snowflake.Inputs.StageExternalGcsFileFormatArgs
{
Avro = new Snowflake.Inputs.StageExternalGcsFileFormatAvroArgs
{
Compression = "string",
NullIfs = new[]
{
"string",
},
ReplaceInvalidCharacters = "string",
TrimSpace = "string",
},
Csv = new Snowflake.Inputs.StageExternalGcsFileFormatCsvArgs
{
BinaryFormat = "string",
Compression = "string",
DateFormat = "string",
EmptyFieldAsNull = "string",
Encoding = "string",
ErrorOnColumnCountMismatch = "string",
Escape = "string",
EscapeUnenclosedField = "string",
FieldDelimiter = "string",
FieldOptionallyEnclosedBy = "string",
FileExtension = "string",
MultiLine = "string",
NullIfs = new[]
{
"string",
},
ParseHeader = "string",
RecordDelimiter = "string",
ReplaceInvalidCharacters = "string",
SkipBlankLines = "string",
SkipByteOrderMark = "string",
SkipHeader = 0,
TimeFormat = "string",
TimestampFormat = "string",
TrimSpace = "string",
},
FormatName = "string",
Json = new Snowflake.Inputs.StageExternalGcsFileFormatJsonArgs
{
AllowDuplicate = "string",
BinaryFormat = "string",
Compression = "string",
DateFormat = "string",
EnableOctal = "string",
FileExtension = "string",
IgnoreUtf8Errors = "string",
MultiLine = "string",
NullIfs = new[]
{
"string",
},
ReplaceInvalidCharacters = "string",
SkipByteOrderMark = "string",
StripNullValues = "string",
StripOuterArray = "string",
TimeFormat = "string",
TimestampFormat = "string",
TrimSpace = "string",
},
Orc = new Snowflake.Inputs.StageExternalGcsFileFormatOrcArgs
{
NullIfs = new[]
{
"string",
},
ReplaceInvalidCharacters = "string",
TrimSpace = "string",
},
Parquet = new Snowflake.Inputs.StageExternalGcsFileFormatParquetArgs
{
BinaryAsText = "string",
Compression = "string",
NullIfs = new[]
{
"string",
},
ReplaceInvalidCharacters = "string",
TrimSpace = "string",
UseLogicalType = "string",
UseVectorizedScanner = "string",
},
Xml = new Snowflake.Inputs.StageExternalGcsFileFormatXmlArgs
{
Compression = "string",
DisableAutoConvert = "string",
IgnoreUtf8Errors = "string",
PreserveSpace = "string",
ReplaceInvalidCharacters = "string",
SkipByteOrderMark = "string",
StripOuterElement = "string",
},
},
Name = "string",
});
example, err := snowflake.NewStageExternalGcs(ctx, "stageExternalGcsResource", &snowflake.StageExternalGcsArgs{
Database: pulumi.String("string"),
Schema: pulumi.String("string"),
StorageIntegration: pulumi.String("string"),
Url: pulumi.String("string"),
Comment: pulumi.String("string"),
Directory: &snowflake.StageExternalGcsDirectoryArgs{
Enable: pulumi.Bool(false),
AutoRefresh: pulumi.String("string"),
NotificationIntegration: pulumi.String("string"),
RefreshOnCreate: pulumi.String("string"),
},
Encryption: &snowflake.StageExternalGcsEncryptionArgs{
GcsSseKms: &snowflake.StageExternalGcsEncryptionGcsSseKmsArgs{
KmsKeyId: pulumi.String("string"),
},
None: &snowflake.StageExternalGcsEncryptionNoneArgs{},
},
FileFormat: &snowflake.StageExternalGcsFileFormatArgs{
Avro: &snowflake.StageExternalGcsFileFormatAvroArgs{
Compression: pulumi.String("string"),
NullIfs: pulumi.StringArray{
pulumi.String("string"),
},
ReplaceInvalidCharacters: pulumi.String("string"),
TrimSpace: pulumi.String("string"),
},
Csv: &snowflake.StageExternalGcsFileFormatCsvArgs{
BinaryFormat: pulumi.String("string"),
Compression: pulumi.String("string"),
DateFormat: pulumi.String("string"),
EmptyFieldAsNull: pulumi.String("string"),
Encoding: pulumi.String("string"),
ErrorOnColumnCountMismatch: pulumi.String("string"),
Escape: pulumi.String("string"),
EscapeUnenclosedField: pulumi.String("string"),
FieldDelimiter: pulumi.String("string"),
FieldOptionallyEnclosedBy: pulumi.String("string"),
FileExtension: pulumi.String("string"),
MultiLine: pulumi.String("string"),
NullIfs: pulumi.StringArray{
pulumi.String("string"),
},
ParseHeader: pulumi.String("string"),
RecordDelimiter: pulumi.String("string"),
ReplaceInvalidCharacters: pulumi.String("string"),
SkipBlankLines: pulumi.String("string"),
SkipByteOrderMark: pulumi.String("string"),
SkipHeader: pulumi.Int(0),
TimeFormat: pulumi.String("string"),
TimestampFormat: pulumi.String("string"),
TrimSpace: pulumi.String("string"),
},
FormatName: pulumi.String("string"),
Json: &snowflake.StageExternalGcsFileFormatJsonArgs{
AllowDuplicate: pulumi.String("string"),
BinaryFormat: pulumi.String("string"),
Compression: pulumi.String("string"),
DateFormat: pulumi.String("string"),
EnableOctal: pulumi.String("string"),
FileExtension: pulumi.String("string"),
IgnoreUtf8Errors: pulumi.String("string"),
MultiLine: pulumi.String("string"),
NullIfs: pulumi.StringArray{
pulumi.String("string"),
},
ReplaceInvalidCharacters: pulumi.String("string"),
SkipByteOrderMark: pulumi.String("string"),
StripNullValues: pulumi.String("string"),
StripOuterArray: pulumi.String("string"),
TimeFormat: pulumi.String("string"),
TimestampFormat: pulumi.String("string"),
TrimSpace: pulumi.String("string"),
},
Orc: &snowflake.StageExternalGcsFileFormatOrcArgs{
NullIfs: pulumi.StringArray{
pulumi.String("string"),
},
ReplaceInvalidCharacters: pulumi.String("string"),
TrimSpace: pulumi.String("string"),
},
Parquet: &snowflake.StageExternalGcsFileFormatParquetArgs{
BinaryAsText: pulumi.String("string"),
Compression: pulumi.String("string"),
NullIfs: pulumi.StringArray{
pulumi.String("string"),
},
ReplaceInvalidCharacters: pulumi.String("string"),
TrimSpace: pulumi.String("string"),
UseLogicalType: pulumi.String("string"),
UseVectorizedScanner: pulumi.String("string"),
},
Xml: &snowflake.StageExternalGcsFileFormatXmlArgs{
Compression: pulumi.String("string"),
DisableAutoConvert: pulumi.String("string"),
IgnoreUtf8Errors: pulumi.String("string"),
PreserveSpace: pulumi.String("string"),
ReplaceInvalidCharacters: pulumi.String("string"),
SkipByteOrderMark: pulumi.String("string"),
StripOuterElement: pulumi.String("string"),
},
},
Name: pulumi.String("string"),
})
var stageExternalGcsResource = new StageExternalGcs("stageExternalGcsResource", StageExternalGcsArgs.builder()
.database("string")
.schema("string")
.storageIntegration("string")
.url("string")
.comment("string")
.directory(StageExternalGcsDirectoryArgs.builder()
.enable(false)
.autoRefresh("string")
.notificationIntegration("string")
.refreshOnCreate("string")
.build())
.encryption(StageExternalGcsEncryptionArgs.builder()
.gcsSseKms(StageExternalGcsEncryptionGcsSseKmsArgs.builder()
.kmsKeyId("string")
.build())
.none(StageExternalGcsEncryptionNoneArgs.builder()
.build())
.build())
.fileFormat(StageExternalGcsFileFormatArgs.builder()
.avro(StageExternalGcsFileFormatAvroArgs.builder()
.compression("string")
.nullIfs("string")
.replaceInvalidCharacters("string")
.trimSpace("string")
.build())
.csv(StageExternalGcsFileFormatCsvArgs.builder()
.binaryFormat("string")
.compression("string")
.dateFormat("string")
.emptyFieldAsNull("string")
.encoding("string")
.errorOnColumnCountMismatch("string")
.escape("string")
.escapeUnenclosedField("string")
.fieldDelimiter("string")
.fieldOptionallyEnclosedBy("string")
.fileExtension("string")
.multiLine("string")
.nullIfs("string")
.parseHeader("string")
.recordDelimiter("string")
.replaceInvalidCharacters("string")
.skipBlankLines("string")
.skipByteOrderMark("string")
.skipHeader(0)
.timeFormat("string")
.timestampFormat("string")
.trimSpace("string")
.build())
.formatName("string")
.json(StageExternalGcsFileFormatJsonArgs.builder()
.allowDuplicate("string")
.binaryFormat("string")
.compression("string")
.dateFormat("string")
.enableOctal("string")
.fileExtension("string")
.ignoreUtf8Errors("string")
.multiLine("string")
.nullIfs("string")
.replaceInvalidCharacters("string")
.skipByteOrderMark("string")
.stripNullValues("string")
.stripOuterArray("string")
.timeFormat("string")
.timestampFormat("string")
.trimSpace("string")
.build())
.orc(StageExternalGcsFileFormatOrcArgs.builder()
.nullIfs("string")
.replaceInvalidCharacters("string")
.trimSpace("string")
.build())
.parquet(StageExternalGcsFileFormatParquetArgs.builder()
.binaryAsText("string")
.compression("string")
.nullIfs("string")
.replaceInvalidCharacters("string")
.trimSpace("string")
.useLogicalType("string")
.useVectorizedScanner("string")
.build())
.xml(StageExternalGcsFileFormatXmlArgs.builder()
.compression("string")
.disableAutoConvert("string")
.ignoreUtf8Errors("string")
.preserveSpace("string")
.replaceInvalidCharacters("string")
.skipByteOrderMark("string")
.stripOuterElement("string")
.build())
.build())
.name("string")
.build());
stage_external_gcs_resource = snowflake.StageExternalGcs("stageExternalGcsResource",
database="string",
schema="string",
storage_integration="string",
url="string",
comment="string",
directory={
"enable": False,
"auto_refresh": "string",
"notification_integration": "string",
"refresh_on_create": "string",
},
encryption={
"gcs_sse_kms": {
"kms_key_id": "string",
},
"none": {},
},
file_format={
"avro": {
"compression": "string",
"null_ifs": ["string"],
"replace_invalid_characters": "string",
"trim_space": "string",
},
"csv": {
"binary_format": "string",
"compression": "string",
"date_format": "string",
"empty_field_as_null": "string",
"encoding": "string",
"error_on_column_count_mismatch": "string",
"escape": "string",
"escape_unenclosed_field": "string",
"field_delimiter": "string",
"field_optionally_enclosed_by": "string",
"file_extension": "string",
"multi_line": "string",
"null_ifs": ["string"],
"parse_header": "string",
"record_delimiter": "string",
"replace_invalid_characters": "string",
"skip_blank_lines": "string",
"skip_byte_order_mark": "string",
"skip_header": 0,
"time_format": "string",
"timestamp_format": "string",
"trim_space": "string",
},
"format_name": "string",
"json": {
"allow_duplicate": "string",
"binary_format": "string",
"compression": "string",
"date_format": "string",
"enable_octal": "string",
"file_extension": "string",
"ignore_utf8_errors": "string",
"multi_line": "string",
"null_ifs": ["string"],
"replace_invalid_characters": "string",
"skip_byte_order_mark": "string",
"strip_null_values": "string",
"strip_outer_array": "string",
"time_format": "string",
"timestamp_format": "string",
"trim_space": "string",
},
"orc": {
"null_ifs": ["string"],
"replace_invalid_characters": "string",
"trim_space": "string",
},
"parquet": {
"binary_as_text": "string",
"compression": "string",
"null_ifs": ["string"],
"replace_invalid_characters": "string",
"trim_space": "string",
"use_logical_type": "string",
"use_vectorized_scanner": "string",
},
"xml": {
"compression": "string",
"disable_auto_convert": "string",
"ignore_utf8_errors": "string",
"preserve_space": "string",
"replace_invalid_characters": "string",
"skip_byte_order_mark": "string",
"strip_outer_element": "string",
},
},
name="string")
const stageExternalGcsResource = new snowflake.StageExternalGcs("stageExternalGcsResource", {
database: "string",
schema: "string",
storageIntegration: "string",
url: "string",
comment: "string",
directory: {
enable: false,
autoRefresh: "string",
notificationIntegration: "string",
refreshOnCreate: "string",
},
encryption: {
gcsSseKms: {
kmsKeyId: "string",
},
none: {},
},
fileFormat: {
avro: {
compression: "string",
nullIfs: ["string"],
replaceInvalidCharacters: "string",
trimSpace: "string",
},
csv: {
binaryFormat: "string",
compression: "string",
dateFormat: "string",
emptyFieldAsNull: "string",
encoding: "string",
errorOnColumnCountMismatch: "string",
escape: "string",
escapeUnenclosedField: "string",
fieldDelimiter: "string",
fieldOptionallyEnclosedBy: "string",
fileExtension: "string",
multiLine: "string",
nullIfs: ["string"],
parseHeader: "string",
recordDelimiter: "string",
replaceInvalidCharacters: "string",
skipBlankLines: "string",
skipByteOrderMark: "string",
skipHeader: 0,
timeFormat: "string",
timestampFormat: "string",
trimSpace: "string",
},
formatName: "string",
json: {
allowDuplicate: "string",
binaryFormat: "string",
compression: "string",
dateFormat: "string",
enableOctal: "string",
fileExtension: "string",
ignoreUtf8Errors: "string",
multiLine: "string",
nullIfs: ["string"],
replaceInvalidCharacters: "string",
skipByteOrderMark: "string",
stripNullValues: "string",
stripOuterArray: "string",
timeFormat: "string",
timestampFormat: "string",
trimSpace: "string",
},
orc: {
nullIfs: ["string"],
replaceInvalidCharacters: "string",
trimSpace: "string",
},
parquet: {
binaryAsText: "string",
compression: "string",
nullIfs: ["string"],
replaceInvalidCharacters: "string",
trimSpace: "string",
useLogicalType: "string",
useVectorizedScanner: "string",
},
xml: {
compression: "string",
disableAutoConvert: "string",
ignoreUtf8Errors: "string",
preserveSpace: "string",
replaceInvalidCharacters: "string",
skipByteOrderMark: "string",
stripOuterElement: "string",
},
},
name: "string",
});
type: snowflake:StageExternalGcs
properties:
comment: string
database: string
directory:
autoRefresh: string
enable: false
notificationIntegration: string
refreshOnCreate: string
encryption:
gcsSseKms:
kmsKeyId: string
none: {}
fileFormat:
avro:
compression: string
nullIfs:
- string
replaceInvalidCharacters: string
trimSpace: string
csv:
binaryFormat: string
compression: string
dateFormat: string
emptyFieldAsNull: string
encoding: string
errorOnColumnCountMismatch: string
escape: string
escapeUnenclosedField: string
fieldDelimiter: string
fieldOptionallyEnclosedBy: string
fileExtension: string
multiLine: string
nullIfs:
- string
parseHeader: string
recordDelimiter: string
replaceInvalidCharacters: string
skipBlankLines: string
skipByteOrderMark: string
skipHeader: 0
timeFormat: string
timestampFormat: string
trimSpace: string
formatName: string
json:
allowDuplicate: string
binaryFormat: string
compression: string
dateFormat: string
enableOctal: string
fileExtension: string
ignoreUtf8Errors: string
multiLine: string
nullIfs:
- string
replaceInvalidCharacters: string
skipByteOrderMark: string
stripNullValues: string
stripOuterArray: string
timeFormat: string
timestampFormat: string
trimSpace: string
orc:
nullIfs:
- string
replaceInvalidCharacters: string
trimSpace: string
parquet:
binaryAsText: string
compression: string
nullIfs:
- string
replaceInvalidCharacters: string
trimSpace: string
useLogicalType: string
useVectorizedScanner: string
xml:
compression: string
disableAutoConvert: string
ignoreUtf8Errors: string
preserveSpace: string
replaceInvalidCharacters: string
skipByteOrderMark: string
stripOuterElement: string
name: string
schema: string
storageIntegration: string
url: string
StageExternalGcs 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 StageExternalGcs resource accepts the following input properties:
- Database string
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Schema string
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Storage
Integration string - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Url string
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- Comment string
- Specifies a comment for the stage.
- Directory
Stage
External Gcs Directory - Directory tables store a catalog of staged files in cloud storage.
- Encryption
Stage
External Gcs Encryption - Specifies the encryption settings for the GCS external stage.
- File
Format StageExternal Gcs File Format - Specifies the file format for the stage.
- Name string
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,".
- Database string
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Schema string
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Storage
Integration string - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Url string
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- Comment string
- Specifies a comment for the stage.
- Directory
Stage
External Gcs Directory Args - Directory tables store a catalog of staged files in cloud storage.
- Encryption
Stage
External Gcs Encryption Args - Specifies the encryption settings for the GCS external stage.
- File
Format StageExternal Gcs File Format Args - Specifies the file format for the stage.
- Name string
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,".
- database String
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - schema String
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - storage
Integration String - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - url String
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- comment String
- Specifies a comment for the stage.
- directory
Stage
External Gcs Directory - Directory tables store a catalog of staged files in cloud storage.
- encryption
Stage
External Gcs Encryption - Specifies the encryption settings for the GCS external stage.
- file
Format StageExternal Gcs File Format - Specifies the file format for the stage.
- name String
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,".
- database string
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - schema string
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - storage
Integration string - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - url string
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- comment string
- Specifies a comment for the stage.
- directory
Stage
External Gcs Directory - Directory tables store a catalog of staged files in cloud storage.
- encryption
Stage
External Gcs Encryption - Specifies the encryption settings for the GCS external stage.
- file
Format StageExternal Gcs File Format - Specifies the file format for the stage.
- name string
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,".
- database str
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - schema str
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - storage_
integration str - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - url str
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- comment str
- Specifies a comment for the stage.
- directory
Stage
External Gcs Directory Args - Directory tables store a catalog of staged files in cloud storage.
- encryption
Stage
External Gcs Encryption Args - Specifies the encryption settings for the GCS external stage.
- file_
format StageExternal Gcs File Format Args - Specifies the file format for the stage.
- name str
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,".
- database String
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - schema String
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - storage
Integration String - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - url String
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- comment String
- Specifies a comment for the stage.
- directory Property Map
- Directory tables store a catalog of staged files in cloud storage.
- encryption Property Map
- Specifies the encryption settings for the GCS external stage.
- file
Format Property Map - Specifies the file format for the stage.
- name String
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,".
Outputs
All input properties are implicitly available as output properties. Additionally, the StageExternalGcs resource produces the following output properties:
- Cloud string
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- Describe
Outputs List<StageExternal Gcs Describe Output> - Outputs the result of
DESCRIBE STAGEfor the given stage. - Fully
Qualified stringName - 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
Outputs List<StageExternal Gcs Show Output> - Outputs the result of
SHOW STAGESfor the given stage. - Stage
Type string - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- Cloud string
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- Describe
Outputs []StageExternal Gcs Describe Output - Outputs the result of
DESCRIBE STAGEfor the given stage. - Fully
Qualified stringName - 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
Outputs []StageExternal Gcs Show Output - Outputs the result of
SHOW STAGESfor the given stage. - Stage
Type string - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- cloud String
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- describe
Outputs List<StageExternal Gcs Describe Output> - Outputs the result of
DESCRIBE STAGEfor the given stage. - fully
Qualified StringName - 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
Outputs List<StageExternal Gcs Show Output> - Outputs the result of
SHOW STAGESfor the given stage. - stage
Type String - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- cloud string
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- describe
Outputs StageExternal Gcs Describe Output[] - Outputs the result of
DESCRIBE STAGEfor the given stage. - fully
Qualified stringName - 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
Outputs StageExternal Gcs Show Output[] - Outputs the result of
SHOW STAGESfor the given stage. - stage
Type string - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- cloud str
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- describe_
outputs Sequence[StageExternal Gcs Describe Output] - Outputs the result of
DESCRIBE STAGEfor the given stage. - fully_
qualified_ strname - 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_
outputs Sequence[StageExternal Gcs Show Output] - Outputs the result of
SHOW STAGESfor the given stage. - stage_
type str - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- cloud String
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- describe
Outputs List<Property Map> - Outputs the result of
DESCRIBE STAGEfor the given stage. - fully
Qualified StringName - 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
Outputs List<Property Map> - Outputs the result of
SHOW STAGESfor the given stage. - stage
Type String - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
Look up Existing StageExternalGcs Resource
Get an existing StageExternalGcs 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?: StageExternalGcsState, opts?: CustomResourceOptions): StageExternalGcs@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
cloud: Optional[str] = None,
comment: Optional[str] = None,
database: Optional[str] = None,
describe_outputs: Optional[Sequence[StageExternalGcsDescribeOutputArgs]] = None,
directory: Optional[StageExternalGcsDirectoryArgs] = None,
encryption: Optional[StageExternalGcsEncryptionArgs] = None,
file_format: Optional[StageExternalGcsFileFormatArgs] = None,
fully_qualified_name: Optional[str] = None,
name: Optional[str] = None,
schema: Optional[str] = None,
show_outputs: Optional[Sequence[StageExternalGcsShowOutputArgs]] = None,
stage_type: Optional[str] = None,
storage_integration: Optional[str] = None,
url: Optional[str] = None) -> StageExternalGcsfunc GetStageExternalGcs(ctx *Context, name string, id IDInput, state *StageExternalGcsState, opts ...ResourceOption) (*StageExternalGcs, error)public static StageExternalGcs Get(string name, Input<string> id, StageExternalGcsState? state, CustomResourceOptions? opts = null)public static StageExternalGcs get(String name, Output<String> id, StageExternalGcsState state, CustomResourceOptions options)resources: _: type: snowflake:StageExternalGcs get: id: ${id}- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Cloud string
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- Comment string
- Specifies a comment for the stage.
- Database string
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Describe
Outputs List<StageExternal Gcs Describe Output> - Outputs the result of
DESCRIBE STAGEfor the given stage. - Directory
Stage
External Gcs Directory - Directory tables store a catalog of staged files in cloud storage.
- Encryption
Stage
External Gcs Encryption - Specifies the encryption settings for the GCS external stage.
- File
Format StageExternal Gcs File Format - Specifies the file format for the stage.
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Name string
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Schema string
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Show
Outputs List<StageExternal Gcs Show Output> - Outputs the result of
SHOW STAGESfor the given stage. - Stage
Type string - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- Storage
Integration string - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Url string
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- Cloud string
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- Comment string
- Specifies a comment for the stage.
- Database string
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Describe
Outputs []StageExternal Gcs Describe Output Args - Outputs the result of
DESCRIBE STAGEfor the given stage. - Directory
Stage
External Gcs Directory Args - Directory tables store a catalog of staged files in cloud storage.
- Encryption
Stage
External Gcs Encryption Args - Specifies the encryption settings for the GCS external stage.
- File
Format StageExternal Gcs File Format Args - Specifies the file format for the stage.
- Fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- Name string
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Schema string
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Show
Outputs []StageExternal Gcs Show Output Args - Outputs the result of
SHOW STAGESfor the given stage. - Stage
Type string - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- Storage
Integration string - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Url string
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- cloud String
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- comment String
- Specifies a comment for the stage.
- database String
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - describe
Outputs List<StageExternal Gcs Describe Output> - Outputs the result of
DESCRIBE STAGEfor the given stage. - directory
Stage
External Gcs Directory - Directory tables store a catalog of staged files in cloud storage.
- encryption
Stage
External Gcs Encryption - Specifies the encryption settings for the GCS external stage.
- file
Format StageExternal Gcs File Format - Specifies the file format for the stage.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- name String
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - schema String
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - show
Outputs List<StageExternal Gcs Show Output> - Outputs the result of
SHOW STAGESfor the given stage. - stage
Type String - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- storage
Integration String - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - url String
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- cloud string
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- comment string
- Specifies a comment for the stage.
- database string
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - describe
Outputs StageExternal Gcs Describe Output[] - Outputs the result of
DESCRIBE STAGEfor the given stage. - directory
Stage
External Gcs Directory - Directory tables store a catalog of staged files in cloud storage.
- encryption
Stage
External Gcs Encryption - Specifies the encryption settings for the GCS external stage.
- file
Format StageExternal Gcs File Format - Specifies the file format for the stage.
- fully
Qualified stringName - Fully qualified name of the resource. For more information, see object name resolution.
- name string
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - schema string
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - show
Outputs StageExternal Gcs Show Output[] - Outputs the result of
SHOW STAGESfor the given stage. - stage
Type string - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- storage
Integration string - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - url string
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- cloud str
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- comment str
- Specifies a comment for the stage.
- database str
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - describe_
outputs Sequence[StageExternal Gcs Describe Output Args] - Outputs the result of
DESCRIBE STAGEfor the given stage. - directory
Stage
External Gcs Directory Args - Directory tables store a catalog of staged files in cloud storage.
- encryption
Stage
External Gcs Encryption Args - Specifies the encryption settings for the GCS external stage.
- file_
format StageExternal Gcs File Format Args - Specifies the file format for the stage.
- fully_
qualified_ strname - Fully qualified name of the resource. For more information, see object name resolution.
- name str
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - schema str
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - show_
outputs Sequence[StageExternal Gcs Show Output Args] - Outputs the result of
SHOW STAGESfor the given stage. - stage_
type str - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- storage_
integration str - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - url str
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
- cloud String
- Specifies a cloud provider for the stage. This field is used for checking external changes and recreating the resources if needed.
- comment String
- Specifies a comment for the stage.
- database String
- The database in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - describe
Outputs List<Property Map> - Outputs the result of
DESCRIBE STAGEfor the given stage. - directory Property Map
- Directory tables store a catalog of staged files in cloud storage.
- encryption Property Map
- Specifies the encryption settings for the GCS external stage.
- file
Format Property Map - Specifies the file format for the stage.
- fully
Qualified StringName - Fully qualified name of the resource. For more information, see object name resolution.
- name String
- Specifies the identifier for the stage; must be unique for the database and schema in which the stage is created. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - schema String
- The schema in which to create the stage. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - show
Outputs List<Property Map> - Outputs the result of
SHOW STAGESfor the given stage. - stage
Type String - Specifies a type for the stage. This field is used for checking external changes and recreating the resources if needed.
- storage
Integration String - Specifies the name of the storage integration used to delegate authentication responsibility to a Snowflake identity. GCS stages require a storage integration. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - url String
- Specifies the URL for the GCS bucket (e.g., 'gcs://bucket/path/').
Supporting Types
StageExternalGcsDescribeOutput, StageExternalGcsDescribeOutputArgs
StageExternalGcsDescribeOutputDirectoryTable, StageExternalGcsDescribeOutputDirectoryTableArgs
- Auto
Refresh bool - Enable bool
- Auto
Refresh bool - Enable bool
- auto
Refresh Boolean - enable Boolean
- auto
Refresh boolean - enable boolean
- auto_
refresh bool - enable bool
- auto
Refresh Boolean - enable Boolean
StageExternalGcsDescribeOutputFileFormat, StageExternalGcsDescribeOutputFileFormatArgs
- Avros
List<Stage
External Gcs Describe Output File Format Avro> - Csvs
List<Stage
External Gcs Describe Output File Format Csv> - Format
Name string - Jsons
List<Stage
External Gcs Describe Output File Format Json> - Orcs
List<Stage
External Gcs Describe Output File Format Orc> - Parquets
List<Stage
External Gcs Describe Output File Format Parquet> - Xmls
List<Stage
External Gcs Describe Output File Format Xml>
- Avros
[]Stage
External Gcs Describe Output File Format Avro - Csvs
[]Stage
External Gcs Describe Output File Format Csv - Format
Name string - Jsons
[]Stage
External Gcs Describe Output File Format Json - Orcs
[]Stage
External Gcs Describe Output File Format Orc - Parquets
[]Stage
External Gcs Describe Output File Format Parquet - Xmls
[]Stage
External Gcs Describe Output File Format Xml
- avros
List<Stage
External Gcs Describe Output File Format Avro> - csvs
List<Stage
External Gcs Describe Output File Format Csv> - format
Name String - jsons
List<Stage
External Gcs Describe Output File Format Json> - orcs
List<Stage
External Gcs Describe Output File Format Orc> - parquets
List<Stage
External Gcs Describe Output File Format Parquet> - xmls
List<Stage
External Gcs Describe Output File Format Xml>
- avros
Stage
External Gcs Describe Output File Format Avro[] - csvs
Stage
External Gcs Describe Output File Format Csv[] - format
Name string - jsons
Stage
External Gcs Describe Output File Format Json[] - orcs
Stage
External Gcs Describe Output File Format Orc[] - parquets
Stage
External Gcs Describe Output File Format Parquet[] - xmls
Stage
External Gcs Describe Output File Format Xml[]
- avros
Sequence[Stage
External Gcs Describe Output File Format Avro] - csvs
Sequence[Stage
External Gcs Describe Output File Format Csv] - format_
name str - jsons
Sequence[Stage
External Gcs Describe Output File Format Json] - orcs
Sequence[Stage
External Gcs Describe Output File Format Orc] - parquets
Sequence[Stage
External Gcs Describe Output File Format Parquet] - xmls
Sequence[Stage
External Gcs Describe Output File Format Xml]
StageExternalGcsDescribeOutputFileFormatAvro, StageExternalGcsDescribeOutputFileFormatAvroArgs
- Compression string
- Null
Ifs List<string> - Replace
Invalid boolCharacters - Trim
Space bool - Type string
- Compression string
- Null
Ifs []string - Replace
Invalid boolCharacters - Trim
Space bool - Type string
- compression String
- null
Ifs List<String> - replace
Invalid BooleanCharacters - trim
Space Boolean - type String
- compression string
- null
Ifs string[] - replace
Invalid booleanCharacters - trim
Space boolean - type string
- compression str
- null_
ifs Sequence[str] - replace_
invalid_ boolcharacters - trim_
space bool - type str
- compression String
- null
Ifs List<String> - replace
Invalid BooleanCharacters - trim
Space Boolean - type String
StageExternalGcsDescribeOutputFileFormatCsv, StageExternalGcsDescribeOutputFileFormatCsvArgs
- Binary
Format string - Compression string
- Date
Format string - Empty
Field boolAs Null - Encoding string
- Error
On boolColumn Count Mismatch - Escape string
- Escape
Unenclosed stringField - Field
Delimiter string - Field
Optionally stringEnclosed By - File
Extension string - Multi
Line bool - Null
Ifs List<string> - Parse
Header bool - Record
Delimiter string - Replace
Invalid boolCharacters - Skip
Blank boolLines - Skip
Byte boolOrder Mark - Skip
Header int - Time
Format string - Timestamp
Format string - Trim
Space bool - Type string
- Validate
Utf8 bool
- Binary
Format string - Compression string
- Date
Format string - Empty
Field boolAs Null - Encoding string
- Error
On boolColumn Count Mismatch - Escape string
- Escape
Unenclosed stringField - Field
Delimiter string - Field
Optionally stringEnclosed By - File
Extension string - Multi
Line bool - Null
Ifs []string - Parse
Header bool - Record
Delimiter string - Replace
Invalid boolCharacters - Skip
Blank boolLines - Skip
Byte boolOrder Mark - Skip
Header int - Time
Format string - Timestamp
Format string - Trim
Space bool - Type string
- Validate
Utf8 bool
- binary
Format String - compression String
- date
Format String - empty
Field BooleanAs Null - encoding String
- error
On BooleanColumn Count Mismatch - escape String
- escape
Unenclosed StringField - field
Delimiter String - field
Optionally StringEnclosed By - file
Extension String - multi
Line Boolean - null
Ifs List<String> - parse
Header Boolean - record
Delimiter String - replace
Invalid BooleanCharacters - skip
Blank BooleanLines - skip
Byte BooleanOrder Mark - skip
Header Integer - time
Format String - timestamp
Format String - trim
Space Boolean - type String
- validate
Utf8 Boolean
- binary
Format string - compression string
- date
Format string - empty
Field booleanAs Null - encoding string
- error
On booleanColumn Count Mismatch - escape string
- escape
Unenclosed stringField - field
Delimiter string - field
Optionally stringEnclosed By - file
Extension string - multi
Line boolean - null
Ifs string[] - parse
Header boolean - record
Delimiter string - replace
Invalid booleanCharacters - skip
Blank booleanLines - skip
Byte booleanOrder Mark - skip
Header number - time
Format string - timestamp
Format string - trim
Space boolean - type string
- validate
Utf8 boolean
- binary_
format str - compression str
- date_
format str - empty_
field_ boolas_ null - encoding str
- error_
on_ boolcolumn_ count_ mismatch - escape str
- escape_
unenclosed_ strfield - field_
delimiter str - field_
optionally_ strenclosed_ by - file_
extension str - multi_
line bool - null_
ifs Sequence[str] - parse_
header bool - record_
delimiter str - replace_
invalid_ boolcharacters - skip_
blank_ boollines - skip_
byte_ boolorder_ mark - skip_
header int - time_
format str - timestamp_
format str - trim_
space bool - type str
- validate_
utf8 bool
- binary
Format String - compression String
- date
Format String - empty
Field BooleanAs Null - encoding String
- error
On BooleanColumn Count Mismatch - escape String
- escape
Unenclosed StringField - field
Delimiter String - field
Optionally StringEnclosed By - file
Extension String - multi
Line Boolean - null
Ifs List<String> - parse
Header Boolean - record
Delimiter String - replace
Invalid BooleanCharacters - skip
Blank BooleanLines - skip
Byte BooleanOrder Mark - skip
Header Number - time
Format String - timestamp
Format String - trim
Space Boolean - type String
- validate
Utf8 Boolean
StageExternalGcsDescribeOutputFileFormatJson, StageExternalGcsDescribeOutputFileFormatJsonArgs
- Allow
Duplicate bool - Binary
Format string - Compression string
- Date
Format string - Enable
Octal bool - File
Extension string - Ignore
Utf8Errors bool - Multi
Line bool - Null
Ifs List<string> - Replace
Invalid boolCharacters - Skip
Byte boolOrder Mark - Strip
Null boolValues - Strip
Outer boolArray - Time
Format string - Timestamp
Format string - Trim
Space bool - Type string
- Allow
Duplicate bool - Binary
Format string - Compression string
- Date
Format string - Enable
Octal bool - File
Extension string - Ignore
Utf8Errors bool - Multi
Line bool - Null
Ifs []string - Replace
Invalid boolCharacters - Skip
Byte boolOrder Mark - Strip
Null boolValues - Strip
Outer boolArray - Time
Format string - Timestamp
Format string - Trim
Space bool - Type string
- allow
Duplicate Boolean - binary
Format String - compression String
- date
Format String - enable
Octal Boolean - file
Extension String - ignore
Utf8Errors Boolean - multi
Line Boolean - null
Ifs List<String> - replace
Invalid BooleanCharacters - skip
Byte BooleanOrder Mark - strip
Null BooleanValues - strip
Outer BooleanArray - time
Format String - timestamp
Format String - trim
Space Boolean - type String
- allow
Duplicate boolean - binary
Format string - compression string
- date
Format string - enable
Octal boolean - file
Extension string - ignore
Utf8Errors boolean - multi
Line boolean - null
Ifs string[] - replace
Invalid booleanCharacters - skip
Byte booleanOrder Mark - strip
Null booleanValues - strip
Outer booleanArray - time
Format string - timestamp
Format string - trim
Space boolean - type string
- allow_
duplicate bool - binary_
format str - compression str
- date_
format str - enable_
octal bool - file_
extension str - ignore_
utf8_ boolerrors - multi_
line bool - null_
ifs Sequence[str] - replace_
invalid_ boolcharacters - skip_
byte_ boolorder_ mark - strip_
null_ boolvalues - strip_
outer_ boolarray - time_
format str - timestamp_
format str - trim_
space bool - type str
- allow
Duplicate Boolean - binary
Format String - compression String
- date
Format String - enable
Octal Boolean - file
Extension String - ignore
Utf8Errors Boolean - multi
Line Boolean - null
Ifs List<String> - replace
Invalid BooleanCharacters - skip
Byte BooleanOrder Mark - strip
Null BooleanValues - strip
Outer BooleanArray - time
Format String - timestamp
Format String - trim
Space Boolean - type String
StageExternalGcsDescribeOutputFileFormatOrc, StageExternalGcsDescribeOutputFileFormatOrcArgs
- Null
Ifs List<string> - Replace
Invalid boolCharacters - Trim
Space bool - Type string
- Null
Ifs []string - Replace
Invalid boolCharacters - Trim
Space bool - Type string
- null
Ifs List<String> - replace
Invalid BooleanCharacters - trim
Space Boolean - type String
- null
Ifs string[] - replace
Invalid booleanCharacters - trim
Space boolean - type string
- null_
ifs Sequence[str] - replace_
invalid_ boolcharacters - trim_
space bool - type str
- null
Ifs List<String> - replace
Invalid BooleanCharacters - trim
Space Boolean - type String
StageExternalGcsDescribeOutputFileFormatParquet, StageExternalGcsDescribeOutputFileFormatParquetArgs
- Binary
As boolText - Compression string
- Null
Ifs List<string> - Replace
Invalid boolCharacters - Trim
Space bool - Type string
- Use
Logical boolType - Use
Vectorized boolScanner
- Binary
As boolText - Compression string
- Null
Ifs []string - Replace
Invalid boolCharacters - Trim
Space bool - Type string
- Use
Logical boolType - Use
Vectorized boolScanner
- binary
As BooleanText - compression String
- null
Ifs List<String> - replace
Invalid BooleanCharacters - trim
Space Boolean - type String
- use
Logical BooleanType - use
Vectorized BooleanScanner
- binary
As booleanText - compression string
- null
Ifs string[] - replace
Invalid booleanCharacters - trim
Space boolean - type string
- use
Logical booleanType - use
Vectorized booleanScanner
- binary_
as_ booltext - compression str
- null_
ifs Sequence[str] - replace_
invalid_ boolcharacters - trim_
space bool - type str
- use_
logical_ booltype - use_
vectorized_ boolscanner
- binary
As BooleanText - compression String
- null
Ifs List<String> - replace
Invalid BooleanCharacters - trim
Space Boolean - type String
- use
Logical BooleanType - use
Vectorized BooleanScanner
StageExternalGcsDescribeOutputFileFormatXml, StageExternalGcsDescribeOutputFileFormatXmlArgs
- Compression string
- Disable
Auto boolConvert - Ignore
Utf8Errors bool - Preserve
Space bool - Replace
Invalid boolCharacters - Skip
Byte boolOrder Mark - Strip
Outer boolElement - Type string
- Compression string
- Disable
Auto boolConvert - Ignore
Utf8Errors bool - Preserve
Space bool - Replace
Invalid boolCharacters - Skip
Byte boolOrder Mark - Strip
Outer boolElement - Type string
- compression String
- disable
Auto BooleanConvert - ignore
Utf8Errors Boolean - preserve
Space Boolean - replace
Invalid BooleanCharacters - skip
Byte BooleanOrder Mark - strip
Outer BooleanElement - type String
- compression string
- disable
Auto booleanConvert - ignore
Utf8Errors boolean - preserve
Space boolean - replace
Invalid booleanCharacters - skip
Byte booleanOrder Mark - strip
Outer booleanElement - type string
- compression str
- disable_
auto_ boolconvert - ignore_
utf8_ boolerrors - preserve_
space bool - replace_
invalid_ boolcharacters - skip_
byte_ boolorder_ mark - strip_
outer_ boolelement - type str
- compression String
- disable
Auto BooleanConvert - ignore
Utf8Errors Boolean - preserve
Space Boolean - replace
Invalid BooleanCharacters - skip
Byte BooleanOrder Mark - strip
Outer BooleanElement - type String
StageExternalGcsDirectory, StageExternalGcsDirectoryArgs
- Enable bool
- Specifies whether to enable a directory table on the external stage.
- Auto
Refresh string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether Snowflake should enable triggering automatic refreshes of the directory table metadata. - Notification
Integration string - Specifies the name of the notification integration used to automatically refresh the directory table metadata. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Refresh
On stringCreate - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether to automatically refresh the directory table metadata once, immediately after the stage is created.This field is used only when creating the object. Changes on this field are ignored after creation.
- Enable bool
- Specifies whether to enable a directory table on the external stage.
- Auto
Refresh string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether Snowflake should enable triggering automatic refreshes of the directory table metadata. - Notification
Integration string - Specifies the name of the notification integration used to automatically refresh the directory table metadata. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - Refresh
On stringCreate - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether to automatically refresh the directory table metadata once, immediately after the stage is created.This field is used only when creating the object. Changes on this field are ignored after creation.
- enable Boolean
- Specifies whether to enable a directory table on the external stage.
- auto
Refresh String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether Snowflake should enable triggering automatic refreshes of the directory table metadata. - notification
Integration String - Specifies the name of the notification integration used to automatically refresh the directory table metadata. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - refresh
On StringCreate - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether to automatically refresh the directory table metadata once, immediately after the stage is created.This field is used only when creating the object. Changes on this field are ignored after creation.
- enable boolean
- Specifies whether to enable a directory table on the external stage.
- auto
Refresh string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether Snowflake should enable triggering automatic refreshes of the directory table metadata. - notification
Integration string - Specifies the name of the notification integration used to automatically refresh the directory table metadata. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - refresh
On stringCreate - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether to automatically refresh the directory table metadata once, immediately after the stage is created.This field is used only when creating the object. Changes on this field are ignored after creation.
- enable bool
- Specifies whether to enable a directory table on the external stage.
- auto_
refresh str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether Snowflake should enable triggering automatic refreshes of the directory table metadata. - notification_
integration str - Specifies the name of the notification integration used to automatically refresh the directory table metadata. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - refresh_
on_ strcreate - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether to automatically refresh the directory table metadata once, immediately after the stage is created.This field is used only when creating the object. Changes on this field are ignored after creation.
- enable Boolean
- Specifies whether to enable a directory table on the external stage.
- auto
Refresh String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether Snowflake should enable triggering automatic refreshes of the directory table metadata. - notification
Integration String - Specifies the name of the notification integration used to automatically refresh the directory table metadata. Due to technical limitations (read more here), avoid using the following characters:
|,.,". - refresh
On StringCreate - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Specifies whether to automatically refresh the directory table metadata once, immediately after the stage is created.This field is used only when creating the object. Changes on this field are ignored after creation.
StageExternalGcsEncryption, StageExternalGcsEncryptionArgs
- Gcs
Sse StageKms External Gcs Encryption Gcs Sse Kms - GCS server-side encryption using a KMS key.
- None
Stage
External Gcs Encryption None - No encryption.
- Gcs
Sse StageKms External Gcs Encryption Gcs Sse Kms - GCS server-side encryption using a KMS key.
- None
Stage
External Gcs Encryption None - No encryption.
- gcs
Sse StageKms External Gcs Encryption Gcs Sse Kms - GCS server-side encryption using a KMS key.
- none
Stage
External Gcs Encryption None - No encryption.
- gcs
Sse StageKms External Gcs Encryption Gcs Sse Kms - GCS server-side encryption using a KMS key.
- none
Stage
External Gcs Encryption None - No encryption.
- gcs_
sse_ Stagekms External Gcs Encryption Gcs Sse Kms - GCS server-side encryption using a KMS key.
- none
Stage
External Gcs Encryption None - No encryption.
- gcs
Sse Property MapKms - GCS server-side encryption using a KMS key.
- none Property Map
- No encryption.
StageExternalGcsEncryptionGcsSseKms, StageExternalGcsEncryptionGcsSseKmsArgs
- Kms
Key stringId - Specifies the KMS-managed key ID.
- Kms
Key stringId - Specifies the KMS-managed key ID.
- kms
Key StringId - Specifies the KMS-managed key ID.
- kms
Key stringId - Specifies the KMS-managed key ID.
- kms_
key_ strid - Specifies the KMS-managed key ID.
- kms
Key StringId - Specifies the KMS-managed key ID.
StageExternalGcsFileFormat, StageExternalGcsFileFormatArgs
- Avro
Stage
External Gcs File Format Avro - AVRO file format options.
- Csv
Stage
External Gcs File Format Csv - CSV file format options.
- Format
Name string - Fully qualified name of the file format (e.g., 'database.schema.format_name').
- Json
Stage
External Gcs File Format Json - JSON file format options.
- Orc
Stage
External Gcs File Format Orc - ORC file format options.
- Parquet
Stage
External Gcs File Format Parquet - Parquet file format options.
- Xml
Stage
External Gcs File Format Xml - XML file format options.
- Avro
Stage
External Gcs File Format Avro - AVRO file format options.
- Csv
Stage
External Gcs File Format Csv - CSV file format options.
- Format
Name string - Fully qualified name of the file format (e.g., 'database.schema.format_name').
- Json
Stage
External Gcs File Format Json - JSON file format options.
- Orc
Stage
External Gcs File Format Orc - ORC file format options.
- Parquet
Stage
External Gcs File Format Parquet - Parquet file format options.
- Xml
Stage
External Gcs File Format Xml - XML file format options.
- avro
Stage
External Gcs File Format Avro - AVRO file format options.
- csv
Stage
External Gcs File Format Csv - CSV file format options.
- format
Name String - Fully qualified name of the file format (e.g., 'database.schema.format_name').
- json
Stage
External Gcs File Format Json - JSON file format options.
- orc
Stage
External Gcs File Format Orc - ORC file format options.
- parquet
Stage
External Gcs File Format Parquet - Parquet file format options.
- xml
Stage
External Gcs File Format Xml - XML file format options.
- avro
Stage
External Gcs File Format Avro - AVRO file format options.
- csv
Stage
External Gcs File Format Csv - CSV file format options.
- format
Name string - Fully qualified name of the file format (e.g., 'database.schema.format_name').
- json
Stage
External Gcs File Format Json - JSON file format options.
- orc
Stage
External Gcs File Format Orc - ORC file format options.
- parquet
Stage
External Gcs File Format Parquet - Parquet file format options.
- xml
Stage
External Gcs File Format Xml - XML file format options.
- avro
Stage
External Gcs File Format Avro - AVRO file format options.
- csv
Stage
External Gcs File Format Csv - CSV file format options.
- format_
name str - Fully qualified name of the file format (e.g., 'database.schema.format_name').
- json
Stage
External Gcs File Format Json - JSON file format options.
- orc
Stage
External Gcs File Format Orc - ORC file format options.
- parquet
Stage
External Gcs File Format Parquet - Parquet file format options.
- xml
Stage
External Gcs File Format Xml - XML file format options.
- avro Property Map
- AVRO file format options.
- csv Property Map
- CSV file format options.
- format
Name String - Fully qualified name of the file format (e.g., 'database.schema.format_name').
- json Property Map
- JSON file format options.
- orc Property Map
- ORC file format options.
- parquet Property Map
- Parquet file format options.
- xml Property Map
- XML file format options.
StageExternalGcsFileFormatAvro, StageExternalGcsFileFormatAvroArgs
- Compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - Null
Ifs List<string> - String used to convert to and from SQL NULL.
- Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - Null
Ifs []string - String used to convert to and from SQL NULL.
- Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- compression String
- Specifies the compression format. Valid values:
AUTO|GZIP|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - null
Ifs List<String> - String used to convert to and from SQL NULL.
- replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - null
Ifs string[] - String used to convert to and from SQL NULL.
- replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- compression str
- Specifies the compression format. Valid values:
AUTO|GZIP|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - null_
ifs Sequence[str] - String used to convert to and from SQL NULL.
- replace_
invalid_ strcharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim_
space str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- compression String
- Specifies the compression format. Valid values:
AUTO|GZIP|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - null
Ifs List<String> - String used to convert to and from SQL NULL.
- replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
StageExternalGcsFileFormatCsv, StageExternalGcsFileFormatCsvArgs
- Binary
Format string - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - Compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - Date
Format string - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Empty
Field stringAs Null - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to insert SQL NULL for empty fields in an input file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Encoding string
- Specifies the character set of the source data when loading data into a table. Valid values:
BIG5|EUCJP|EUCKR|GB18030|IBM420|IBM424|ISO2022CN|ISO2022JP|ISO2022KR|ISO88591|ISO88592|ISO88595|ISO88596|ISO88597|ISO88598|ISO88599|ISO885915|KOI8R|SHIFTJIS|UTF8|UTF16|UTF16BE|UTF16LE|UTF32|UTF32BE|UTF32LE|WINDOWS1250|WINDOWS1251|WINDOWS1252|WINDOWS1253|WINDOWS1254|WINDOWS1255|WINDOWS1256. - Error
On stringColumn Count Mismatch - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to generate a parsing error if the number of delimited columns in an input file does not match the number of columns in the corresponding table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Escape string
- Single character string used as the escape character for field values. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - Escape
Unenclosed stringField - Single character string used as the escape character for unenclosed field values only. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - Field
Delimiter string - One or more singlebyte or multibyte characters that separate fields in an input file. Use
NONEto specify no delimiter. - Field
Optionally stringEnclosed By - Character used to enclose strings. Use
NONEto specify no enclosure character. - File
Extension string - Specifies the extension for files unloaded to a stage.
- Multi
Line string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to parse CSV files containing multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Null
Ifs List<string> - String used to convert to and from SQL NULL.
- Parse
Header string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use the first row headers in the data files to determine column names. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Record
Delimiter string - One or more singlebyte or multibyte characters that separate records in an input file. Use
NONEto specify no delimiter. - Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Blank stringLines - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies to skip any blank lines encountered in the data files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Header int - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
-1)) Number of lines at the start of the file to skip. - Time
Format string - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Timestamp
Format string - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Binary
Format string - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - Compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - Date
Format string - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Empty
Field stringAs Null - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to insert SQL NULL for empty fields in an input file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Encoding string
- Specifies the character set of the source data when loading data into a table. Valid values:
BIG5|EUCJP|EUCKR|GB18030|IBM420|IBM424|ISO2022CN|ISO2022JP|ISO2022KR|ISO88591|ISO88592|ISO88595|ISO88596|ISO88597|ISO88598|ISO88599|ISO885915|KOI8R|SHIFTJIS|UTF8|UTF16|UTF16BE|UTF16LE|UTF32|UTF32BE|UTF32LE|WINDOWS1250|WINDOWS1251|WINDOWS1252|WINDOWS1253|WINDOWS1254|WINDOWS1255|WINDOWS1256. - Error
On stringColumn Count Mismatch - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to generate a parsing error if the number of delimited columns in an input file does not match the number of columns in the corresponding table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Escape string
- Single character string used as the escape character for field values. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - Escape
Unenclosed stringField - Single character string used as the escape character for unenclosed field values only. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - Field
Delimiter string - One or more singlebyte or multibyte characters that separate fields in an input file. Use
NONEto specify no delimiter. - Field
Optionally stringEnclosed By - Character used to enclose strings. Use
NONEto specify no enclosure character. - File
Extension string - Specifies the extension for files unloaded to a stage.
- Multi
Line string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to parse CSV files containing multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Null
Ifs []string - String used to convert to and from SQL NULL.
- Parse
Header string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use the first row headers in the data files to determine column names. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Record
Delimiter string - One or more singlebyte or multibyte characters that separate records in an input file. Use
NONEto specify no delimiter. - Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Blank stringLines - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies to skip any blank lines encountered in the data files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Header int - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
-1)) Number of lines at the start of the file to skip. - Time
Format string - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Timestamp
Format string - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- binary
Format String - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - compression String
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - date
Format String - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - empty
Field StringAs Null - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to insert SQL NULL for empty fields in an input file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - encoding String
- Specifies the character set of the source data when loading data into a table. Valid values:
BIG5|EUCJP|EUCKR|GB18030|IBM420|IBM424|ISO2022CN|ISO2022JP|ISO2022KR|ISO88591|ISO88592|ISO88595|ISO88596|ISO88597|ISO88598|ISO88599|ISO885915|KOI8R|SHIFTJIS|UTF8|UTF16|UTF16BE|UTF16LE|UTF32|UTF32BE|UTF32LE|WINDOWS1250|WINDOWS1251|WINDOWS1252|WINDOWS1253|WINDOWS1254|WINDOWS1255|WINDOWS1256. - error
On StringColumn Count Mismatch - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to generate a parsing error if the number of delimited columns in an input file does not match the number of columns in the corresponding table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - escape String
- Single character string used as the escape character for field values. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - escape
Unenclosed StringField - Single character string used as the escape character for unenclosed field values only. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - field
Delimiter String - One or more singlebyte or multibyte characters that separate fields in an input file. Use
NONEto specify no delimiter. - field
Optionally StringEnclosed By - Character used to enclose strings. Use
NONEto specify no enclosure character. - file
Extension String - Specifies the extension for files unloaded to a stage.
- multi
Line String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to parse CSV files containing multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - null
Ifs List<String> - String used to convert to and from SQL NULL.
- parse
Header String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use the first row headers in the data files to determine column names. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - record
Delimiter String - One or more singlebyte or multibyte characters that separate records in an input file. Use
NONEto specify no delimiter. - replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Blank StringLines - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies to skip any blank lines encountered in the data files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte StringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Header Integer - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
-1)) Number of lines at the start of the file to skip. - time
Format String - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - timestamp
Format String - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- binary
Format string - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - date
Format string - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - empty
Field stringAs Null - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to insert SQL NULL for empty fields in an input file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - encoding string
- Specifies the character set of the source data when loading data into a table. Valid values:
BIG5|EUCJP|EUCKR|GB18030|IBM420|IBM424|ISO2022CN|ISO2022JP|ISO2022KR|ISO88591|ISO88592|ISO88595|ISO88596|ISO88597|ISO88598|ISO88599|ISO885915|KOI8R|SHIFTJIS|UTF8|UTF16|UTF16BE|UTF16LE|UTF32|UTF32BE|UTF32LE|WINDOWS1250|WINDOWS1251|WINDOWS1252|WINDOWS1253|WINDOWS1254|WINDOWS1255|WINDOWS1256. - error
On stringColumn Count Mismatch - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to generate a parsing error if the number of delimited columns in an input file does not match the number of columns in the corresponding table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - escape string
- Single character string used as the escape character for field values. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - escape
Unenclosed stringField - Single character string used as the escape character for unenclosed field values only. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - field
Delimiter string - One or more singlebyte or multibyte characters that separate fields in an input file. Use
NONEto specify no delimiter. - field
Optionally stringEnclosed By - Character used to enclose strings. Use
NONEto specify no enclosure character. - file
Extension string - Specifies the extension for files unloaded to a stage.
- multi
Line string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to parse CSV files containing multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - null
Ifs string[] - String used to convert to and from SQL NULL.
- parse
Header string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use the first row headers in the data files to determine column names. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - record
Delimiter string - One or more singlebyte or multibyte characters that separate records in an input file. Use
NONEto specify no delimiter. - replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Blank stringLines - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies to skip any blank lines encountered in the data files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Header number - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
-1)) Number of lines at the start of the file to skip. - time
Format string - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - timestamp
Format string - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- binary_
format str - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - compression str
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - date_
format str - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - empty_
field_ stras_ null - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to insert SQL NULL for empty fields in an input file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - encoding str
- Specifies the character set of the source data when loading data into a table. Valid values:
BIG5|EUCJP|EUCKR|GB18030|IBM420|IBM424|ISO2022CN|ISO2022JP|ISO2022KR|ISO88591|ISO88592|ISO88595|ISO88596|ISO88597|ISO88598|ISO88599|ISO885915|KOI8R|SHIFTJIS|UTF8|UTF16|UTF16BE|UTF16LE|UTF32|UTF32BE|UTF32LE|WINDOWS1250|WINDOWS1251|WINDOWS1252|WINDOWS1253|WINDOWS1254|WINDOWS1255|WINDOWS1256. - error_
on_ strcolumn_ count_ mismatch - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to generate a parsing error if the number of delimited columns in an input file does not match the number of columns in the corresponding table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - escape str
- Single character string used as the escape character for field values. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - escape_
unenclosed_ strfield - Single character string used as the escape character for unenclosed field values only. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - field_
delimiter str - One or more singlebyte or multibyte characters that separate fields in an input file. Use
NONEto specify no delimiter. - field_
optionally_ strenclosed_ by - Character used to enclose strings. Use
NONEto specify no enclosure character. - file_
extension str - Specifies the extension for files unloaded to a stage.
- multi_
line str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to parse CSV files containing multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - null_
ifs Sequence[str] - String used to convert to and from SQL NULL.
- parse_
header str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use the first row headers in the data files to determine column names. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - record_
delimiter str - One or more singlebyte or multibyte characters that separate records in an input file. Use
NONEto specify no delimiter. - replace_
invalid_ strcharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip_
blank_ strlines - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies to skip any blank lines encountered in the data files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip_
byte_ strorder_ mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip_
header int - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
-1)) Number of lines at the start of the file to skip. - time_
format str - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - timestamp_
format str - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - trim_
space str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- binary
Format String - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - compression String
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - date
Format String - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - empty
Field StringAs Null - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to insert SQL NULL for empty fields in an input file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - encoding String
- Specifies the character set of the source data when loading data into a table. Valid values:
BIG5|EUCJP|EUCKR|GB18030|IBM420|IBM424|ISO2022CN|ISO2022JP|ISO2022KR|ISO88591|ISO88592|ISO88595|ISO88596|ISO88597|ISO88598|ISO88599|ISO885915|KOI8R|SHIFTJIS|UTF8|UTF16|UTF16BE|UTF16LE|UTF32|UTF32BE|UTF32LE|WINDOWS1250|WINDOWS1251|WINDOWS1252|WINDOWS1253|WINDOWS1254|WINDOWS1255|WINDOWS1256. - error
On StringColumn Count Mismatch - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to generate a parsing error if the number of delimited columns in an input file does not match the number of columns in the corresponding table. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - escape String
- Single character string used as the escape character for field values. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - escape
Unenclosed StringField - Single character string used as the escape character for unenclosed field values only. Use
NONEto specify no escape character. NOTE: This value may be not imported properly from Snowflake. Snowflake returns escaped values. - field
Delimiter String - One or more singlebyte or multibyte characters that separate fields in an input file. Use
NONEto specify no delimiter. - field
Optionally StringEnclosed By - Character used to enclose strings. Use
NONEto specify no enclosure character. - file
Extension String - Specifies the extension for files unloaded to a stage.
- multi
Line String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to parse CSV files containing multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - null
Ifs List<String> - String used to convert to and from SQL NULL.
- parse
Header String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use the first row headers in the data files to determine column names. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - record
Delimiter String - One or more singlebyte or multibyte characters that separate records in an input file. Use
NONEto specify no delimiter. - replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Blank StringLines - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies to skip any blank lines encountered in the data files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte StringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Header Number - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
-1)) Number of lines at the start of the file to skip. - time
Format String - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - timestamp
Format String - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
StageExternalGcsFileFormatJson, StageExternalGcsFileFormatJsonArgs
- Allow
Duplicate string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow duplicate object field names (only the last one will be preserved). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Binary
Format string - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - Compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - Date
Format string - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Enable
Octal string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that enables parsing of octal numbers. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - File
Extension string - Specifies the extension for files unloaded to a stage.
- Ignore
Utf8Errors string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Multi
Line string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Null
Ifs List<string> - String used to convert to and from SQL NULL.
- Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Strip
Null stringValues - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove object fields or array elements containing null values. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Strip
Outer stringArray - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove outer brackets. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Time
Format string - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Timestamp
Format string - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Allow
Duplicate string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow duplicate object field names (only the last one will be preserved). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Binary
Format string - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - Compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - Date
Format string - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Enable
Octal string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that enables parsing of octal numbers. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - File
Extension string - Specifies the extension for files unloaded to a stage.
- Ignore
Utf8Errors string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Multi
Line string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Null
Ifs []string - String used to convert to and from SQL NULL.
- Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Strip
Null stringValues - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove object fields or array elements containing null values. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Strip
Outer stringArray - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove outer brackets. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Time
Format string - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Timestamp
Format string - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- allow
Duplicate String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow duplicate object field names (only the last one will be preserved). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - binary
Format String - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - compression String
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - date
Format String - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - enable
Octal String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that enables parsing of octal numbers. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - file
Extension String - Specifies the extension for files unloaded to a stage.
- ignore
Utf8Errors String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - multi
Line String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - null
Ifs List<String> - String used to convert to and from SQL NULL.
- replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte StringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Null StringValues - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove object fields or array elements containing null values. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Outer StringArray - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove outer brackets. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - time
Format String - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - timestamp
Format String - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- allow
Duplicate string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow duplicate object field names (only the last one will be preserved). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - binary
Format string - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - date
Format string - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - enable
Octal string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that enables parsing of octal numbers. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - file
Extension string - Specifies the extension for files unloaded to a stage.
- ignore
Utf8Errors string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - multi
Line string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - null
Ifs string[] - String used to convert to and from SQL NULL.
- replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Null stringValues - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove object fields or array elements containing null values. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Outer stringArray - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove outer brackets. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - time
Format string - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - timestamp
Format string - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- allow_
duplicate str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow duplicate object field names (only the last one will be preserved). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - binary_
format str - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - compression str
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - date_
format str - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - enable_
octal str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that enables parsing of octal numbers. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - file_
extension str - Specifies the extension for files unloaded to a stage.
- ignore_
utf8_ strerrors - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - multi_
line str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - null_
ifs Sequence[str] - String used to convert to and from SQL NULL.
- replace_
invalid_ strcharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip_
byte_ strorder_ mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip_
null_ strvalues - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove object fields or array elements containing null values. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip_
outer_ strarray - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove outer brackets. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - time_
format str - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - timestamp_
format str - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - trim_
space str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- allow
Duplicate String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow duplicate object field names (only the last one will be preserved). Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - binary
Format String - Defines the encoding format for binary input or output. Valid values:
HEX|BASE64|UTF8. - compression String
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - date
Format String - Defines the format of date values in the data files. Use
AUTOto have Snowflake auto-detect the format. - enable
Octal String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that enables parsing of octal numbers. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - file
Extension String - Specifies the extension for files unloaded to a stage.
- ignore
Utf8Errors String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - multi
Line String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to allow multiple records on a single line. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - null
Ifs List<String> - String used to convert to and from SQL NULL.
- replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte StringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Null StringValues - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove object fields or array elements containing null values. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Outer StringArray - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that instructs the JSON parser to remove outer brackets. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - time
Format String - Defines the format of time values in the data files. Use
AUTOto have Snowflake auto-detect the format. - timestamp
Format String - Defines the format of timestamp values in the data files. Use
AUTOto have Snowflake auto-detect the format. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
StageExternalGcsFileFormatOrc, StageExternalGcsFileFormatOrcArgs
- Null
Ifs List<string> - String used to convert to and from SQL NULL.
- Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Null
Ifs []string - String used to convert to and from SQL NULL.
- Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- null
Ifs List<String> - String used to convert to and from SQL NULL.
- replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- null
Ifs string[] - String used to convert to and from SQL NULL.
- replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- null_
ifs Sequence[str] - String used to convert to and from SQL NULL.
- replace_
invalid_ strcharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim_
space str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- null
Ifs List<String> - String used to convert to and from SQL NULL.
- replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
StageExternalGcsFileFormatParquet, StageExternalGcsFileFormatParquetArgs
- Binary
As stringText - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Compression string
- Specifies the compression format. Valid values:
AUTO|LZO|SNAPPY|NONE. - Null
Ifs List<string> - String used to convert to and from SQL NULL.
- Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Use
Logical stringType - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use Parquet logical types when loading data. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Use
Vectorized stringScanner - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use a vectorized scanner for loading Parquet files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Binary
As stringText - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Compression string
- Specifies the compression format. Valid values:
AUTO|LZO|SNAPPY|NONE. - Null
Ifs []string - String used to convert to and from SQL NULL.
- Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Use
Logical stringType - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use Parquet logical types when loading data. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Use
Vectorized stringScanner - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use a vectorized scanner for loading Parquet files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- binary
As StringText - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - compression String
- Specifies the compression format. Valid values:
AUTO|LZO|SNAPPY|NONE. - null
Ifs List<String> - String used to convert to and from SQL NULL.
- replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - use
Logical StringType - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use Parquet logical types when loading data. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - use
Vectorized StringScanner - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use a vectorized scanner for loading Parquet files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- binary
As stringText - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - compression string
- Specifies the compression format. Valid values:
AUTO|LZO|SNAPPY|NONE. - null
Ifs string[] - String used to convert to and from SQL NULL.
- replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - use
Logical stringType - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use Parquet logical types when loading data. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - use
Vectorized stringScanner - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use a vectorized scanner for loading Parquet files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- binary_
as_ strtext - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - compression str
- Specifies the compression format. Valid values:
AUTO|LZO|SNAPPY|NONE. - null_
ifs Sequence[str] - String used to convert to and from SQL NULL.
- replace_
invalid_ strcharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim_
space str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - use_
logical_ strtype - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use Parquet logical types when loading data. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - use_
vectorized_ strscanner - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use a vectorized scanner for loading Parquet files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- binary
As StringText - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to interpret columns with no defined logical data type as UTF-8 text. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - compression String
- Specifies the compression format. Valid values:
AUTO|LZO|SNAPPY|NONE. - null
Ifs List<String> - String used to convert to and from SQL NULL.
- replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - trim
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to remove white space from fields. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - use
Logical StringType - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use Parquet logical types when loading data. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - use
Vectorized StringScanner - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to use a vectorized scanner for loading Parquet files. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
StageExternalGcsFileFormatXml, StageExternalGcsFileFormatXmlArgs
- Compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - Disable
Auto stringConvert - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Ignore
Utf8Errors string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Preserve
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Strip
Outer stringElement - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- Compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - Disable
Auto stringConvert - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Ignore
Utf8Errors string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Preserve
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - Strip
Outer stringElement - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- compression String
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - disable
Auto StringConvert - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - ignore
Utf8Errors String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - preserve
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte StringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Outer StringElement - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- compression string
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - disable
Auto stringConvert - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - ignore
Utf8Errors string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - preserve
Space string - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - replace
Invalid stringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte stringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Outer stringElement - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- compression str
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - disable_
auto_ strconvert - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - ignore_
utf8_ strerrors - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - preserve_
space str - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - replace_
invalid_ strcharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip_
byte_ strorder_ mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip_
outer_ strelement - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
- compression String
- Specifies the compression format. Valid values:
AUTO|GZIP|BZ2|BROTLI|ZSTD|DEFLATE|RAW_DEFLATE|NONE. - disable
Auto StringConvert - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser disables automatic conversion of numeric and Boolean values from text to native representation. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - ignore
Utf8Errors String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether UTF-8 encoding errors produce error conditions. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - preserve
Space String - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser preserves leading and trailing spaces in element content. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - replace
Invalid StringCharacters - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to replace invalid UTF-8 characters with the Unicode replacement character. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - skip
Byte StringOrder Mark - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether to skip the BOM (byte order mark) if present in a data file. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value. - strip
Outer StringElement - (Default: fallback to Snowflake default - uses special value that cannot be set in the configuration manually (
default)) Boolean that specifies whether the XML parser strips out the outer XML element, exposing 2nd level elements as separate documents. Available options are: "true" or "false". When the value is not set in the configuration the provider will put "default" there which means to use the Snowflake default for this value.
StageExternalGcsShowOutput, StageExternalGcsShowOutputArgs
- Cloud string
- Comment string
- Created
On string - Database
Name string - Directory
Enabled bool - Endpoint string
- Has
Credentials bool - Has
Encryption boolKey - Name string
- Owner string
- Owner
Role stringType - Region string
- Schema
Name string - Storage
Integration string - Type string
- Url string
- Cloud string
- Comment string
- Created
On string - Database
Name string - Directory
Enabled bool - Endpoint string
- Has
Credentials bool - Has
Encryption boolKey - Name string
- Owner string
- Owner
Role stringType - Region string
- Schema
Name string - Storage
Integration string - Type string
- Url string
- cloud String
- comment String
- created
On String - database
Name String - directory
Enabled Boolean - endpoint String
- has
Credentials Boolean - has
Encryption BooleanKey - name String
- owner String
- owner
Role StringType - region String
- schema
Name String - storage
Integration String - type String
- url String
- cloud string
- comment string
- created
On string - database
Name string - directory
Enabled boolean - endpoint string
- has
Credentials boolean - has
Encryption booleanKey - name string
- owner string
- owner
Role stringType - region string
- schema
Name string - storage
Integration string - type string
- url string
- cloud str
- comment str
- created_
on str - database_
name str - directory_
enabled bool - endpoint str
- has_
credentials bool - has_
encryption_ boolkey - name str
- owner str
- owner_
role_ strtype - region str
- schema_
name str - storage_
integration str - type str
- url str
- cloud String
- comment String
- created
On String - database
Name String - directory
Enabled Boolean - endpoint String
- has
Credentials Boolean - has
Encryption BooleanKey - name String
- owner String
- owner
Role StringType - region String
- schema
Name String - storage
Integration String - type String
- url String
Import
$ pulumi import snowflake:index/stageExternalGcs:StageExternalGcs example '"<database_name>"."<schema_name>"."<stage_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
snowflakeTerraform Provider.
