Snowflake
Core Concepts Every Data Engineer Should Know
Oct 20, 202525 min read
Pinned
Command Palette
Search for a command to run...
Latest articles
The Ultimate SQL vs PySpark Syntax Guide
Sample Dataset (Master Table for Entire Blog) We’ll use two tables because many SQL operations (joins, aggregates, window functions) need multiple datasets. EMPLOYEES Table emp_idnameagedepartmentsalaryjoin_date 1John30HR500002020-01-15 2Smit...
Nov 16, 202520 min read
Learning PySpark with Databricks
A Beginner-Friendly Guide to PySpark
Nov 1, 202537 min read
Pandas and Numpy in PYTHON
Mastering Pandas: The Ultimate Beginner’s Guide to Data Handling in Python Data is everywhere — but raw data is messy, inconsistent, and rarely ready for analysis.This is where Pandas comes to the rescue. Pandas is a Python library for data manipul...
Oct 20, 202510 min read
SQL (Structured Query Language)
SQL Basics What is SQL? SQL (Structured Query Language) is the standard language used to interact with relational databases. It allows you to create, read, update, and delete data (CRUD operations) efficiently. Key points: SQL is declarative, mean...
Oct 18, 202535 min read
MERGE INTO in Snowflake — Complete Guide
The MERGE INTO statement in Snowflake is a powerful DML command used to synchronize data between a target table and a source table.It combines INSERT, UPDATE, and DELETE operations into one single statement. Types of MERGE Operations in Snowflake Th...
Sep 6, 20255 min read
Streams and Tasks in Snowflake
STREAMS In Snowflake, streams (or stream objects) are used to track data changes in a table over time. They’re a Change Data Capture (CDC) mechanism that lets you identify inserts, updates, and deletes that occur on a source table since the last ti...
Sep 5, 20256 min read
Snowflake Data Masking & Column-Level Security — A Complete Guide with Examples
Data security is a critical part of modern data engineering, and Snowflake provides powerful features to protect sensitive information at scale. In this blog, we’ll explore Column-Level Security, Dynamic Data Masking, Conditional Data Masking, and Ta...
Sep 3, 20254 min read
Ways of Loading Data in Snowflake
Snowflake offers multiple ways to load data depending on your use case, data size, and the tools you’re comfortable with. 1️⃣ Loading Data from Snowflake Marketplace The Snowflake Marketplace provides free and paid datasets from various providers. Yo...
Aug 10, 20258 min read