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

[VinnieKofC]

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. 

[Sue_Macaluso]

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

[VinnieKofC]

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 😃