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

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

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

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

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] 

Windsor.ai creates a file in JSON format for the data it streams into your BigQuery table.

Head to Cloud Storage and create a new bucket (unless you want to reuse an existing one.

Then specify your region. Here is a sample configuration:

Once you click finish add the name (marketing-data-demo in this sample) in Google Cloud Storage Bucket on Windsor.ai

In your Cloud Storage bucket, click on create new folder. Use this folder name on Windsor.ai

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.