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 capabilities:
-
Provides the following benefits using an external stage/external location:
- Supports the bulk import and export of data from
cloud storage services such as Amazon Web Services (AWS), Microsoft Azure,
and Google Cloud Platform (GCP) into a table of the Snowflake Cloud
database.
Note:
The AWS, GCP, and Microsoft Azure cloud storage services are currently supported by Snowflake. -
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.
- Supports the bulk import and export of data from
cloud storage services such as Amazon Web Services (AWS), Microsoft Azure,
and Google Cloud Platform (GCP) into a table of the Snowflake Cloud
database.
-
Provides the following benefits using an internal stage:
- Supports the bulk import and 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.
- Supports executing stored procedures in the Snowflake database.
- Supports executing SQL queries against database tables.
- Supports performing the
Select
,Insert
,Update
, andInsert/Update (Merge)
operations against database tables. - Supports Authorization Code Credentials authentication.
- Supports integration with publicly-accessible resources (direct connectivity over the public internet) and on-premises resources using the connectivity agent.
The Snowflake Adapter is one of many predefined adapters included with Oracle Integration. See the Adapters page in the Oracle Help Center.
Supported Data Types
The Snowflake Adapter supports the following data types.
Category | Data Types |
---|---|
Numeric |
|
String and Binary |
|
Logical | BOOLEAN |
Date and Time | DATE |
Semi-Structured |
|
GeoSpatial | GEOGRAPHY |