Knowledge Base

User Tools

Site Tools

Trace:
google_bigquery

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
google_bigquery [2023/10/24 11:38]
windsor_ai 		google_bigquery [2024/08/21 16:19] (current)
windsor_ai
Line 14: Line 14:
   - 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   - 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
  
-{{:mk_2023-10-24_12-35-45_2x.png?800|}}+{{:mk_2024-08-21_17-18-55_2x.png?400|}}
  
  
Line 24: Line 24:
  
 Windsor.ai will create a new table in your [[https://console.cloud.google.com/bigquery/|BigQuery Data Set]] with the name specified in the BigQuery configuration on [[https://onboard.windsor.ai|Windsor.ai]] Windsor.ai will create a new table in your [[https://console.cloud.google.com/bigquery/|BigQuery Data Set]] with the name specified in the BigQuery configuration on [[https://onboard.windsor.ai|Windsor.ai]]
- 
-=== How do I find my data set ID? === 
- 
-Head to your [[https://console.cloud.google.com/bigquery/|BigQuery Console]] and click on the data set you would like to use. You can now see the data set ID. 
- 
-{{ :find-data-set-id-google-bigquery.png?nolink&700 |}} 
- 
  
 === What user rights do I need to grant Windsor.ai? === === What user rights do I need to grant Windsor.ai? ===
Line 40: Line 33:
 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 <code> select * from [your table name] </code> 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 <code> select * from [your table name] </code>
  
-=== 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://console.cloud.google.com/storage|Cloud Storage]] and create a new bucket (unless you want to reuse an existing one.  
- 
-{{ :create-google-cloud-storage-bucket.png?nolink&700 |}} 
- 
-Then specify your region. Here is a sample configuration: 
- 
-{{ :bigquery-configuration.png?nolink&800 |}} 
- 
-Once you click finish add the name (marketing-data-demo in this sample) in Google Cloud Storage Bucket on [[https://onboard.windsor.ai|Windsor.ai]] 
- 
-=== How do I set up a cloud storage folder? === 
- 
-In your [[https://console.cloud.google.com/storage|Cloud Storage]] bucket, click on create new folder. Use this folder name on [[https://onboard.windsor.ai|Windsor.ai]] 
  
-{{ :create-cloud-storage-folder.png?nolink&600 |}} 
  
  
google_bigquery.1698143889.txt.gz ยท Last modified: 2023/10/24 11:38 by windsor_ai

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki