Create a Local 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, this format:jdbc:snowflake://xxxx.snowflakecomputing.com?db=ODEV&warehouse=xxxxxx&schema=xxxxxx
   • RDC Version: Leave this field blank.
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: false.
5. Model your data using this connection.
6. Upload or publish your semantic model to Oracle Analytics Cloud when you have completed your model.
   Oracle Analytics Cloud connects to the Snowflake database without using Data Gateway.

You can now model your data using this connection.