Google Sheets (beta)
Beta functionality
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.
0