Overview
DataTools Pro Visual SQL Builder is a no-code visual SQL builder designed specifically for Snowflake users. It helps analysts, business users, and data teams quickly create and run queries without needing to write complex SQL. With an intuitive Streamlit-based interface, DataTools Pro Visual SQL Builder accelerates analysis and democratizes access to data across your organization.
Key Features
- Visual Query Builder – drag-and-drop interface to build SQL queries.
- Schema & Table Exploration – browse databases, schemas, and tables directly from the app.
- Instant Query Execution – run queries directly in Snowflake using your assigned warehouse.
- No-Code Analytics – empower non-technical users to explore data.
- Secure & Native – runs entirely inside Snowflake, no data leaves your environment.
Installation
1. From Snowflake Marketplace
- Navigate to Snowsight → Data Products → Marketplace.
- Search for DataTools Pro Visual SQL Builder – Visual SQL Builder for Snowflake.
- 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:
- Go to Data Products → Internal Marketplace.
- Locate DataTools Pro Visual SQL Builder and install.
Setup
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 Visual SQL Builder in Snowsight.
Usage
- Launch the app from Snowsight → Data Products → Apps.
- Explore your databases and schemas visually.
- Use the Visual SQL Builder to create queries without writing code.
- Execute queries against your warehouse and view results instantly.
