topic Re: Modifications of Talend type mappings files for metadata not applying in Talend Studio

Modifications of Talend type mappings files for metadata not applying

Alex9 — Fri, 15 Nov 2024 22:12:16 GMT

Hello,

I got an issue of mappings between Talend types and Snowflake database types.

Therefore, I am trying to modify the Snowflake XML mapping in the project properties as below:

I modified the file by clicking on "Edit" and "Apply" but it seems that no modification in this file is taken into account.

Even after restarting Talend and recreating the Snowflake connection in the metadata section.

Is there another file to modify or action to perform in order to apply the modifications ?

Talend version: 7.3.1

Thanks in advance for your help,

Alex

Re: Modifications of Talend type mappings files for metadata not applying

Anonymous — Thu, 12 Jan 2023 16:37:58 GMT

Hi Alex,

I am afraid that this is a known issue with Snowflake components. There is a feature request to improve this which is going to be worked on soon. But at the moment there is no fix. If you are using the Snowflake components to create your tables and then populate them, the only way of working around this is to create your tables, get the DDL's created, drop the tables, edit the DDLs to what you want and then build them again.

I know, this is not great at all. But we are aware of it and this will be in a patch if you are using the enterprise edition.

A quick thought, there might be another way to make this a little more palatable. You could create your tables with the types you want by using the Snowflake API and a tRestClient. Take a look here about the API....

https://docs.snowflake.com/en/developer-guide/sql-api/index.html

Re: Modifications of Talend type mappings files for metadata not applying

Alex9 — Fri, 13 Jan 2023 10:02:24 GMT

Hi rhall,

Thanks for your answer.

We'll try to find another solution.

Alex