Share via

SnowflakeImportCopyCommand Class

Snowflake import command settings.

All required parameters must be populated in order to send to server.

Constructor

SnowflakeImportCopyCommand(*, additional_properties: Dict[str, MutableMapping[str, Any]] | None = None, additional_copy_options: Dict[str, MutableMapping[str, Any]] | None = None, additional_format_options: Dict[str, MutableMapping[str, Any]] | None = None, storage_integration: MutableMapping[str, Any] | None = None, **kwargs: Any)

Keyword-Only Parameters

Name Description
additional_properties
dict[str, <xref:JSON>]

Unmatched properties from the message are deserialized to this collection.

Default value: None
additional_copy_options
dict[str, <xref:JSON>]

Additional copy options directly passed to snowflake Copy Command. Type: key value pairs (value should be string type) (or Expression with resultType object). Example: "additionalCopyOptions": { "DATE_FORMAT": "MM/DD/YYYY", "TIME_FORMAT": "'HH24:MI:SS.FF'" }.

Default value: None
additional_format_options
dict[str, <xref:JSON>]

Additional format options directly passed to snowflake Copy Command. Type: key value pairs (value should be string type) (or Expression with resultType object). Example: "additionalFormatOptions": { "FORCE": "TRUE", "LOAD_UNCERTAIN_FILES": "'FALSE'" }.

Default value: None
storage_integration
<xref:JSON>

The name of the snowflake storage integration to use for the copy operation. Type: string (or Expression with resultType string).

Default value: None

Variables

Name Description
additional_properties
dict[str, <xref:JSON>]

Unmatched properties from the message are deserialized to this collection.
type
str

The import setting type. Required.
additional_copy_options
dict[str, <xref:JSON>]

Additional copy options directly passed to snowflake Copy Command. Type: key value pairs (value should be string type) (or Expression with resultType object). Example: "additionalCopyOptions": { "DATE_FORMAT": "MM/DD/YYYY", "TIME_FORMAT": "'HH24:MI:SS.FF'" }.
additional_format_options
dict[str, <xref:JSON>]

Additional format options directly passed to snowflake Copy Command. Type: key value pairs (value should be string type) (or Expression with resultType object). Example: "additionalFormatOptions": { "FORCE": "TRUE", "LOAD_UNCERTAIN_FILES": "'FALSE'" }.
storage_integration
<xref:JSON>

The name of the snowflake storage integration to use for the copy operation. Type: string (or Expression with resultType string).