Adding Drive File into BigQuery

  • date 29th May, 2021 |
  • by Prwatech |


GCP account

Click the above link. It will open google drive of yours.

Click New.

Google Sheets > Blank Spreadsheet.

Type the spreadsheet like below.

In cell B3 type

=GOOGLETRANSLATE(‘source cell’, ”written language”, ‘translation language’)

Give the cell ID’s for source message and translation language.

Click outside of that cell

Open the console.

Go to Menu > Big Query > SQL Instances

Select the project.

Click on Create Dataset.

Give the Dataset ID.

Click on Create Dataset.

It will listed in under the project.

Click on Create Table

Select the Source as Drive.

Open the Drive spreadsheet. Copy the Link.

Paste it in the URI. Choose File format as Google Drive.

Give the table name.

Select the edit as text.

Type the below code.




Click Create Table.

Type the Query in Query Editor. And press run.

The query will be executed and it will show the results in Query results.

Quick Support

image image