Download the Snowflake JDBC driver jar file
Before you can create a dataflow that moves data out of a Snowflake database, you must ensure that NiFi can interact with the Snowflake database using a JDBC interface. To do this, you must download the Snowflake JDBC driver jar file, upload it to each NiFi node in your cluster, and ensure the proper permissions are set.
You need the Snowflake driver file when defining the DBCP Connection Pool Controller Service that is used in the NiFi processors in the CFM dataflow moving data out of Snowflake. This driver allows NiFi to interact with the Snowflake database through the JDBC interface.
You have reviewed and met the prerequisites.
You are logged in as an admin user.
You have created a directory on all the NiFi nodes where you’ll make the driver file available for NiFi
Download the latest Snowflake JDBC jar file from the Snowflake website.
For information on how to get the Snowflake JDBC jar file, see the Snowflake documentation in the Related information section below.
- Upload the jar file to each of the NiFi nodes in your cluster.
As a root user, and on every NiFi node in your cluster, update the permissions
for the Snowflake JDBC jar file, and make sure this can be accessed and read by
the nifi user:
chown nifi: <snowflake-jdbc>.jar
Once you have completed the Snowflake JDBC driver jar file download, proceed to the following steps.
- Add Snowflake CA certificates to the NiFi truststore
- Build the dataflow.
- Create the Controller Services for your dataflow.
- Configure your source Processor.
- Configure your target Processor.
- Confirm your dataflow is successful