Chayan Shrang Raj – Medium

Chayan Shrang Raj

Pinned

Chayan Shrang Raj

Data Modeling — Basics

Have you tried this in Data Modeling?

Nov 15, 2023

Data Modeling — Basics

Nov 15, 2023

Chayan Shrang Raj

SQL Window Functions and CTEs

Window functions are significantly different from other available SQL functions and keep a special place in a Data Engineer’s heart. It is…

May 8

SQL Window Functions and CTEs

May 8

Chayan Shrang Raj

Using OpenAI API and LangChain to assist exploratory data analysis

By now, we are sufficiently aware of the capabilities offered by Generative AI and its use cases across various industries. It is a…

Jan 22

Using OpenAI API and LangChain to assist exploratory data analysis

Jan 22

Chayan Shrang Raj

Deep dive into table indexing in Azure Dedicated SQL Pools (Azure SQL DW)

It is important to understand the concept of indexing as designing efficient indexes is paramount to achieving good database and…

Dec 29, 2023

Deep dive into table indexing in Azure Dedicated SQL Pools (Azure SQL DW)

Dec 29, 2023

Chayan Shrang Raj

Deep dive into design choices for table distributions in Azure Dedicated SQL Pool (SQL DW)

A cloud data warehouse represents a contemporary approach to storing and overseeing extensive datasets within a public cloud environment.

Dec 19, 2023

Deep dive into design choices for table distributions in Azure Dedicated SQL Pool (SQL DW)

Dec 19, 2023

Chayan Shrang Raj

Continuous data ingestion with Snowpipe Auto Ingest and Snowpipe REST API in Snowflake (AWS)

As we learned about COPY INTO command in the previous article, there are some trade-offs that need to be balanced between using Snowpipe…

Dec 16, 2023

Continuous data ingestion with Snowpipe Auto Ingest and Snowpipe REST API in Snowflake (AWS)

Dec 16, 2023

Chayan Shrang Raj

Data Ingestion with COPY INTO in Snowflake (Local file, AWS, Azure, GCP)

Enterprises are experiencing an explosive growth in their data estates and are leveraging high performant and cost effective data solutions…

Dec 9, 2023

Data Ingestion with COPY INTO in Snowflake (Local file, AWS, Azure, GCP)

Dec 9, 2023

Chayan Shrang Raj

Data Warehouse and Dimensional Data Modeling

In my previous Data Modeling — Basics blog, we discussed about how an organization collects the data, which is, operational data (everyday…

Nov 28, 2023

Data Warehouse and Dimensional Data Modeling

Nov 28, 2023

Chayan Shrang Raj

Idiosyncrasies of Data Source Systems

How is a data element born?

Nov 12, 2023

Idiosyncrasies of Data Source Systems

Nov 12, 2023

Chayan Shrang Raj

Worth the smile..

I am writing this post after a recollection earlier today which took me back to one of the emotional experiences of my life. After all…

Mar 7, 2022

Worth the smile..

Mar 7, 2022

Chayan Shrang Raj

Chayan Shrang Raj

Learning by writing. Writing by experiencing. Experiencing by taking action. GitHub - https://github.com/chayansraj

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams