Knowledge Graph — Coursera Notes › Academic disciplines › Computer Science / Information Technology › Cloud Computing
Snowflake
service · part of Cloud Computing
A cloud data platform that supports stored procedures with Snowflake Scripting.
Inside Snowflake (94)
- Snowflake Cortex — A set of AI functions within Snowflake for tasks like LLM completion, search, and sentiment analysis.
- Snowpark — A library and runtime for executing Python code on Snowflake data.
- Streamlit in Snowflake — A feature that allows Python-based Streamlit apps to run inside a Snowflake account for dashboards and internal tools.
- User-Defined Function (UDF) — A Snowflake feature that allows users to define custom functions using SQL, Python, JavaScript, Java, or Scala.
- Snowflake Database Explorer — A hierarchical view in Snowsight showing all databases, schemas, and objects accessible to the current role.
- Snowflake Stage — An intermediate object that serves as a bridge between a data source and a Snowflake table, used for data ingestion.
- Snowflake Time Travel — A Snowflake feature that allows accessing previous versions of data, schemas, and tables within a defined retention period.
- Virtual Warehouse — A compute resource in Snowflake that processes data queries using CPU, memory, and temporary storage.
- Snowsight — The browser-based UI for Snowflake, used as an alternative to the VS Code extension for development.
- Snowflake extension for VS Code — An official VS Code extension that enables connecting to Snowflake, browsing objects, writing and running SQL, autocomplete, query history, and session context changes.
- Snowpipe — A Snowflake service that continuously loads files from cloud storage into Snowflake.
- Snowflake Data Clean Rooms — Enables organizations to collaborate on sensitive data without sharing raw records, returning only aggregated results.
- Snowpark ML — Snowflake's Python-based machine learning framework for building and training models using Snowpark DataFrames.
- Data Engineering — A workload on Snowflake involving building pipelines and managing data.
- Dynamic Table — A table that stores precomputed query results and refreshes automatically based on a configured target lag.
- Resource Monitor — A Snowflake feature that limits or controls credit usage with configurable quotas and triggers.
- Snowflake cloning — A zero-copy cloning feature that creates a new object referencing the same micro-partitions as the original, without immediately copying all data.
- Snowflake Git integration — Allows Snowflake to connect with Git providers for version control, branching, and syncing code/notebooks.
- Snowflake Notebooks — Cell-based development environments in Snowsight supporting SQL, Python, and Markdown for data exploration and model development.
- Snowpark ML Modeling — A Snowflake feature providing APIs inspired by scikit-learn, XGBoost, and LightGBM for preprocessing, training, and prediction workflows on Snowflake data.
- Storage layer — Handles structured, semi-structured, and unstructured data with micro-partitioning, compression, encryption, and metadata management.
- Stored Procedure — A database object that encapsulates procedural logic and DML statements for reuse.
- ACCOUNTADMIN — The highest account-level administrative role in Snowflake, inheriting other key admin roles.
- AI & ML Studio — A Snowsight interface for using AI and ML capabilities with minimal code, supporting forecasting, classification, and simple ML workflows.
- AI/ML — A workload on Snowflake involving artificial intelligence and machine learning.
- Alert — A Snowflake object that checks a condition and executes an action when the condition is met, used for monitoring pipelines.
- Applications — A workload on Snowflake involving building data applications.
- ARRAY — A Snowflake data type representing an ordered list of values, accessed by zero-based index.
- Cloud services layer — Coordinates authentication, query optimization, metadata management, ACID transactions, Time Travel, zero-copy cloning, and caching.
- Compute layer — Uses virtual warehouses for scalable compute, supporting SQL, Python, Java, and Snowpark workloads.
- COPY INTO — A SQL command used to load data from a stage into a Snowflake table.
- CREATE OR REPLACE TABLE — A SQL command that drops an existing table and creates a new one with the same name.
- CURRENT_TIMESTAMP — A Snowflake function that returns the current timestamp.
- Data Cloud — Snowflake's term for a platform and ecosystem intended to reduce data silos and enable governed access to data, applications, and models across teams and organizations.
- Data sharing — A governed mechanism to share data between Snowflake accounts without copying the underlying data.
- Date & Time — A data type category in Snowflake including DATE, TIME, TIMESTAMP, etc.
- DATEADD — A SQL function that adds or subtracts a specified time interval from a date or timestamp.
- Django Snowflake connector — A framework-specific connector that integrates Snowflake with Django-style database access patterns.
- Document AI — Snowflake feature that extracts structured data from documents using AI.
- Event Table — A Snowflake table that stores telemetry (logs, trace events, errors) generated by Snowflake code for observability.
- Fail-safe — A Snowflake-managed disaster recovery period after Time Travel ends, not directly accessible by users.
- Hybrid Tables — Snowflake tables that support transactional-style workloads alongside analytical access patterns.
- Kafka connector — A connector for streaming ingestion from Apache Kafka into Snowflake.
- LAST_QUERY_ID — A Snowflake function that returns the ID of the last executed query in the session.
- LATERAL FLATTEN — A Snowflake table function that expands arrays or objects into multiple rows.
- Logical — A data type category in Snowflake including BOOLEAN.
- Materialized View — A view that stores precomputed results for read performance, but with restrictions like single-table only.
- Notification — A Snowflake feature that sends notifications (e.g., emails) through configured integrations and system procedures.
- Numeric — A data type category in Snowflake including NUMBER, INT, FLOAT, DOUBLE, with many aliases resolving to the same type.
- OBJECT — A Snowflake data type representing key-value data, similar to a dictionary or map.
- Permanent table — A Snowflake table type that persists until dropped, supports Time Travel up to 90 days, and has a 7-day Fail-safe period.
- Privileges — Permissions to perform actions on securable objects, like USAGE, SELECT, and OWNERSHIP.
- PUBLIC — A default schema automatically created in every new Snowflake database.
- Roles — Collections of privileges that can be granted to users to simplify permission management.
- Securable objects — Snowflake objects (e.g., warehouse, database, schema) whose access can be controlled with privileges.
- Secure View — A view that hides its definition from unauthorized users, used for data privacy.
- SECURITYADMIN — A Snowflake role for security-related administration, managing grants, roles, and security policies.
- Session Variable — A variable set at the session level using SET, referenced with $ prefix.
- SHOW PROCEDURES — A command that lists all stored procedures in the current account or schema.
- Snowflake Connector for Python — A connector for connecting Python applications to Snowflake.
- Snowflake Copilot — An AI assistant in Snowsight that allows users to ask questions in natural language, generate SQL, and refine SQL through follow-up prompts.
- SNOWFLAKE database — A system database automatically present in every Snowflake account, containing schemas like ACCOUNT_USAGE for observability data.
- Snowflake Marketplace — A platform for discovering and distributing datasets, applications, and models between organizations.
- Snowflake Model Registry — A service for storing, versioning, and managing trained machine learning models within Snowflake.
- Snowflake Native App Framework — A framework for packaging and distributing applications to Snowflake customers via the Marketplace.
- Snowflake Node.js driver — A driver for connecting Node.js applications to Snowflake.
- Snowflake Notebook — A feature within Snowflake for running code snippets and assignments.
- Snowflake Python API — An API for programmatically managing Snowflake objects like databases and warehouses.
- Snowflake Scripting — A procedural language extension for Snowflake that supports DECLARE, BEGIN, EXCEPTION, and END blocks.
- Snowflake session — An active connection to Snowflake that allows querying and data manipulation.
- Snowflake Users — Identities that can log in and activate roles to perform actions in Snowflake.
- SNOWFLAKE_SAMPLE_DATA — A sample database included in trial accounts with sample datasets across multiple schemas.
- SNOWFLAKE.ACCOUNT_USAGE.TABLE_STORAGE_METRICS — An account-level view that provides storage metrics for tables.
- Snowgrid — Cross-cloud and cross-region layer enabling data sharing, replication, failover, and business continuity across AWS, Azure, and GCP.
- Snowpark Container Services — A service for hosting custom application components inside Snowflake-managed infrastructure.
- Snowpark-optimized warehouses — Snowflake compute resources designed for memory-intensive ML workloads.
- Standard View — A saved SQL query that does not store results; Snowflake evaluates it when queried.
- Storage Integration — A Snowflake object that allows access to external cloud storage through a configured cloud identity.
- Stream — A Snowflake object that tracks changes (inserts, updates, deletes) to a table, enabling incremental processing.
- String & Binary — A data type category in Snowflake including VARCHAR, STRING, TEXT, which are identical.
- SYSADMIN — A Snowflake role for system object administration, managing warehouses, databases, and objects.
- Table — A structured data object in Snowflake that stores rows and columns.
- Task — A Snowflake object that runs SQL logic on a schedule or as part of a task graph, often used with streams for incremental pipelines.
- Task Graph — A directed acyclic graph view of task dependencies in Snowflake, used for understanding task order and debugging pipelines.
- Tasty Bytes — A fictional food truck company dataset created by Snowflake for training purposes.
- Temporary table — A Snowflake table type that exists only for the current session, with limited Time Travel and no Fail-safe.
- Transient table — A Snowflake table type that persists until dropped but has limited Time Travel (0-1 day) and no Fail-safe protection.
- TYPEOF — A Snowflake function to inspect the data type of a VARIANT value.
- UDF — A user-defined function that returns a single scalar value.
- UNDROP TABLE — A SQL command to restore a recently dropped table.
- Universal Search — A natural-language search feature in Snowsight that searches across Snowflake objects, Marketplace listings, documentation, and community resources.
- USERADMIN — A Snowflake role for user and role management, with privileges to create users and roles.
- VARIANT — A Snowflake data type for storing semi-structured data such as JSON.
- Zero-copy sharing — Snowflake's sharing model that allows consumers to query shared data without copying it into their own account, reducing duplication.
Connections
- Uses Snowflake Node.js driver
- Uses Snowflake Connector for Python
- Related to Data Cloud
- Related to Data governance
- Related to Builder
- Uses Kafka connector
- Related to Data sharing
- Related to Snowpark Container Services
- Uses Django Snowflake connector
- Uses Snowflake Python API
- Uses Snowpark-optimized warehouses
- Related to Snowflake Scripting
- Related to Stored Procedure
- Related to IAM Role
- Related to COPY INTO
This is the text view of an interactive 3D knowledge graph — open this page with JavaScript enabled to explore it visually.