Worksheets appears only when worksheet analytics is enabled for your workspace. You can query
only the entities and values allowed by your role.
Create and run a query
1
Open Worksheets
From Analytics, select Worksheets.
2
Create a tab
Select New Worksheet or the plus button in the tab strip.
3
Build the query
Enter SQL in the editor. Autocomplete suggests catalog entities and columns available in the
current workspace.
4
Use the explorer
Search the schema tree and select an entity or column to insert it into the editor.
5
Run SQL
Select part of the SQL to run only that selection, or leave the editor unselected to run the
full query.
6
Save the worksheet
Select Save. Give a new worksheet a clear name when prompted.
Organize worksheets
The Explorer separates My Worksheets from Shared Worksheets when shared content is available. Search the list by name and sort it to find recent or alphabetical work. Open the worksheet menu to:- Open it in a tab;
- Copy it into a local draft;
- Rename it when you have edit access;
- Delete it when you have delete access.
Turn SQL into a blueprint
Open the save menu and select Save as Blueprint when the query should become a documented catalog entity. This action requires blueprint management access and opens the blueprint workflow with the worksheet SQL. Before you convert it:- Format the SQL.
- Run the complete query, not only a selection.
- Review the returned schema and sample values.
- Confirm that the query uses stable catalog entities.