How to rename query in Db Connections

[Anonymous]

Hello,

I have a query define in my metadata.

I would like juste rename. I try with SQLBuilder Editor but i can change the comment of a query not the name.

Simply, how rename query "Q_NETAPP_E" with an another name ?

Thanks in advance

Dimitri

[vapukov · Accepted solution]

Hi Dimitri

you can just save query with new name and then delete original

or you can open Talend Workspace, find your project -> metadata -> connections -> STAGING_0.1.items and edit this file in text editor

something like:

    <queries xmi:id="_0YSuIBnWEemDPNd8P_QeIA">
      <query xmi:id="_0YSuIhnWEemDPNd8P_QeIA" id="_0YSuIRnWEemDPNd8P_QeIA" label="query_logs_full" value="select * from dwh_logs"/>
    </queries>

[Anonymous]

Hi vapuko,

It's works.

I prefer to change in file because sometimes the same query is in use more than one job.

Thanks

Dimitri

[vapukov]

Welcome! 🙂