PilotFish Integration with Snowflake via JDBC
Overview
PilotFish extends support for Snowflake by leveraging JDBC connectivity. For a comprehensive guide on obtaining and configuring the JDBC driver for Snowflake, please refer to the official documentation available on Snowflake’s website.
Setting Up the Snowflake JDBC Driver
- Driver Download: Ensure you’ve downloaded a Java 17 compatible version of the Snowflake JDBC driver.
- Installation: Once downloaded, place the driver .jar file into the lib directory of your PilotFish installation.
Driver Details:
- Driver String:
net.snowflake.client.jdbc.SnowflakeDriver - Connection URL Pattern:
jdbc:snowflake://<account_identifier>.snowflakecomputing.com/?<connection_params>
Configuring Snowflake in PilotFish’s Database SQL Transport
Here’s an example to assist you in setting up your Snowflake connection within a Database SQL Transport in PilotFish:
