1. Using the Snowflake Adapter with Oracle Integration 3
  2. Understand the Snowflake Adapter
  3. Snowflake Adapter Capabilities

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 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.

  • 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.
  • Supports executing stored procedures in the Snowflake database.
  • Supports executing SQL queries against database tables.
  • Supports performing the Select, Insert, Update, and Insert/Update (Merge) operations against database tables.
  • Supports Authorization Code Credentials authentication.

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
  • 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