Skip to content

Workbench

Data Browser#

Data Browser Overview#

The Data Browser provides all your Snowflake Schemas and datasets.

You can fade in or fade out the Data Browser by clicking "<<".

The Data Browser provides the following information:

  • an 'Upload File' button to upload data from your device
  • all of your Snowflake Warehouses, ordered alphabetically
  • all of your Snowflake Schemas and datasets
  • a filter option to browse more specifically through your data

The order within the Data Browser is the following:

  • Snowflake Warehouses are sorted alphabetically
  • Snowflake Schemas are sorted alphabetically
  • tables are sorted alphabetically
  • columns are sorted in the order defined in Snowflake's Schema

Browsing Datasets#

In order to find your needed dataset, you can enter your text in the search bar. Filtering is possible for databases, schemas and tables. Column filtering is not possible.

Find your matching entries listed below the search bar.

More Filtering Options#

You can filter the entries by the following criteria:

  • "All Datasets": all available datasets are displayed
  • "Added Datasets": shows added and in-use datasets for the actual Project

Data Grid#

Data Grid Overview#

The Data Preview are allows you to preview the selected dataset as well as provides the option to download the datasets as CSV.

To explore the columns of a dataset, click on "COLUMNS". This view presents the column names (table schema), their data type as well as metadata (optinal).

To view a data preview of the actual data and get insights like filtering or sorting the values, click on "DATA PREVIEW".

To view the profile information such as column metrics, click on "Profile".

To view and copy the SQL query for views, click on "SQL".

SQL Syntax#

The SQL syntax is highlighted to identify the single syntax expressions. Find the following highlighting in the SQL Editor:

Inspector#

The Inspector contains all information about the actual dataset/ table/ warehouse/ Project that is selected.

Dataset Inspector#

The Dataset Inspector provides all information about the selected dataset. To get insights, click on the dataset and view the following information:

Info Tab

  • Source: displays a link to the schema and its details, lists in which Projects the dataset is used in
  • Description: displays the dataset description
  • Owner: names the Datameer owner of the dataset
  • Tags: displays tags, if already set
  • Date and time information: displays the initial creation date and time, displays the last modified date and time

Transform Tab

  • Recipe: option to add a transformation/ operation to the recipe
  • Operations list: lists the already applied operations according to the execution time, provides the option to delete an already added operation

Schedule Tab

Daily:

  • Enable Scheduler: enables scheduling option for the asset
  • Repeat: provides the scheduling options 'Daily', 'Weekly', 'Custom'
  • Start at (UTC): sets the scheduling time

Weekly:

  • Enable Scheduler: enables scheduling option for the asset
  • Repeat: provides the scheduling options 'Daily', 'Weekly', 'Custom'
  • Repeat on: clickable weekday buttons
  • Start at (UTC): sets the scheduling time

Custom:

  • Enable Scheduler: enables scheduling option for the asset
  • Repeat: provides the scheduling options 'Daily', 'Weekly', 'Custom'
  • Cron Pattern: field for the custom cron pattern with allowed values below