Snowflake not listed in tDBOutputBulk

Highlighted
Seven Stars

Snowflake not listed in tDBOutputBulk

I am trying to load a Snowflake table using Talend. But the tDBOutputBulk and tDBOutputBulkExec does not list Snowflake in the Database drop down.

 

SFlake.PNG

 

 

 

Sixteen Stars
Sixteen Stars

Re: Snowflake not listed in tDBOutputBulk

Use tSnowflake components family (tSnowflakeOutputBulkExec instead of tDBOutputBulkExec for example)


TRF
Highlighted
Seven Stars

Re: Snowflake not listed in tDBOutputBulk

@TRF 

I only see these components under Snowflake. I am using Open Studio version 7.2

 

SFlake1.PNG

Highlighted
Sixteen Stars
Sixteen Stars

Re: Snowflake not listed in tDBOutputBulk

I can see the components with 7.1.1 version.
Maybe they are hidden in the palette.
Try to open a job, click anywhere on the workspace then enter the beginning of thé component name such as tsnow. You should see the complete list of Snowflake components.

TRF
Highlighted
Seven Stars

Re: Snowflake not listed in tDBOutputBulk

@TRF 

Thats exactly what I did earlier.

 

SFlake2.PNG

Highlighted
Sixteen Stars
Sixteen Stars

Re: Snowflake not listed in tDBOutputBulk

Well, it seems these components are not available anymore. Can't see them on 7.3 Community Ed but available on 7.1.1 Subscription Ed.

TRF
Highlighted
Seven Stars

Re: Snowflake not listed in tDBOutputBulk

@TRF 

So is there any other way to load data into the Snowflake  data warehouse?

 

Highlighted
Sixteen Stars
Sixteen Stars

Re: Snowflake not listed in tDBOutputBulk

Thèse components are available under subscription (see there https://help.talend.com/reader/sE2oIRltOtNXikMdAIt47w/sfIx5GQYxmio3LZZw98HeA).
Don't know if there is an other way to do that.

TRF

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog