Get Snowflake Projects Live Faster. Reliably.

Register for webinar
Back to Product Updates

Data preview enhancements - Group by, pivot, and warehouse selection

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.

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.

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.

Select warehouse to use when previewing data.

Learn more →