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.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有