Exporting data to bigquery

[o_X]

Here is sample of my schema which I will export data to

  <element autopk="true" autouuid="true" dataSource="nms:extAccount:bqExport" desc="bqtest" hybrid="false" img="xtk:bigquery.png" label="bqtest" labelSingular="bqtest" name="bqtest" sqltable="bqtest">

    <attribute label="col1" name="col1" type="string"/>
    <attribute label="col2" name="col2" type="string"/>
    <attribute label="col3" name="col3" type="datetime"/>
</element>

In my workflow I am querying these 3 columns from campaign and then I have the update activity with operation type set to "Insert" as I only want to export deltas rather than syncing changes the gcp remote table, for this reason I had set the autopk="true" and autouuid="true"

However, I am getting the following error

10/01/2025 03:05:27	writer2	WDB-200001 SQL statement 'UPDATE wkf5712550_85_1 SET uAutoPKey_1= WHERE iRecProcState >= 0 AND COALESCE(uPKey_1,NULL) IS NULL' could not be executed.
10/01/2025 03:05:27	writer2	ODB-240000 ODBC error: [Simba][BigQuery] (70) Invalid query: Syntax error: Unexpected keyword WHERE at [1:41] SQLState: 37000

Any ideas whats wrong.

[_Manoj_Kumar_ · Accepted solution]

Hello @o_X 

Remove the autopk and create a custom primary key. That should fix the issue.