Bigquery and google sheets

[anigordel]

I want to create table in big query from drive, inserting google spreadsheet link, but it keeps to fail reading the spreadsheet.
What can i do ?

[Joevanie]

Per this post, there can be some latency with Google Sheets since the data is not persisted to BigQuery, which is why the query runs inconsistently. It is recommended to perform the following options:
1. Store the Google Sheets CSV within Google Cloud Storage.
2. Load the data into BigQuery.

[kolban]

Have you ever had it working and it stopped working?  Are you following a recipe or other set of instructions ... if yes, please post where to find them.  I hear that there is a failure reading the spreadsheet.  Are there any additional error or diagnostic messages written that might add some extra information?

[OlegS]

Hi @anigordel 

As a workaround you can import your Spread Sheet into windsor.ai account and export the data into BigQuery.