tSnowflakeOutputcomponent

[Anonymous]

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

[Anonymous]

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 🙂

[Anonymous]

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

[Anonymous · Accepted solution]

@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 🙂

[Anonymous]

Thanks @nthampi 

I will create the Ticket soon