Google Sheets (beta)
Google Sheets integration with the dbt Semantic Layer is a beta feature.
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 configured the dbt Semantic Layer and are using dbt v1.6 or higher.
- You have a Google account with access to Google Sheets.
- You can install Google add-ons.
- You have a dbt Cloud Environment ID and a service token to authenticate with from a dbt Cloud account.
- You must have a dbt Cloud Team or Enterprise account. Suitable for both Multi-tenant and Single-tenant deployment.
- Single-tenant accounts should contact their account representative for necessary setup and enablement.
Installing the add-on
Navigate to the dbt Semantic Layer for Sheets App to install the add-on.
- You can also find it in Google Sheets by going to Extensions -> Add-on -> Get add-ons and searching for it there.
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 your Host, 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 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.
- If you're using this extension, make sure you're signed into Chrome with the same Google profile you used to set up the Add-On. Log in with one Google profile at a time as using multiple Google profiles at once might cause issues.
Custom menu 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.
- For categorical dimensiosn, 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.