Skip to main content

DataTools Pro Explorer for Snowflake Documentation

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. Our goal is to enable users of all skill levels to quickly analyze large volumes of data inside Snowflake, or self-serve to export data. With an intuitive Streamlit-based interface, DataTools Pro Explorer accelerates data access and simple data exploration.

View Snowflake Marketplace Listing | Release Notes | Snowflake Adoption Blueprint

Key Features

  • Visual Explorer – Aggregate, filter,r 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).
  • Save and Tag Explorations for Sharing – Save and share your explorations for others to view and access

Report an Issue or Enhancement

Run into an issue or have an enhancement request? We are always here to help! Email us at support@datatoolspro.com

DataTools Pro Explorer for Snowflake 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, and Strategic Partnerships)

If your org admin has published DataTools Pro Visual SQL Builder internally through private beta or other enterprise programs.

  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 DATATOOLS_PRO_EXPLORER;
GRANT USAGE ON SCHEMA <db_name>.<schema_name> TO APPLICATION DATATOOLS_PRO_EXPLORER;
-- GRANT SELECT ON TABLES WITHIN YOUR SCHEMA
GRANT SELECT ON ALL TABLES IN SCHEMA <db_name>.<schema_name> TO APPLICATION DATATOOLS_PRO_EXPLORER;
-- GRANT SELECT ON VIEWS WITHIN YOUR SCHEMA
GRANT SELECT ON ALL VIEWS IN SCHEMA <db_name>.<schema_name> TO APPLICATION  DATATOOLS_PRO_EXPLORER;

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

Usage – Explore Data

  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.

Select Columns

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).

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.

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.

Saving and Loading Saved Queries

To save an exploration for future access, simply click “Save” query.

Upon clicking “Save Query” you can name and tag the query with a category.

Loading a Saved Query

To access and load previously saved queries, click on the “Saved Queries” item in the left hand manu

Filter by Categories

To narrow the scope and list of queries, you can select categories that were set while saving or editing a query.

View Saved Query Details

Clicking on a saved query will expand an accordian with details about the query:

Database: Database used by explorer

Schema: Schema used by explorer

Table: Snowflake table accessed by explorer

Categories (Tags): Categorization for simplified serch and access

SQL Query: The SQL query generated by explorer

Run: Run the SQL Query

Edit with Explorer: Edit your existing query in explorer

Rename: Rename your query

Edit Tags: Add and remove tags

Delete: Delete your query

Manage Categories

Manage your categories, so they can be applied to your existing queries.

Choose a Category to manage

Select “Manage Categories” dropdown

Line of Business– Line of business like marketing or sales.

Topics– Open ended topics can be treated as tags that are relevant to your business.

Add category values to a category

In the “Add New Value” section, enter a value name

Click Add value

Delete category values

Select 1 or multiple categories

Click “Delete Selected” to remove the category value(s)