<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Update or delete data from BigQuery in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Update-or-delete-data-from-BigQuery/m-p/2317935#M88320</link>
    <description>&lt;P&gt;Hello,&lt;/P&gt; 
&lt;P&gt;I have a process that reads from MySQL and uploads the data to BigQuery.&lt;/P&gt; 
&lt;P&gt;In order to execute this, I'm using tMysqlinput &amp;gt; tmap &amp;gt;&amp;nbsp;&lt;SPAN&gt;tBigQueryInput&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;In certain conditions, I have to &lt;STRONG&gt;update or&amp;nbsp;delete&lt;/STRONG&gt; data from BigQuery.&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;I found this thread &lt;A href="https://community.qlik.com/s/feed/0D53p00007vCruRCAS#M18018" target="_blank"&gt;https://community.talend.com/t5/Design-and-Development/tBigQueryInput-DML-Update-BigQuery/m-p/53508#M18018&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;But couldn't understand how to specify the data that I want to delete or update.&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;Do someone know what it the best way to&amp;nbsp;update/ delete data from BigQuery, and how to connect it to tmap's&amp;nbsp;output?&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thanks,&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;Emma&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 08:07:45 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T08:07:45Z</dc:date>
    <item>
      <title>Update or delete data from BigQuery</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Update-or-delete-data-from-BigQuery/m-p/2317935#M88320</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt; 
&lt;P&gt;I have a process that reads from MySQL and uploads the data to BigQuery.&lt;/P&gt; 
&lt;P&gt;In order to execute this, I'm using tMysqlinput &amp;gt; tmap &amp;gt;&amp;nbsp;&lt;SPAN&gt;tBigQueryInput&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;In certain conditions, I have to &lt;STRONG&gt;update or&amp;nbsp;delete&lt;/STRONG&gt; data from BigQuery.&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;I found this thread &lt;A href="https://community.qlik.com/s/feed/0D53p00007vCruRCAS#M18018" target="_blank"&gt;https://community.talend.com/t5/Design-and-Development/tBigQueryInput-DML-Update-BigQuery/m-p/53508#M18018&lt;/A&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;But couldn't understand how to specify the data that I want to delete or update.&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;Do someone know what it the best way to&amp;nbsp;update/ delete data from BigQuery, and how to connect it to tmap's&amp;nbsp;output?&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Thanks,&lt;/P&gt; 
&lt;P&gt;&lt;SPAN&gt;Emma&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 08:07:45 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Update-or-delete-data-from-BigQuery/m-p/2317935#M88320</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T08:07:45Z</dc:date>
    </item>
    <item>
      <title>Re: Update or delete data from BigQuery</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Update-or-delete-data-from-BigQuery/m-p/2317936#M88321</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt; 
&lt;P&gt;Have you already checked these references about:&lt;/P&gt; 
&lt;P&gt;&lt;A class="external-link" title="Follow link" href="https://cloud.google.com/bigquery/docs/updating-data" target="_blank" rel="nofollow noopener noreferrer noopener noreferrer"&gt;https://cloud.google.com/bigquery/docs/updating-data&lt;/A&gt;&lt;BR /&gt; &lt;A class="external-link" title="Follow link" href="https://cloud.google.com/bigquery/docs/reference/standard-sql/" target="_blank" rel="nofollow noopener noreferrer noopener noreferrer"&gt;https://cloud.google.com/bigquery/docs/reference/standard-sql/&lt;/A&gt;?&lt;/P&gt; 
&lt;P&gt;This jira issue is still in process.&lt;/P&gt; 
&lt;P&gt;&lt;A title="https://jira.talendforge.org/browse/TBD-5959" href="https://jira.talendforge.org/browse/TBD-5959" target="_self" rel="nofollow noopener noreferrer"&gt;https://jira.talendforge.org/browse/TBD-5959&lt;/A&gt;&lt;/P&gt; 
&lt;P&gt;Best regards&lt;/P&gt; 
&lt;P&gt;Sabrina&lt;/P&gt;</description>
      <pubDate>Wed, 27 Jun 2018 10:35:30 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Update-or-delete-data-from-BigQuery/m-p/2317936#M88321</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-06-27T10:35:30Z</dc:date>
    </item>
  </channel>
</rss>

