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.
|String and Binary||
|Date and Time||DATE|