I created a pipeline which send data from oracle cdc client to snowflakes. The origin is working fine but when I am trying to configure the destination and validate the pipeline I am getting the following error:
SNOWFLAKE_11 - Could not create SQL DataSource: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: JDBC driver encountered communication error. Message: HTTP status=403.
Can anyone help me regarding this.
@saikat_chatterjee - Thank you for reaching out to the Streamsets Community.
“HTTP status=403” is generic error and can occurs due to multiple reasons, would you please share the following to understand the exact cause of the issue:
The error is because of some configuration issues . Kindly check if the below configurations are in placed or not.
If you can manage to provide the correct config details in streamsets destination , then you will over come the issues.
Thank you for your help
@AkshayJadhav and @Bikram.
The pipeline is working fine, in the account tab under snowflakes we have to provide the locator instead of account name.
Happy to know that the issue has been resolved. Good day.
Kindly close the question.
Thank you - AkshayJ.