I want to store the data of Google Merchant Center in Bigquery using GCP's Data Transfer function.
But I keep getting errors.
Products data is not being downloaded among various data.
This is the error message.
Important message is 'Error code 3 : No data could be provided for your transfer.'.
PriceCompetitiveness
PriceInsights
ProductPerformance
Products_PriceBenchmarks
Only four things have been transmitted,
In fact, important 'Products' are not transmitted and errors occur.
Below is the error log for GCP Log Explorer.
==========================================================
{
"insertId": "ezlhacd7ajg",
"jsonPayload": {
"message": "Error code 3 : No data could be provided for your transfer."
},
"resource": {
"type": "bigquery_dts_config",
"labels": {
"project_id": "pj-xxxxxxxxx",
"location": "asia-northeast1",
"config_id": "65b7d470-0000-27a2-8079-94eb2c0dc9ce"
}
},
"timestamp": "2024-01-26T11:06:40.172871821Z",
"severity": "ERROR",
"labels": {
"run_id": "65b6e9e7-0000-2106-9cd9-2405887eb72c"
},
"logName": "projects/pj-xxxxxxxxx/logs/bigquerydatatransfer.googleapis.com%2Ftransfer_config",
"receiveTimestamp": "2024-01-26T11:06:40.866108256Z"
}
==========================================================
At first, when GCP Bigquery created a dataset, it was made into a Seoul region, so there was an error.
There are several regions that are supported, so the normal data is received as Tokyo region.
After that, the error disappeared and the data was received.
However, not all data is being received, but only some four are being received.
We are not receiving the data we really need.
Is it a problem with the GCP Bigquery setting?
Is it a problem with the Google Merchant Center setting?
Why doesn't the most basic products come in?
LinkedIn
Twitter
