Google Sheets (beta)
Google Sheets integration with the dbt Semantic Layer is a beta feature and is subject to change without notification.
The dbt Semantic Layer offers a seamless integration with Google Sheets through a custom menu. This add-on allows you to build dbt Semantic Layer queries and return data on your metrics directly within Google Sheet.
Prerequisites
- You have a Google account with access to Google Sheets.
- You can install Google add-ons.
- You have set up the dbt Semantic Layer.
- You have a dbt Cloud Environment ID and a service token to authenticate with from a dbt Cloud account.
Installing the add-on
- In Google Sheets, navigate to Extensions -> Add-on -> Get add-ons.
- Search for "dbt Semantic Layer for Sheets" and install it.
- After installing, open the Add-On menu and select the "dbt Semantic Layer for Sheets". This will open a custom menu to the right-hand side of your screen.
- Authenticate with the dbt Cloud Environment ID and Service Token.
- Start querying your metrics using the Query Builder!
- For more info on the menu functions, refer to Custom menu key functions.
When querying your data with Google Sheets:
- It returns the data to the cell you have clicked on.
- The custom menu operation has a timeout limit of six (6) minutes.
Custom menu key functions
The custom menu provides the following capabilities:
| Menu items | Description |
|---|---|
| Metrics | Search and select metrics. |
| Group By | Search and select dimensions to group by. Dimensions are grouped by the entity of the semantic model they come from. |
| Granularity | Modify the granularity of the primary time dimension. |
| Where | Filter your data. This includes categorical and time filters. |
| Order By | Return your data ordered. |
| Limit | Set a limit for the rows of your output. |
Filtering data
To use the filter functionality, choose the dimension you want to filter by and select the operation you want to filter on.
- If it's a categorical dimension, type in the dimension value you want to filter by (no quotes needed) and press enter.
- Continue adding additional filters as needed with AND and OR. If it's a time dimension, choose the operator and select from the calendar.
Limited Use Policy Disclosure
The dbt Semantic Layer for Sheet's use and transfer to any other app of information received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.