Moving data out of Snowflake
You can create a NiFi data
flow to move data out of Snowflake. To do this, you must meet some
prerequisites, download the Snowflake JDBC driver JAR file, update the NiFi truststore,
configure your controller services, build your data flow, and configure the source and target
processors.
Before you begin Downloading the Snowflake JDBC driver JAR file Adding Snowflake CA certificates to NiFi truststore Building your data flow Creating Controller Services for your data flow Configuring your source processor ListDatabaseTable processor to get data from your Snowflake table. To do this, launch the Configure Processor window, specify the necessary configurations, and start the process to verify that you can view the Snowflake table. Configuring your target processor ExecuteSQLRecord processor to handle data pooling from remote tables. To do this, launch the processor configuration window and provide the configurations appropriate for your use case.Confirming your data flow success 