Parameterize table name in snowflake output conncector
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.
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.
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?
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.
