Create a Remote Semantic Model Connection to Snowflake

Connect to a local Snowflake database so that you can model Snowflake data.

1. In Model Administration Tool, enable the JDBC connection pool functionality by loading Java data sources. See Step 3 in Configure and Register Data Gateway for Reporting.
2. In Model Administration Tool, create a database and set the type to Snowflake.
3. Add a Connection Pools and specify these details on the General tab:
   • Call Interface: JDBC(Direct Driver).
   • Require fully qualified table names: Yes.
   • Data source name: Enter the connection string, in this format: jdbc:snowflake://xxxx.snowflakecomputing.com?db=ODEV&warehouse=xxxxxx&schema=xxxxxx
   • RDC Version: Set to 2.
4. On the Miscellaneous tab, specify these details:
   • JDS Server URL: Leave this field blank (remove any entry in this field).
   • Driver Class: net.snowflake.client.jdbc.SnowflakeDriver.
   • Use SQL over HTTP: true.
5. Model your data using this connection.
6. Upload or publish the semantic model to Oracle Analytics Cloud when you have completed your model.
   Note: Oracle Analytics Cloud connects to Snowflake using any configured Data Gateway agent.
7. Copy the Snowflake driver file to each Data Gateway agent installation folder.
   • In a server deployment, copy the JAR file into: <Data Gateway install_location>/domain/jettybase/thirdpartyDrivers.
   • In a personal deployment on Windows, copy the JAR file into: <Data Gateway_extract_path>\thirdpartyDrivers.
   • In a personal deployment on MacOS, copy the JAR file into: <Application->Show Package Contents>Resources->app.nw-> thirdpartyDrivers.
8. Re-start Data Gateway. See Maintain Data Gateway.