Step 1. Open the 'Extensions' menu in the Google Sheets toolbar. Locate the 'OWOX: Reports, Charts & Pivots (Sheets, BigQuery)' item, then select 'Add a new report'.
Note:Each new report is created in a new sheet.
Step 2. In the extension sidebar, the first selection panel displays a list of BigQuery projects accessible to your signed-in Google account. If a specific project is missing, check your permissions on the Google Cloud IAM settings page, or consider switching to a different Google account (this will require reinstallation of the extension).
Select the desired project from the list.
ImportantThis list showcases GCP projects accessible to your Google account, which was used during the installation of the Extension. Selecting a GCP project and running a Data Mart in the Extension automatically creates an OWOX BI project if none is already associated with that GCP project. Read more in this article
Step 3. If you don't have any existing Data Mart, click the 'Create' link to create the first one.
3.1. In the Data Mart editor that has been opened, name your Data Mart and write your SQL code.
The Data Mart editor supports syntax highlighting, auto-suggestions, versioning, SQL code verification, and data-processed volume estimation.
After coding, make sure that your code is valid, check the estimated value of processed data, and click the 'Save & Run' button.
Step 4. (Optional) In your SQL code you can add dynamic parameters, and modify them in the sidebar.
Step 5. Click the 'Run' button to load your data from BigQuery to the Spreadsheet.
You're all set! Wait while the data is loaded into your Spreadsheet.
0 Comments