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

  • 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, and Insert/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.

    Note:

    Only a single connectivity agent is supported for establishing a connection with the Snowflake Adapter.

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