How to rename query in Db Connections

Six Stars

How to rename query in Db Connections

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.TalendRenameQuery.JPG

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

 

Thanks in advance

 

Dimitri


Accepted Solutions
Thirteen Stars

Re: How to rename query in Db Connections

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>
-----------

All Replies
Thirteen Stars

Re: How to rename query in Db Connections

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>
-----------
Highlighted
Six Stars

Re: How to rename query in Db Connections

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

Thirteen Stars

Re: How to rename query in Db Connections

Welcome! :-)

-----------

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.