tSnowflakeOutputcomponent

Highlighted
Nine Stars

tSnowflakeOutputcomponent

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


Accepted Solutions
Highlighted
Employee

Re: tSnowflakeOutputcomponent

@manishchokkaram 

 

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 :-)

View solution in original post


All Replies
Highlighted
Employee

Re: tSnowflakeOutputcomponent

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 :-)

Highlighted
Nine Stars

Re: tSnowflakeOutputcomponent

Thanks @nikhilthampi 

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

 

 

Highlighted
Employee

Re: tSnowflakeOutputcomponent

@manishchokkaram 

 

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 :-)

View solution in original post

Highlighted
Nine Stars

Re: tSnowflakeOutputcomponent

Thanks @nikhilthampi 

 

I will create the Ticket soon

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Self-service Talend Migration: Moving from On-Premises to the Cloud

Move from On-Premises to the Cloud by following the advice of experts

Read Now