In the data preview section, you can now perform the following operations as well:
- Group by
- Pivot
- Warehouse selection (Snowflake only)
Group by
You can aggregate results and group them by specific columns in the preview. Click on the three dots of any column for more actions, navigate to the second tab with three horizontal lines (aggregations), and select Group By <column_name>.
Group by the resultset.
Pivot
You can pivot the preview result set. Click on the <n>/<m> columns label and toggle Pivot on. You can now select the Row Groups, Values, and Column Labels by dragging columns from the list.
Pivot the resultset.
Warehouse selection for previewing data (Snowflake only)
For Snowflake-connected spaces, you can select from the available warehouses to preview data.
Select warehouse to use when previewing data.