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.