Skip to content
Prodata

Prodata

SQL Centre Of Excellence

  • Home
  • Services
    • Synapse and EDW
    • SSAS Services
    • Power BI
    • SQL Server Platform
  • Blogs
  • Offerings
  • About Us
    • History and Verticals
    • Team
    • Contact
    • Jobs at Prodata

Category: Uncategorized

Uncategorized

Connecting to Fabric using SqlClient

Microsoft Fabric doesnt yet support SqlLogins, but you can still connect programatically by using the Azure.Identity Classes which support both Managed Identity (if run from somewhere supporting that), or Visual Studio authentication if in debug or unit test mode. The examples below are c#, but similar works in Python too. Below is a code sample … Continue reading Connecting to Fabric using SqlClient

July 11, 2023July 11, 2023Leave a comment
Uncategorized

Real move on Data Lake using Rest API on ADF

There are many times where I've needed to move a file using Azure's Data Factory and found it weird that the only native option provided is to copy the file, then delete it. Many reading know that disk level renames are actually almost instantaneous (just a rewrite the the files metadata / partition tree). Costs … Continue reading Real move on Data Lake using Rest API on ADF

November 28, 2022November 28, 2022Leave a comment

Posts navigation

Older posts
  • Facebook
  • Twitter
  • LinkedIn
Prodata
Proudly powered by WordPress Theme: Shoreditch.