Table of Contents

Getting your data into Google BigQuery

Frequently asked questions

How do I setup the transfer to Google Big Query?

  1. You go to https://onboard.windsor.ai/
  2. On destination page you select Google Big Query
  3. You fill in the fields
  4. As connector URL you can use any URL providing a JSON. Either from the connectors or for example a URL with cached and transformed data from charts.windsor.ai

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]

I'm having problems with my connector URL. How do I test if it is working correctly?

If you have a complex query it makes sense to test your connector URL in a tool like Postman or Insomnia to make sure that it is working as expected.