Difference between revisions of "Google BigQuery"

(Created page with "You can connect to Google BigQuery as of Version 9. When you first connect you will be prompted to allow XLCubed to access your data. Press "Allow" in the browser window,...")
 
m (Text replacement - "XLCubed" to "FluenceXL")
 
Line 1: Line 1:
 
You can connect to Google BigQuery as of [[Version 9]].
 
You can connect to Google BigQuery as of [[Version 9]].
  
When you first connect you will be prompted to allow XLCubed to access your data. Press "Allow" in the browser window, and then return to the connection screen where you will see the databases you have access to listed.
+
When you first connect you will be prompted to allow FluenceXL to access your data. Press "Allow" in the browser window, and then return to the connection screen where you will see the databases you have access to listed.
  
 
The credentials are saved, if you wish to clear them you can click "Refresh Connections" and connect again.
 
The credentials are saved, if you wish to clear them you can click "Refresh Connections" and connect again.
  
 
You can create [[Table]] style reports using BigQuery's SQL syntax, or create a [[Pivot View]] on a view of the data to allow easy slice and dice.
 
You can create [[Table]] style reports using BigQuery's SQL syntax, or create a [[Pivot View]] on a view of the data to allow easy slice and dice.

Latest revision as of 22:18, 3 July 2023

You can connect to Google BigQuery as of Version 9.

When you first connect you will be prompted to allow FluenceXL to access your data. Press "Allow" in the browser window, and then return to the connection screen where you will see the databases you have access to listed.

The credentials are saved, if you wish to clear them you can click "Refresh Connections" and connect again.

You can create Table style reports using BigQuery's SQL syntax, or create a Pivot View on a view of the data to allow easy slice and dice.