Moving data out of Snowflake
You can create a NiFi dataflow 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 dataflow, 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 dataflow Creating Controller Services for your dataflow 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 dataflow success 