Snowsight quick tour¶
In Snowsight, you can perform data analysis and engineering tasks, monitor query and data loading and transformation activity, explore your Snowflake database objects, and administer your Snowflake database, including managing the cost and adding users and roles.
You can use Snowsight to perform the following tasks:
Work with data
Build and develop in Workspaces and Notebooks with SQL, Python, and multi-file projects.
Ingest and transform data using Snowpipe, connectors, tasks, and streams.
Analyze with AI using Snowflake Cortex functions, agents, and ML models.
Monitor activity including query history, task graphs, and data loading.
Discover and share on the Snowflake Marketplace.
Explore the Horizon Catalog
Discover data across your data estate with Universal Search and the catalog.
Share data products securely with other Snowflake accounts through listings.
Govern and protect data with masking policies, row access policies, and tags.
Manage your account
Optimize compute resources including warehouses and compute pools.
Administer users, roles, and access control.
Monitor and control costs with budgets and cost management views.
Manage Postgres instances within Snowflake.
For more information about these and other tasks that you can perform, see Snowsight: The Snowflake web interface.
Work with data¶
Workspaces¶
Workspaces is the unified editor for creating, organizing, and managing code across multiple file types. Workspaces provides a file-based development environment where you can write SQL and Python, organize projects with folders, and integrate with Git for version control.
For more information, see:
Notebooks in Workspaces¶
Notebooks in Workspaces provide an interactive, cell-based environment for Python, SQL, and Markdown. Use notebooks for exploratory data analysis, machine learning model development, and data science workflows with embedded visualizations and Git integration.
For more information, see:
Streamlit¶
Build and deploy interactive data applications with Streamlit in Snowflake. Create custom dashboards, reports, and data apps using Python without managing infrastructure.
For more information, see:
dbt projects¶
Develop and manage dbt projects with a web-based IDE that connects to Git repositories. Build, test, and run SQL-based data transformation pipelines directly in Snowflake with version control integration.
For more information, see:
Ingestion¶
Load data into Snowflake using Snowpipe for continuous ingestion, connectors for various data sources, and file uploads through the UI.
For more information, see:
Transformation¶
Transform your data with dbt projects for analytics engineering, dynamic tables for continuously refreshed materialized views, and tasks for scheduling transformation workflows.
For more information, see:
AI & ML¶
Build AI-powered applications with AI Studio, interact with data conversationally using Snowflake Intelligence, and leverage Cortex AI functions for text analysis and LLM capabilities. Use Cortex Agents for natural language interactions, Cortex Analyst for data analysis, Cortex Search for vector similarity search, and Cortex Code for AI-powered coding assistance. Manage machine learning models, features, and experiments for production ML workflows.
For more information, see:
Monitoring¶
Monitor and track query performance, container services and jobs, task execution, data loading activity, and system health. Review query history with Performance Explorer to analyze and optimize queries, view traces and logs for observability, and debug failed operations.
For more information, see:
Marketplace¶
Discover and share data products on the Snowflake Marketplace. As a provider, publish data products and application packages on the Snowflake Marketplace to share with the broader Snowflake community. As a consumer, access datasets and application packages from providers to derive real-time data insights without needing to set up a data pipeline or write any code.
For more information, see:
Explore the Horizon Catalog¶
Catalog¶
Discover database objects across your entire data estate with Universal Search and the Horizon Catalog. Explore databases, tables, functions, views, and more using the Database Explorer. Browse the Internal Marketplace to find data products shared within your organization, and manage apps and native application packages.
To learn more, see:
Data sharing¶
Collaborate with users in other Snowflake accounts by sharing data and application packages securely through Internal sharing (within your organization) or External sharing (to other organizations). As a provider, create data product listings, manage sharing agreements, and use auto-fulfillment to provide data across regions. As a consumer, access datasets and application packages shared with your account.
For more information, see:
Governance & security¶
Apply data governance policies to protect sensitive information, manage user access control, and monitor security posture. Use masking policies for column-level security, row access policies for row-level filtering, tags for data classification, create and manage users and roles, and evaluate account security in the Trust Center.
For more information, see:
Manage your account¶
Compute¶
Manage virtual warehouses for query execution and compute pools for container-based workloads. Optimize resource allocation, monitor utilization, and configure auto-suspend and auto-resume settings.
For more information, see:
Postgres¶
Create and manage Postgres instances within Snowflake. Deploy Postgres databases for compatibility with existing applications while leveraging Snowflake’s infrastructure and management capabilities.
For more information, see:
Admin¶
Manage cost and billing, configure account settings, set up integrations with external systems and services, and connect with partner tools through Partner Connect.
For more information, see: