SketchMyView Newsletter

SketchMyView Newsletter

Home
Notes
Archive
About
From Flat Files in S3 to Smart Insights: Building a RAG System for Northwind Orders Using Amazon Bedrock and Pinecone
Introduction: Turning Data into Knowledge
 • 
Rakesh Gupta
Extracting Data from MS Fabric Warehouse to AWS S3 - A Practical Data Engineering Example, GenAI Use Case
Introduction
 • 
Rakesh Gupta
File-based Incremental Loading – A Practical Approach with MS Fabric, dltHub, MotherDuck & Python
Context
 • 
Rakesh Gupta

February 2025

Building a Robust Data Analytics with Microsoft Fabric and dbt
Introduction
 • 
Rakesh Gupta
Addressing Data Transformation Challenges: A Strategic Initiative in MS Fabric
Through extensive experience working with diverse consulting clients and teams, I have observed a recurring pattern: the use of multiple notebooks for…
 • 
Rakesh Gupta
Event-Driven Data Ingestion with Microsoft Fabric & dltHub – No More Scheduling Hassles!
Data teams often face the challenge of not being able to directly connect to data sources, forcing raw data to be pushed to landing zones in formats…
 • 
Rakesh Gupta
Setting up ingestion with MS Fabric, dltHub, and Lakehouse
This is the first part of a six-part series on building end-to-end analytics in Microsoft Fabric — without Spark.
 • 
Rakesh Gupta

January 2025

From RTBF to Delta Tables: A Modern Approach to PII in Data Engineering
Handling PII (Personally Identifiable Information) is a critical responsibility in data engineering, especially to comply with GDPR and other regulatory…
 • 
Rakesh Gupta
How to build end to end analytics in Microsoft Fabric using dltHub and duckdb without spark
Microsoft Fabric is an end-to-end data analytics platform that unifies data engineering, integration, warehousing, science, and business intelligence on…
 • 
Rakesh Gupta
Simplifying Data Pipelines and Beyond with dltHub: Insights and Use Cases
Here are the things, I have discovered during dltHub deep dive.
 • 
Rakesh Gupta
dltHub + Edge Analytics + AI Agents = Factory of the Future!
I recently explored how dltHub can revolutionize IIoT edge analytics—and the immense possibilities!
 • 
Rakesh Gupta
Using AWS Bedrock, dltHub and Pinecone to Explore UK Property Data
I recently started exploring the idea of building an AI agent focused on UK government property datasets.
 • 
Rakesh Gupta
© 2025 Rakesh Gupta
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture