This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
google_bigquery [2021/04/01 10:08] windsor_ai created |
google_bigquery [2023/10/24 11:39] (current) windsor_ai |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Getting your data into Google BigQuery ====== | ====== Getting your data into Google BigQuery ====== | ||
+ | |||
+ | |||
==== Frequently asked questions ==== | ==== Frequently asked questions ==== | ||
- | * Do I need to create a table or will Windsor.ai create a table? | + | |
- | Windsor.ai will create a new table in your [[https:// | + | === How do I setup the transfer to Google Big Query? === |
- | * What user rights do I need to grant Windsor.ai? | + | |
- | | + | |
- | * How do I know if my data was processed successfully? | + | - You go to https:// |
- | | + | - On destination page you select Google Big Query |
+ | - You fill in the fields | ||
+ | - 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 [[https:// | ||
+ | |||
+ | === How do I find my data set ID? === | ||
+ | |||
+ | Head to your [[https:// | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | === 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 [[https:// | ||
+ | |||
+ | === 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 < | ||
+ | |||
+ | === Why is access to the cloud storage required? === | ||
+ | |||
+ | Windsor.ai creates a file in JSON format for the data it streams into your BigQuery table. | ||
+ | |||
+ | === How do I set up the cloud storage bucket? === | ||
+ | |||
+ | Head to [[https:// | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | 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 [[https:// | ||
+ | |||
+ | === How do I set up a cloud storage folder? === | ||
+ | |||
+ | In your [[https:// | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | === 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 [[https:// |