topic tSnowflakeOutputcomponent in Talend Studio

tSnowflakeOutputcomponent

Anonymous — Sat, 16 Nov 2024 05:09:26 GMT

Hello All

how to connect to table without specifying shema in snowflake connection, like How to specify schema prefix in table name property.

I have a scenario, am not specifying any schema in tsnowflakeconnection, but while calling out at tsnowflakeoutput am specifying Schema.Table name, but am getting an error,

Can anybody suggest me a way to do it

Re: tSnowflakeOutputcomponent

Anonymous — Fri, 26 Jul 2019 21:03:31 GMT

Hi,

In this case, you will have to parse the schema name from the statement before hand and then pass it to schema value in either tSnowflakeConnection or tSnowflakeOutput Component.

Ideally, you should provide the correct schema name either through Metadata repository or if its built in, then at the time of connection.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tSnowflakeOutputcomponent

Anonymous — Fri, 26 Jul 2019 21:06:41 GMT

Thanks @nthampi

Am passing at the table like db0 + "." + table name, the same trick it worked for mssql and oracle output components, but its not working with snowflake components

Re: tSnowflakeOutputcomponent

Anonymous — Fri, 26 Jul 2019 21:09:12 GMT

@ksingh

Yeah. I got it. Snowflake component works slightly different in this case. I would recommend to create a feature request in JIRA and product team will then provide their view on this phenomenon.

https://jira.talendforge.org

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tSnowflakeOutputcomponent

Anonymous — Fri, 26 Jul 2019 21:17:29 GMT

Thanks @nthampi

I will create the Ticket soon