topic TdbTableList and tDBcolumnlist component for Snowflake database in Talend Studio

TdbTableList and tDBcolumnlist component for Snowflake database

Anonymous — Fri, 28 Jun 2019 07:01:23 GMT

Hello,

I do not see snowflake database option for tDBTABLELIST and tDBCOLUMNLIST components.

Do we have these components for snowflake?

will it be added in coming versions?

My requirement is to make "Not Available" one time entry in SCD2 dimensions using these 2 components in snowflake dimensions

Thank you

Re: TdbTableList and tDBcolumnlist component for Snowflake database

Anonymous — Tue, 02 Jul 2019 08:44:22 GMT

Hello,

Here is tJDBCSCDELT componentwhich is used to track data changes in a source database table using SCD (Slowly Changing Dimensions) Type 1 method and/or Type 2 method and writes both the current and historical data into a specified SCD dimension table.

For more information, please refer to documentation about:TalendHelpCenter:Tracking data changes in a Snowflake table using the tJDBCSCDELT component

Best regards

Sabrina