Snowflake Adapter Capabilities

The Snowflake Adapter enables you to integrate the Snowflake cloud database with Oracle Integration. You can configure the Snowflake Adapter as an invoke connection in an integration in Oracle Integration.

The Snowflake Adapter provides the following benefits using an external stage/external location:

Supports the bulk import of data from cloud storages such as Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP) into the table of the Snowflake cloud database.

Note:
AWS, GCP, and Microsoft Azure cloud storage services are currently supported by Snowflake.
Supports the bulk export of data into cloud storages such as AWS, Azure, and GCP from the table of a Snowflake Cloud database.
Supports the operations in an asynchronous process. You can use the Snowflake API to check the status of an asynchronous process and cancel the in-process asynchronous process.

The Snowflake Adapter provides the following benefits using an internal stage:

Supports the bulk import of data into the Snowflake database using the internal stage.
Supports the bulk export of data from the Snowflake database using the internal stage.
Supports the operations in a synchronous process. The Check/Cancel Statement Execution action does not apply to the internal stage. Once the process is completed, the Snowflake Adapter displays a response whether or not the statement is executed successfully.

The Snowflake Adapter is one of many predefined adapters included with Oracle Integration.

Supported Data Types

The Snowflake Adapter supports the following data types.

Category	Data Types
Numeric	NUMBER DECIMAL, NUMERIC INT, INTEGER, BIGINT, SMALLINT, TINYINT, BYTEINT FLOAT, FLOAT4, FLOAT8 DOUBLE, DOUBLE PRECISION, REAL
String and Binary	VARCHAR CHAR, CHARACTER STRING TEXT BINARY VARBINARY
Logical	BOOLEAN
Date and Time	DATE
Semi-Structured	VARIANT OBJECT ARRAY
GeoSpatial	GEOGRAPHY