Merge Key Location for Google BigQuery Service Connector
I can not pick a Merge Key Location when scheduling the update mode for the Google BigQuery Service Connector.
Can someone explain how to pick a key and how in general to set up the scheduling?
And if i can not choose a key, how does the connector work? What will be compared to replace rows in my dataset?
Btw, I am using MySQL.
Thank you
Best Answer
-
Hi there,
I'd recommend reviewing the docs from Google to help build the query and set the key: https://cloud.google.com/bigquery/docs/scheduling-queries
You could also set it to a full replace if needed, but then you would only be getting the data from the set date range. If it is set to append without a key it would look at the last run and include any new rows. Without having a key you may end up with duplicates if using that method.
Best of luck!
0
Categories
- 10.6K All Categories
- APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 251 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 62 Kowaza
- 295 仲間に相談
- 649 ひらめき共有