Chetan Gupta articles - 14 total
Navigating the Landscape of Data-Modeling – A Comprehensive Guide
From third-normal-form warehouses to hash-key vaults and one-big-table lakehouses, questions needs to...
Unlocking the Secrets of SQL Window Functions
A Comprehensive Guide to SQL Window Functions: With Examples Introduction to SQL...
Journey Through Spark SQL
Journey Through Spark SQL: A Behind-the-Scenes Adventure Introduction Have you ever...
Airflow vs. Dagster: Orchestration Story for your Data Platform
Airflow vs. Dagster: Choosing the Right Orchestration Tool for Your Data Platform In the...
Tracking Data Over Time: Slowly Changing Dimensions (SCD)
Slowly Changing Dimensions (SCD) in Data Warehousing In the world of data warehousing and...
Empowering Healthcare with Data: Choosing the Best Platforms for Advanced Analytics
Choosing the Best Data Platform for Healthcare Data: HL7, EHR, ADT Messages, Orders, and...
Understanding OLTP and Choosing the Right Database
Understanding OLTP and Choosing the Right Database for Your Transactional Workloads ...
Snowflake vs. Databricks vs. AWS Redshift
Snowflake vs. Databricks vs. AWS Redshift: Choosing the Right Data Platform for Your...
Understanding Data Schemas
A Detailed Guide for Data Schemas with Visual Representations In the world of data...
Understanding Data Schemas
In data warehousing and database management, different kinds of schemas are used to organize and...
Data Showdown: OLAP vs. OLTP – The Battle of Real-Time and Analytics Titans
OLAP versus OLTPs In the world of databases, two primary processing systems dominate the...
Mastering Scalable Data Warehousing on AWS: From S3 to Semantic Layers with AtScale
As organizations scale, they generate massive volumes of data that need to be ingested, stored,...
An End-to-End Guide to dbt (Data Build Tool) with a Use Case Example
Introduction In modern data engineering, creating scalable and manageable data pipelines...
Comprehensive Guide to Schema Inference with MongoDB Spark Connector in PySpark
When working with MongoDB and Apache Spark, you might encounter situations where the MongoDB Spark...