topic Re: How to rename query in Db Connections in Talend Studio

How to rename query in Db Connections

Anonymous — Wed, 16 Jan 2019 05:30:19 GMT

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

Re: How to rename query in Db Connections

vapukov — Wed, 16 Jan 2019 21:45:51 GMT

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>

Re: How to rename query in Db Connections

Anonymous — Thu, 17 Jan 2019 07:33:44 GMT

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

Re: How to rename query in Db Connections

vapukov — Thu, 17 Jan 2019 07:43:53 GMT

Welcome! 🙂