Skip to content
October 3, 2025
Newsletter
Random News
Techdiw

Techdiw

  • Home
  • Azure
  • Python
  • About Us
  • Home
  • Azure
  • Python
  • About Us

Category Collection

  • Home
  • Azure
  • Page 2

Category: Azure

  • Azure

What is Delta Table in Synapse Analytics?

diwakar.kumar@techdiw.comMay 4, 2023January 2, 202406 mins

We have seen the solution architecture of the delta lake in our Blog and how we can register a delta table in the Delta Lake. However, this blog will go around the working of the Delta table from the time you register and perform the DML operation on it. We will see internal architecture of…

Read More
  • Azure
  • Python

Read an Excel file in Synapse Notebook using OpenPyxl Library

diwakar.kumar@techdiw.comMarch 12, 202308 mins

Today we are going to see, how to read an excel file which is stored in the Azure Storage from Synapse notebook using python OpenPyxl Library. Openpyxl is the library that is designed to specially work with the Excel files, and it provides rich list of methods to work with the Excel data. However, the…

Read More
  • Azure

Restore Synapse Dedicated SQL Pool Using PowerShell

diwakar.kumar@techdiw.comMarch 11, 2023January 2, 202406 mins

We have seen how to clone the Synapse Dedicated SQL pool using the GUI in our blog https://techdiw.com/cloning-restoration-dedicated-sql-pool-formerly-sql-dw-in-synapse/. We can perform the same action using the PowerShell and make it more generic where it can be used for the Automation and can reuse the code to clone from any source to any target within the…

Read More
  • Azure

Copy File from SharePoint to Azure Storage Using Azure Logic App

diwakar.kumar@techdiw.comFebruary 26, 2023January 2, 202406 mins

There could be the scenario where you want to copy the file that gets upload in SharePoint to your Azure Storage account. I have a scenario where the file from any source will get uploaded in SharePoint folder (it could be a manual upload of dumped by any automatic process) once it is uploaded, we…

Read More
  • Azure

Conditional Activity Run in ADF/Synapse Pipeline

diwakar.kumar@techdiw.comFebruary 19, 202306 mins

In many cases you may expect to run a particular pipeline if a condition is met. To Evaluate the condition and perform some action is most common scenario in Data Engineering field. ADF/Synapse pipeline offers an activity to achieve this, The activity is called the SWITCH activity. This activity can evaluate the condition and perform…

Read More
  • Azure

Cloning/Restoration Dedicated SQL Pool (formerly SQL DW) in Synapse

diwakar.kumar@techdiw.comFebruary 15, 2023December 25, 202308 mins

Today we are going to discuss on how to clone any lower environment dedicated SQL pool with the upper environment dedicated SQL pool or vice versa within a subscription.   There could be the situation if you have lower environments which does not get refreshed every day, but you must clone them with the PROD…

Read More
  • Azure

SPARK Tables in Delta Lake

diwakar.kumar@techdiw.comFebruary 12, 2023January 2, 202405 mins

We saw how to create a database in the synapse SPARK pool in our previous blog. Today we are going to understand the types of Delta table in SPARK. There are mainly two types of SPARK tables. There is slight difference while creating these tables, in a nutshell “Managed” table does not need any Location…

Read More
  • Azure

Registering the Database in Azure Synapse Delta Lake

diwakar.kumar@techdiw.comFebruary 7, 202304 mins

We have seen the overview of the Delta Lake solution Architecture and the operation on the Delta Lake needs to be done using SPARK. So today, we will discuss on the creation of the SPARK db that will serve as the layers in the Delta Lake. It is always good to segregate the layers to…

Read More
  • Azure

Delta Lake Solution Architecture in Azure Synapse

diwakar.kumar@techdiw.comFebruary 7, 2023December 28, 202308 mins

Let’s understand the concept of a Delta Lake Architecture so that later on we can go ahead and understand the concept of the Delta tables in the Delta Lake and their capabilities. The Delta Lake is optimized advance storage layer. The Delta Lake follows the medallion architecture where the tables are segregated in different categories…

Read More
  • Azure

Restore the deleted secret/Key Vault in Azure Key vault

diwakar.kumar@techdiw.comFebruary 1, 202304 mins

This topic is quite rare because no one wants to delete their application or resource’s connection string secret from the key vault especially in PROD where the number of dependencies are quite high. But by mistake it can be mishandled. Always make sure that the below processes are followed as best practice: The main key…

Read More
  • 1
  • 2
  • 3

Recent Posts

  • Query Optimization In Synapse Dedicated SQL Pool
  • Automating Workflows: Triggering Logic Apps from Synapse with Python
  • Managing Synapse Triggers with PowerShell in DevOps
  • A Deep Dive into FileDataLakeClient in Azure Synapse Analytics
  • Resolving Production Self-Hosted Integration Runtime Version Mismatch Issue

Archives

  • June 2024
  • May 2024
  • January 2024
  • September 2023
  • July 2023
  • May 2023
  • March 2023
  • February 2023
  • January 2023

Categories

  • Azure
  • DevOps
  • Python
  • Uncategorized

About Us

Hey Tech Enthusiasts! Welcome to TechDiw, the ultimate hub for learning new
technologies and conquering tech challenges. Born in 2023, Here we share the knowledge which will help others to come out of the mud of technical challenges.

Our Location

Address:
Ranchi, Jharkhand

Social
Follow us via: Facebook, Instagram & Youtube
support@techdiw.com

Quick Links

  • Home
  • About Us
  • Azure
  • Python
TechDiw | Developed by Impulse Web Solution Powered By BlazeThemes.
  • Login
  • Register
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.