Ask Your Question
0

Snowflake as an origin

asked 2020-08-04 12:32:31 -0500

txcs43vr gravatar image

updated 2020-08-04 12:33:38 -0500

Does anyone have a sample of a snowflake origin (source) jdbc connection string?

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
0

answered 2020-08-04 16:14:58 -0500

iamontheinet gravatar image

Hi!

Refer to their docs -- https://docs.snowflake.com/en/user-guide/jdbc-configure.html#jdbc-driver-connection-string -- and see if that helps.

Cheers, Dash

edit flag offensive delete link more

Comments

Saw that too but couldnt get it to work the snowflake tech support said my connection string should work but obviously it wasnt working

txcs43vr gravatar imagetxcs43vr ( 2020-08-05 12:19:39 -0500 )edit

Ok, can you update your question and include the error you're seeing, or better yet the entire stack trace?

iamontheinet gravatar imageiamontheinet ( 2020-08-05 12:33:10 -0500 )edit

I too have a similar connection issue.I tried defining the configuration in JDBC query consumer & JDBC multitable cnsmer Below is the error I get. JDBC_06 - Failed to initialize connection pool: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool:null

Manimars gravatar imageManimars ( 2020-08-10 08:44:36 -0500 )edit

I solved the problem by de-activating the option "Enforce Read-only Connection" in the "Advanced"- tab of the jdbc consumer.

Jordi gravatar imageJordi ( 2021-09-17 10:03:00 -0500 )edit
0

answered 2021-09-17 10:19:51 -0500

Jordi gravatar image

I solved the problem by de-activating the option "Enforce Read-only Connection" in the "Advanced"- tab of the jdbc consumer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-08-04 12:32:31 -0500

Seen: 268 times

Last updated: Sep 17