'Google Drive CSV linked to BigQuery as External Table
Until yesterday, I used to link CSV files from Google Drive to BigQuery as external tables by pasting in the shareable link of the file in Google Drive to the "Select Drive URI" field in BigQuery and edit it such that it had the "open?id=" syntax in it, otherwise it wouldn't work.
Yesterday, it changed such that I don't need to edit the link anymore to have "open?id=". I can just paste in the shareable link to the file in Google Drive "as is" and then proceed to create the table without error.
However, when I try to do anything with the linked table in BigQuery, such as query it, I am getting a long error message:
"An internal error occurred and the request could not be completed. This is usually caused by a transient issue. Retrying the job with back-off as described in the BigQuery SLA should solve the problem: https://cloud.google.com/bigquery/sla. If the error continues to occur please contact support at https://cloud.google.com/support."
Have the guys at Google tried to solve the issue of having to edit the Google Drive link and created another issue in the process? Incidentally, the existing linked tables using the "open?id=" syntax are continuing to work fine?
Has anyone else experienced this issue?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|