topic Re: Issue with Snowflake tDBOutPut - Tables creates but can't insert in Water Cooler

Issue with Snowflake tDBOutPut - Tables creates but can't insert

VinnieKofC — Fri, 24 Jan 2025 16:08:15 GMT

I'm running into an issue where when using a Snowflake Connection to use a tDBoutput component, the tables does get created in Snowflake, but every time I try to insert data into it, it says the table isn't found.

If I use the same connection params, credentials, roles etc... using a JDBC Connection an choosing the snowflake JAR file creation and inserts work fine.

I've also confirmed the account and roles used has the correct permissions on the DB and schema, if it was a permissions thing, I'd expect the JDBC connection to give the same error.

Re: Issue with Snowflake tDBOutPut - Tables creates but can't insert

Sue_Macaluso — Mon, 27 Jan 2025 13:42:53 GMT

@VinnieKofC What solution are you using. I'd like to get this into the correct forum.

Re: Issue with Snowflake tDBOutPut - Tables creates but can't insert

VinnieKofC — Mon, 27 Jan 2025 14:32:40 GMT

It was my bone head mistake. I forgot that the connection string in the component to Snowflake is CASE SENSITIVE, and I had the schema set in lower case 😃