Null Pointer error : While exporting data to Snowflake

ManojKalorey
ManojKalorey
in Integrations and extensibility

Hello Team ,

I am getting NULL POINTER error while exporting data to snowflake , below are the development scrips and error screenshot .

Anaplan connect version: anaplan_connect_4.2.1

Snowflake drivers used: Almost tried with all latest snowflake-jdbc-3.13.22 / 3.21/3.16

Error:

I am able to import the csv file but it is not initiating the jdbc to export it . even i tested by loading import csv i my system and i can get the csv file in my system.

image.png
image.png

My Dat file :

image.png

My Property file :

jdbc.connect.url=jdbc:snowflake://<Myaccount>.azure.snowflakecomputing.com/?user=manojkal&warehouse=BI_WH&db=BI_DB&schema=STAGING&role=SNOWFLAKE_N&authenticator=externalbrowser
jdbc.batch.size=1000
jdbc.query=INSERT INTO TABLE(Col1,Col2,col3 till 17 column) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);
#jdbc.params="","","","","","","","","","","","","","","","",""

Tagged:

Categories