🐘
6 threads
PostgreSQL & Query Optimization
EXPLAIN ANALYZE, indexing strategies, CTE performance, vacuuming, and partitioning.
Topic · SQL & Data Warehousing
SQL & Data Warehousing.
From theory to practice.
Relational database query design, star schema modeling, aggregation logic, and data lakes.
83
Learners
136
Proofs shipped
1
Organizations
9
Problems solved
Subtopics Library
Subtopics in SQL & Data Warehousing
❄️
6 threads
Snowflake & BigQuery Pipeline
Cloud warehouse architecture, dbt transformations, clustering keys, and cost control.
Topic Feed · SQL & Data Warehousing
Latest Threads (Newest First)
R
Thread
Snowflake & BigQuery Pipeline
3 weeks ago
How to build streaming ingestion pipelines into Snowflake using Snowpipe and Kafka?
Build streaming ingestion pipelines into Snowflake from Kafka using Snowpipe and Kafka Connect by preparing Snowflake objects, creating a Snowpipe, configuring the Snowflake Sink Connector, optionally transforming data, and monitoring for optimal performance.
Rajesh Sharma
Score 20
0 replies →
G
Thread
Snowflake & BigQuery Pipeline
3 weeks ago
How to manage data security and dynamic data masking policies in BigQuery and Snowflake?
Implement data security and dynamic data masking in BigQuery using IAM, Column/Row-level Security, and Policy Tags, and in Snowflake with RBAC, Row Access Policies, and Dynamic Data Masking Policies for granular, query-time data protection.
Gaurav Bhasin
Score 24
0 replies →
A
Thread
Snowflake & BigQuery Pipeline
3 weeks ago
What is Snowflake Dynamic Tables and how do they replace manual Airflow DAG orchestration?
Snowflake Dynamic Tables automate in-warehouse ELT by providing declarative, continuously refreshed views that replace external orchestrators like Airflow for many SQL-based data transformations.
Aravind Patel
Score 20
0 replies →