0

How to daily import Google workspace data automatically to Big Query database?

I'm new to Big Query and i can do it manually but i want to automate this process. Thanks.

mohammed zaid
  • 3
  • 3
  • Can you be more specific ? Google Workspace is a quite large sets of very different tools. Do you mean from Google Spreadsheets ? – Cylldby May 26 '21 at 01:19

1 Answers1

0

With BigQuery you can create external tables, that enable you to query data that is stored in your Google Drive (CSV, Avro, JSON, or Google Sheets documents).

You can find a nice how-to here.

Cylldby
  • 1,783
  • 1
  • 4
  • 17