Worksheets
data.all offers a rich editor to write SQL queries and explore data. It is Athena on the backend that runs our queries on environments where our teams have been onboarded.
π¦ Create a Worksheet
On the left pane under Play click on Worksheets to go to the Worksheet menu. Here you will find all Worksheets owned by your teams.
β Shared queries = Seamless Collaboration
Check, learn from and collaborate with other members of your team to improve your analyses and get insights from your data, directly from data.all worksheets. No need to send queries by email, no need to create views :)
To create a new worksheet click on the Create button in the top right corner and fill the Worksheet form:
Field | Description | Required | Editable | Example |
---|---|---|---|---|
Worksheet name | Name of the worksheet | Yes | Yes | PalmDor |
Short description | Short description about the worksheet | No | Yes | Query used to retrieve Palm Dβor winners |
Team | Team that owns the worksheet | Yes | No | DataScienceTeam |
Tags | Tags | No | Yes | adhoc |
π No AWS resources
When we are creating a worksheet we are NOT deploying AWS resources. We donβt provision clusters, we are not creating tables or views. We simply store the query in data.all database and we run it serverlessly on AWS Athena.
βοΈ Edit worksheet metadata
Select a worksheet and click on the pencil icon to edit the metadata of the worksheet. This includes worksheet name, description and tags. The ownership of the worksheet, its team, is not editable.
ποΈ Delete a worksheet
Next to the edit button, there are 2 other buttons. To delete a worksheet click on the trash icon one. Worksheets are not AWS resources, they are a data.all construct whose information is stored in the data.all database. Thus, when we delete a worksheet we are not deleting AWS resources or CloudFormation stacks.
π Write and save your queries
Select your worksheet and choose any of the environments, datasets and tables of your team to list column information. In the query editor write your SQL statements and click on Run Query to get your query results. Error messages coming from Athena will pop-up automatically.
If you want to save the current query for later or for other users, click on the save icon (between the edit and the delete buttons).
β More than just SELECT
Worksheets can be used for data exploration, for quick ad-hoc queries and for more complicated queries that require joins. As far as you have access to the joined datasets you can combine information from multiple tables or datasets. Check the docs for more information on AWS Athena SQL syntax.