---
title: "Harshita Chaudhary (@harshita0812) | Hashnode"
description: "Software Engineer - Data. Read the latest articles by Harshita Chaudhary on Hashnode."
url: "https://hashnode.com/@harshita0812"
---

@harshita0812

# Harshita Chaudhary

@harshita0812 · India · Joined August 2022

Software Engineer - Data

### [Create ADLS External Tables in Azure Synapse](https://harshita.hashnode.dev/create-adls-external-tables-in-azure-synapse?utm_source=hashnode&utm_medium=feed)

Create a Master Key if not present. Why? If a database scoped credential is used, Synapse requires encryption. The Master Key ensures that credentials are securely stored. ✅ Needed only once per database. ✅ Required for setting up authe...

2 min read · [harshita.hashnode.dev](https://harshita.hashnode.dev/create-adls-external-tables-in-azure-synapse?utm_source=hashnode&utm_medium=feed)

[Feb 24, 2025](https://hashnode.com/posts/create-adls-external-tables-in-azure-synapse/67bc5eb601c6e25bf246ae41)

### [SQL : Store Procedures Versus Functions](https://harshita.hashnode.dev/sql-store-procedures-versus-functions?utm_source=hashnode&utm_medium=feed)

SQL stored procedures and functions are versatile tools in SQL that allow users to develop reusable and optimized code for handling intricate database tasks. They allow users to bundle a set of SQL statements into a single, executable unit that can b...

3 min read · [harshita.hashnode.dev](https://harshita.hashnode.dev/sql-store-procedures-versus-functions?utm_source=hashnode&utm_medium=feed)

[Sep 24, 2024](https://hashnode.com/posts/sql-store-procedures-versus-functions/66f2abf13bcfd5e6cd7a708d)

### [Slowly Changing Dimensions with PySpark and Delta Lake](https://harshita.hashnode.dev/slowly-changing-dimensions-with-pyspark-and-delta-lake?utm_source=hashnode&utm_medium=feed)

Slowly Changing Dimensions (SCDs) are a vital concept in data warehousing, particularly in managing data that changes over time. As the entities evolve over time, it’s crucial to track and manage these changes effectively. This is where Slowly Changi...

2 min read · [harshita.hashnode.dev](https://harshita.hashnode.dev/slowly-changing-dimensions-with-pyspark-and-delta-lake?utm_source=hashnode&utm_medium=feed)

[May 30, 2024](https://hashnode.com/posts/slowly-changing-dimensions-with-pyspark-and-delta-lake/665855d5658e97e981127529)

### [Databricks Overview](https://harshita.hashnode.dev/databricks-overview?utm_source=hashnode&utm_medium=feed)

What is Databricks? Databricks, developed by the creators of Spark, offers a comprehensive solution for all data needs. From storage to insights via SparkSQL, visualization with tools like Tableau and PowerBI, to model building with SparkML, it serve...

3 min read · [harshita.hashnode.dev](https://harshita.hashnode.dev/databricks-overview?utm_source=hashnode&utm_medium=feed)

[Mar 30, 2024](https://hashnode.com/posts/databricks-overview/6607e19ffdf66a68fc205512)

### [Delta Lake - Introduction and Architecture](https://harshita.hashnode.dev/delta-lake-introduction-and-architecture?utm_source=hashnode&utm_medium=feed)

A Delta Lake is not different from a Parquet file with a robust versioning system. It utilizes transaction logs stored in JSON files to maintain a comprehensive change history for the file. This allows us to not only access previous versions but also...

3 min read · [harshita.hashnode.dev](https://harshita.hashnode.dev/delta-lake-introduction-and-architecture?utm_source=hashnode&utm_medium=feed)

[Jan 7, 2024](https://hashnode.com/posts/delta-lake-introduction-and-architecture/659a806ae13b4708f7074638)
