Skip to main content
Question

Snowflake runnable process batch failed: com.streamsets.pipeline.api.StageException: SNOWFLAKE_00 - Could not perform SQL operation: java.sql.SQLException: Error when adding primary keys:


I have a simple pipeline from oracle multi table into snowflake destination. This error only happens when the destination table is not present but it does create the table with PK. After pipeline ran and I can truncate the table and re-run the pipeline without any issues. 

 

Any ideas? 

Reply