topic Re: Snowflake database name issue in Talend Studio

Snowflake database name issue

Anonymous — Tue, 24 Mar 2020 19:21:06 GMT

Hi Folks,

I am using Talend 7.3.1 and having an issue when loading data into Snowflake using the snowflakeDBOutput.

I am keep getting "table does not exist or not authorized " error when I have database name or schema name in lower case in Snowflake.

For example, I will get above error when I try to load data into a database name "Example". But If the database name is "EXAMPLE" then everything works fine.

Could anyone help me on how to make the Talend job work with lower case letters in the database name

Re: Snowflake database name issue

manodwhb — Wed, 25 Mar 2020 01:06:00 GMT

I believe the database name you will set only one time if you have created metadata connection for that database. So I suggest you to create a metadata connection for that database and you can import tables from that database and you can use those table to drag and drop to job design from repository.

Re: Snowflake database name issue

Anonymous — Wed, 25 Mar 2020 01:17:39 GMT

Hi Manothar,
I have tried to create connection in Metadata and use the connection from there but it does not work.
my jobs failed with the same error when the database name is not all capitalized

Re: Snowflake database name issue

manodwhb — Wed, 25 Mar 2020 01:20:35 GMT

So if is it upper case of the database name that connection is working,?

Re: Snowflake database name issue

Anonymous — Wed, 25 Mar 2020 01:24:09 GMT

connection is working.
I can see all available tables in both conditions.
but job only works when database name/schema name is upper case.
if the names contain lower case letter, job will fail with table not exist or not authorized error

Re: Snowflake database name issue

manodwhb — Wed, 25 Mar 2020 01:34:37 GMT

Database name: quotation marks, the name of the Snowflake database to be used. This name is case-sensitive and is normally upper case in Snowflake. Check the below link.
https://help.talend.com/reader/_LlTNckRRxzJvsZX2F88sA/jtWjldqOdzb7g5EPQMd2Tg

Re: Snowflake database name issue

Anonymous — Wed, 25 Mar 2020 01:41:50 GMT

is there a way or work around to work with lower case database name? we want to keep existing lower cased letter database name in our Snowflake

Re: Snowflake database name issue

manodwhb — Wed, 25 Mar 2020 02:22:38 GMT

The worked around you can try with built-in option to create connection use the context variable with lower case use it. Other than this I do not think other work around.