Skip to main content

Snowflake Web UI Tour — All Tabs Explained in Simple Words

Snowflake Web UI Tour — All Tabs Explained in Simple Words

Your story-based guide to mastering the Snowflake Web Interface

Imagine Snowflake as a digital control room.
Every button, tab, and panel is a switch or dashboard letting you manage your data empire.
The Web UI is clean, modern, and designed to make complex data tasks simple.

Let’s go on a guided tour.


🏠 1. Home Tab — Your Launchpad

When you first log in, the Home tab welcomes you.

Features:

  • Recent Worksheets – Continue where you left off
  • Recent Queries – Track last executions
  • Resources – Quick links to databases, schemas, and tables
  • Learning Center – Snowflake docs & tutorials

Story Example:
Think of it like the lobby of a smart office — you can see all important dashboards and where you were working last.


📄 2. Worksheets Tab — Your Notebook for SQL

Worksheets are where all SQL magic happens.

Features:

  • Write, edit, and execute SQL queries
  • Multiple worksheets in tabs
  • Auto-completion of commands
  • Query result previews
  • Query history tracking

Story Example:
Worksheets are your digital notebook. You type, test, and see the output instantly.

Pro Tip:
Use CTRL+Enter (or CMD+Enter on Mac) to run the query. Results appear below immediately.


🏗 3. Databases Tab — Your Library of Data

The Databases tab organizes all your data objects.

Features:

  • List of databases, schemas, and tables
  • Preview table structure and sample data
  • Grants & privileges overview

Story Example:
This is like the library floor — every database is a shelf, every schema a bookcase, every table a book.

Pro Tip:
Hover over table names → Quick preview shows column names and types.


⚡ 4. Warehouses Tab — Manage Compute

Warehouses power Snowflake queries. The Warehouses tab lets you:

  • Create new virtual warehouses
  • Start, stop, suspend, or resume warehouses
  • Monitor usage & credit consumption
  • Scale up or down

Story Example:
Warehouses are the engines of your factory.
This tab is the engine room, where you can tune power levels.


🛡 5. Shares Tab — Share & Consume Data

Snowflake allows secure data sharing. The Shares tab lets you:

  • Manage inbound and outbound shares
  • Share selected databases or tables
  • Track consumers
  • Add or remove access

Story Example:
Think of it as the mailroom — you securely send and receive packages (data) without copying anything.


⚙️ 6. Account Tab — Admin Settings

Account Tab contains everything related to your Snowflake account:

  • Billing & usage overview
  • Account parameters & region settings
  • Security options
  • Resource monitors

Story Example:
This is the building’s control center. Only admins go here to adjust policies or monitor overall usage.


🔍 7. History Tab — Your Query Timeline

History tab is the time machine of Snowflake.

Features:

  • Shows all queries executed by the user
  • Execution status: Success, Failed, or Running
  • Query text, warehouse, role, and execution time
  • Download results for offline review

Story Example:
Imagine a black box recorder of all your warehouse operations. Super handy for debugging or auditing.


🧩 8. Data Marketplace Tab — Explore & Share

Snowflake Marketplace is where you can:

  • Discover datasets from other companies
  • Subscribe to curated external datasets
  • Share your own datasets securely

Story Example:
Think of it as a global data bazaar — easy to explore, plug in, and leverage data for analytics.


🔧 9. Help & Support Tab

Snowflake has an integrated help system:

  • Quick access to documentation
  • Training videos and tutorials
  • Contact support options

Story Example:
This is your concierge desk. Whenever you are stuck, help is a click away.


📊 10. Tips for Navigating the Web UI Efficiently

  • Keyboard shortcuts: Speed up query execution
  • Right-click menus: Quickly preview tables or create objects
  • Multi-tab worksheets: Keep queries organized
  • Favorite databases: Pin frequently used databases for fast access
  • Monitor credits: Keep an eye on warehouse usage

Pro Tip:
Most admins create 1 warehouse per team for clear visibility in the UI.


🎯 One-Sentence Summary

Snowflake Web UI is your digital control room: worksheets for queries, databases for storage, warehouses for compute, shares for collaboration, and history for auditing — all in a modern, intuitive interface.


🚀 Next Topic

👉 SQL Basics in Snowflake (SELECT, FILTER, GROUP BY)