topic Re: Parameterize table name in snowflake output conncector in Talend Studio

Parameterize table name in snowflake output conncector

Anonymous — Sat, 16 Nov 2024 07:22:04 GMT

We have a migration project where the Oracle data needs to be migrated to Snowflake. We are using Talend cloud integration for the migration. For POC, we wanted to migrate sample data. Snowflake connection is successful but it does not allow to get the table name from tFlowToIterate. We need to choose the table name from the list of tables. Doing this for each table will be time consuming. Is it possible to pass table name as a variable. Or it there any work around to achieve this.

Re: Parameterize table name in snowflake output conncector

Anonymous — Mon, 05 Nov 2018 09:56:59 GMT

Hello,

Here is a tOracleTableList component in talend which lists the names of specified Oracle tables using a SELECT statement based on a WHERE clause. Let us know if it is what you are looking for.

Best regards

Sabrina

Re: Parameterize table name in snowflake output conncector

Anonymous — Tue, 13 Nov 2018 09:07:09 GMT

Hi Sabrina,

Thanks for your reply. I am able to parameterize the table name in tOracleInput but not in tSnowflakeoutput. The table name in tSnowflakeOutput is non editable and it only allows to choose the table name from the given list. Is there a way to parameterize the table name in tSnowflakeOutput? Or is there any other way to connect to snowflake which can allow dynamic table names?

Re: Parameterize table name in snowflake output conncector

Anonymous — Tue, 27 Nov 2018 12:17:44 GMT

Hello @dixita_joshi have you tried to Use custom object checkbox in a dialog? You can put smth like this (String) globalMap.get("tableNameKey") to dynamically specify the table name.

Regards,

Maksym.