Skip to main content

DataTools Pro Explorer for Snowflake

Overview

DataTools Pro Explorer for Snowflake is a simple data exploration tool to aggregate, filter, and sort data quickly while generating SQL code for you. DataTools Pro Explorer allows you to explore Snowflake tables and views, so users of all skill levels can quickly analyze large volumes of data or quickly filter to a smaller population. With an intuitive Streamlit-based interface, DataTools Pro Explorer accelerates analysis and democratizes access to data across your organization directly inside of Snwoflake.

Key Features

  • Visual Exlorer – Aggregate, filter and sort your data
  • Schema & Table Exploration – browse databases, schemas, and tables and views to select your data set
  • Instant Query Execution – Run queries directly in Snowflake using your assigned warehouse.
  • No-Code Analysis– Empower non-technical users to select aggregate, explore and export data.
  • Secure & Native – runs entirely inside Snowflake, no data leaves your environment (unless it is exported).

Installation

1. From Snowflake Marketplace

  1. Navigate to Snowsight → Data Products → Marketplace.
  2. Search for DataTools Pro Explorer.
  3. Click Get to install the application into your Snowflake account.

2. From Internal Marketplace (Testing / Org Only)

If your org admin has published DataTools Pro Visual SQL Builder internally:

  1. Go to Data Products → Internal Marketplace.
  2. Locate DataTools Pro Explorer and install.

Setup / Permissions

After installation:

Grant the application the ability to read from the required databases/schemas:

GRANT USAGE ON DATABASE <db_name> TO APPLICATION SNOWPREP_DEV;
GRANT USAGE ON SCHEMA <db_name>.<schema_name> TO APPLICATION SNOWPREP_DEV;
GRANT SELECT ON ALL TABLES IN SCHEMA <db_name>.<schema_name> TO APPLICATION SNOWPREP_DEV;

Once permissions are set, open the app from Apps → DataTools Pro Explorer in Snowsight.

Usage

  1. Launch the app from Snowsight → Data Products → Apps.
  2. Explore your databases and schemas and select 1 single table or view.
  3. Use the DataTools Pro Explorer to create queries without writing code.
  4. Execute queries against your warehouse and view results instantly.

Key Features

Select Columns

Filter

Set one or multiple filters, where you can utilize standard Snowflake conditions. DataTools Pro Explorer supports combining multiple filters. It supports combining AND and “OR” conditions, but does not currently allow you to mix and match AND / OR conditions.

Aggregation

Dimensions

Select columns that act as dimensions to group your data by

Measures – Numeric values

These are aggregated numeric values.

Column– The numeric field to aggregate.

Function– Aggregation function such as:

  • COUNT → counts rows or values.
  • SUM → total of the values.
  • AVG → mean.
  • MIN / MAX → smallest or largest

Alias – The name you want for the output field (default in screenshot is count_ordinal_position).

Sort

Select multiple columns to order by. Set for each column an ASC (ascending) or DESC (descending) sort order.

Query Preview

DataTools Pro Explorer generates a live SQL preview based on the combination of options you select.

Click “Run query” to run the SQL query and view results.

Limit

Limit the number of rows you return.

Table Output

Export data

Export your data to CSV by clicking on the download icon

Search data

Search for individual data points within your table.

Report an Issue

Run into an issue or have an enhancement request? We are always here to help!