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


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

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

 

 

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

Nine Stars

Re: tSnowflakeOutputcomponent

Thanks @nikhilthampi 

 

I will create the Ticket soon

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Studio Improvements for API Services

Taken a look at the Talend Studio improvements for API Services

Watch Now