Feed
Discussions

azure-synapse-analytics

azure-synapse-analytics

#azure-synapse-analytics

16 followers·14 articles

azure-synapse-analytics

#azure-synapse-analytics·16 followers·14 articles

azure-synapse-analytics

Changelog

New steps component and improved accessibility on Hashnode's blog and docs product.

Nov 05, 2024·

new

Trending Articles

Understanding the Go Compiler: From Source Code to Execution

Arya M. Pathak·75 reads

XBanking: A Catalyst for Financial Inclusion

Edidiong Umana·17 reads

10 Bash scripts that every beginner DevOps engineer can use to automate workflows

Shaik Mustafa·44 reads

Top commenters this week

Itoro Samuel

Ananya Sharma

Saanvi Kumar

Issy

José Pablo Ramírez Vargas

José Pablo Ramírez Vargas

Writing Challenges

#2Articles1Week Challenge

Become better at technical writing; accept Hashnode's writing challenge for four weeks.

#2Articles1Week Challenge

#WomenWhoTech

Share your story, achievements, or experiences as a woman, non-binary folk in tech or as a #WomenWhoTech ally!

#WomenWhoTech

Self Starter

Publish your first article on Hashnode and become a self starter!

Self Starter

Serial Blogger

Publish an article every day for 7 days and earn a cool serial blogger badge!

Serial Blogger

Talk of the town

Write a story that drives amazing engagement on Hashnode and become the talk of the town!

Talk of the town

Word Warrior

Write an in-depth article on your Hashnode blog that's more than 2000 words and become a word warrior!

Word Warrior

Siddhesh Prabhugaonkar

Siddhesh Prabhugaonkar

cloud-authority.com·Nov 03, 2024

Nov 03, 2024

Azure Synapse Analytics: Partition vs Distribution

While using Azure Synapse Analytics dedicated SQL pools, sometimes it is confusing the purpose of partitioning and distribution. They are both used to manage data for performance optimization, but serve different purposes. Distribution Distribution r...

Azure Synapse Analytics: Partition vs Distribution

Discuss·14 reads

partition vs distribution

Mehul Kansal

mehulkansal.hashnode.dev·Sep 30, 2024

Sep 30, 2024

Week 18: Azure Synapse Key Concepts 🔑

Hey data folks! 👋 This week’s blog explores how to provision and use key features like Serverless SQL Pools, Dedicated SQL Pools, and Apache Spark Pools within an Azure Synapse workspace. We’ll dive into creating external tables, loading data from A...

Week 18: Azure Synapse Key Concepts 🔑

Discuss·20 reads

SAI GOUTHAM

gouthamcodes.hashnode.dev·Sep 25, 2024

Sep 25, 2024

Olympics Data Analytics using Azure Databricks and PowerBI

So I have followed the video of Darshil Parmer and have made this project and heres the link for that video click here. This project is divided into 2 parts Part-1 consists of whole data ingestion and transformation. Part-2 concists of the dashboar...

Olympics Data Analytics using Azure Databricks and PowerBI

Discuss·25 reads

Emma C.

emmacdata.hashnode.dev·Mar 03, 2024

Mar 03, 2024

Building an Azure Synapse Studio Data Pipeline for Profit Calcuation Analysis

In this project, I'll walk through the process of creating a Azure Synapse Studio data pipeline focused on calculating total profits from the classic Superstore dataset, sourced from Tableau. Our goal is to obtain region-wise profit insights, specifi...

Building an Azure Synapse Studio Data Pipeline for Profit Calcuation Analysis

Discuss·10 reads

KUNAL DAS

kunaldas.hashnode.dev·Jan 26, 2024

Jan 26, 2024

Streamlining Synapse CI/CD & Dedicated SQL pool with Azure DevOps

Reach at : https://heylink.me/kunaldas Streamlining Synapse CI/CD & Dedicated SQL pool with Azure DevOps: Best Practices and Implementation Tips What is Synapse Analytics? what is the need for CI-CD for synapse analytics? What are the different c...

Streamlining Synapse CI/CD & Dedicated SQL pool with Azure DevOps

Discuss·21 reads

Akshay Kumar R

akshaykumarr.hashnode.dev·Jan 26, 2024

Jan 26, 2024

Azure Synapse Analytics: Keyvault Access

Pre-requisite: You already have an Azure Keyvault set up, with the secrets defined. Access Secrets in Synapse Notebook Provide GET, List permissions for the new Synapse Workspace/ its UAMI under Access Policies in the Key Vault Create a new lin...

Discuss·12 reads

azure-synapse-analytics

Akshay Kumar R

akshaykumarr.hashnode.dev·Jan 26, 2024

Jan 26, 2024

Azure Synapse Analytics: Continuous Deployment

Some steps you need to cover in the Azure Synapse Workspace: In your Synapse notebook, create a new cell and toggle parameter cell, this is for variables that would be picked from pipeline parameters, if needed. Once done, it would look like this C...

Discuss·14 reads

azure-synapse-analytics

Anshul Mathur

anshulmathur.hashnode.dev·Sep 30, 2023

Sep 30, 2023

Azure Synapse Analytics cost optimizations

image generated using Bing Image Creator Recently I undertook a task for cost optimization on Azure Synapse Analytics that was incurring a running cost of $200K per month (notice the K at the end). A glance at the resources and you could easily find ...

Azure Synapse Analytics cost optimizations

Discuss·41 reads

Suraj Somani

surajsomani.hashnode.dev·Jun 07, 2023

Jun 07, 2023

Access Azure Database using Azure Active Directory authentication

To enable Active Directory users/apps for accessing SQL Database, SQL Managed Instance, or Azure Synapse, we can follow the steps given below to create AD users in the database and give required permissions to tables, views, external tables, etc. In ...

Access Azure Database using Azure Active Directory authentication

Discuss·15 reads

Ahmed Sayed

amsayed.hashnode.dev·Apr 05, 2023

Apr 05, 2023

ETL from SQL Server to Azure Synapse Analytics with Slowly Changing Dimensions (SCD) Type 2 using Python

Install the required libraries: You’ll need the pyodbc, pandas, and azure-synapse libraries. Install them using pip: pip install pyodbc pandas azure-synapse 2. Connect to SQL Server and extract data: import pyodbc import pandas as pd # Set up your...

ETL from SQL Server to Azure Synapse Analytics with Slowly Changing Dimensions (SCD) Type 2 using Python

Discuss·12 reads

Data Integration

azure-synapse-analytics