AI & Data
Snowflake SnowPro Core: Query Performance Tuning
Snowflake removes much of the traditional database administration around indexes and static partitions, but it does not remove the need…
Explore / Technology subjects
AI & Data
Data engineering, analytics, databases, machine learning, artificial intelligence and AI systems.
The reading room
All insights
Latest in AI & Data
139 published articles in this category.
AI & Data
Snowflake SnowPro Core: Secure Data Sharing
Snowflake Secure Data Sharing allows providers to expose selected database objects to other Snowflake accounts without copying the underlying data…
AI & Data
Snowflake SnowPro Core: Snowflake Cost Control & Resource Monitors
Snowflake cost control begins with understanding where credits and storage are consumed. Virtual warehouses are user-managed compute, serverless services such…
AI & Data
Snowflake SnowPro Core: Snowflake Roles & Access Control
Snowflake access control combines roles, privileges, ownership, and object hierarchy so users and services can perform only the work they…
AI & Data
Snowflake SnowPro Core: Snowflake Warehouses & Workload Isolation
Snowflake separates storage from compute through virtual warehouses. Each warehouse is an independent compute cluster, so one warehouse's CPU and…
AI & Data
Snowflake SnowPro Core: Snowpipe and Continuous Data Ingestion
Snowpipe is Snowflake's managed service for loading files from cloud storage into tables as they become available. Instead of waiting…
AI & Data
Snowflake SnowPro Core: Snowflake Storage, Compute & Cloud Services
Snowflake's architecture separates persistent data storage, compute, and cloud services into distinct layers. This separation explains many of the platform's…
AI & Data
Snowflake SnowPro Core: Snowflake Streams & Tasks
Streams and Tasks are core Snowflake building blocks for incremental data pipelines. A stream records change data capture information for…
AI & Data
Snowflake SnowPro Core: Zero-Copy Cloning and Time Travel
Snowflake Time Travel and zero-copy cloning make historical data and isolated copies available without traditional full-copy workflows. Time Travel preserves…
AI & Data
Snowflake Advanced Data Engineer: ELT Pipelines
ELT pipelines load data into Snowflake before applying most transformation logic inside the platform. This approach takes advantage of scalable…
AI & Data
Snowflake Advanced Data Engineer: Snowflake Dynamic Tables
Snowflake Dynamic Tables let data engineers define the result they want with a SELECT statement and let Snowflake manage refresh…
AI & Data
Snowflake Advanced Data Engineer: Snowpark for Data Engineering
Snowpark brings DataFrame-style programming into Snowflake so engineers can build transformations in languages such as Python while keeping execution close…
AI & Data
Databricks Data Engineer Associate: CI/CD for Data Engineering
CI/CD for data engineering is the practice of treating notebooks, Python packages, SQL, job definitions, pipeline resources, tests, and environment…
AI & Data
Databricks Data Engineer Associate: Lakehouse Architecture
A lakehouse architecture combines data-lake scale and openness with warehouse-style reliability, governance, and analytics. On Databricks, the architecture is not…
AI & Data
Databricks Data Engineer Associate: SQL Warehouses for Analytics
Databricks SQL warehouses provide managed compute for SQL analytics, dashboards, BI tools, and ad hoc queries over lakehouse data. The…