1. Visualizing Data in Oracle Analytics Server
  2. Visualize Data
  3. Connect to Data Sources
  4. Model Data in a Snowflake Data Warehouse
  5. Configure Your Environment for Modeling Snowflake Data

Configure Your Environment for Modeling Snowflake Data

Configure your environment so that you can model data in a Snowflake database.

In your data modeling environment, you need to install Data Gateway to provide the correct java libraries for interacting with the Snowflake driver. In Model Administration Tool, you can then import and model your Snowflake tables. You configure your Data Gateway agent with a suitable driver to connect to Snowflake.

Note: When you've modeled your Snowflake tables and uploaded the semantic model to Oracle Analytics, you can disable or remove Data Gateway (it isn't used when Oracle Analytics runs queries).

Before you start:
  • Install Data Gateway and Model Administration Tool on the same Windows computer in your on-premises environment. See Download page for Oracle Data Gateway.
  • Make sure that both your Model Administration Tool node where Data Gateway is installed, and your Oracle Analytics Server nodes have network access to the Snowflake endpoints.
  1. Configure the Oracle Analytics Server domain by downloading and installing the Snowflake JDBC driver so that BI users can run queries:
    1. Download the latest Snowflake JDBC driver (for example, in file snowflake-jdbc-3.9.0.jar).
    2. Copy the downloaded JAR file to the Oracle Analytics Server domain /lib folder:

      OracleHome/user_projects/domains/bi/lib

    3. Re-start Oracle Analytics Server.
  2. Configure a local Data Gateway agent to so that you can use Model Administration Tool to import metadata and view data for modeling:
    1. Copy the downloaded Snowflake JDBC driver JAR file to the Data Gateway installation folder.
      In a personal deployment on Windows, copy the JAR file into: <Data Gateway_extract_path>\thirdpartyDrivers.
    2. Re-start Data Gateway.