User Tools

Site Tools


google_bigquery

This is an old revision of the document!


Getting your data into Google BigQuery

Frequently asked questions

  • How do I find my data set ID?

Head to your BigQuery Console and click on the data set you would like to use. You can now see the data set ID.

  • Do I need to create a table or will Windsor.ai create a table?

Windsor.ai will create a new table in your BigQuery Data Set with the name specified in the BigQuery configuration on Windsor.ai

  • What user rights do I need to grant Windsor.ai?

Please grant access to the user bq-upload@windsor-ai-bigquery.iam.gserviceaccount.com in your IAM & Admin Console and assign the roles BigQuery Admin and Storage Admin

  • How do I know if my data was processed successfully?

After you set up the configuration and click Save, it can take up to a few minutes for the data to load. A message will appear below Last processing status. If it is successful you can query your database with

 select * from [your table name] 
google_bigquery.1617333127.txt.gz · Last modified: 2021/04/02 04:12 by windsor_ai