Hi everyone,
we are trying to load a table from an Oracle Db to a Snwoflake Db using Load From file feature of the Snowflake connector.
The Snowflake connector is able to perform all the steps, including the copy into stament on the Snowflake Database, but after that it returns an error:
Snowflake_Connector_2: java.lang.NullPointerException
at com.ibm.is.cc.snowflake.SnowflakeAdapter.postRun (SnowflakeAdapter.java: 685)
Snowflake_Connector_2: Java runtime exception occurred: java.lang.NullPointerException (com.ibm.is.cc.snowflake.SnowflakeAdapter::postRun, file SnowflakeAdapter.java, line 685)
Snowflake_Connector_2: The connector closed the connection to the data source.
main_program: Fatal Error: Operator(PXBridgeOp) terminated abnormally due to fatal error in the function postRun
It seems that the connector is not able to delete the Snowflake's stage, but also disabling the delete stage option it returns the same error.
The Connector has all the grant as it works as SYSADMIN.
------------------------------
Riccardo Papotti
------------------------------
#DataIntegration