Loading...

Customizing Lake Databases in Azure Synapse Analytics

Customizing Lake Databases in Azure Synapse Analytics
Great, so I've configured my Lake Database in Azure Synapse Analytics. But since I'm using parquet-backed files, my column names aren't very user-friendly. I also have these calculated columns incorporating business logic that I'd like to query on the fly rather than persist them to backing data. I also want to give specific end-users access to this database and provide them with pre-defined reporting queries to get them up and running as quickly as possible. How can I do this? Enter Custom Objects in Lake Databases - now you can create VIEWs, Stored Procedures, USERs (amongst other objects) in what used to be a read-only database. This article explores the customization options and how it can help you organize your reporting data in Azure Synapse Analytics

Published on:

Learn more
endjin.com
endjin.com

We help small teams achieve big things.

Share post:

Related posts

AI agents, meet the Azure Cosmos DB vNext emulator

If you use the Azure Cosmos DB vNext emulator, you probably know the local development loop: start the emulator, connect to it, create some re...

13 hours ago

Building a Complete Business Application Using C#, Azure, and Power Platform (2026 Guide)

Introduction Modern businesses need applications that are scalable, secure, intelligent and capable of adapting to rapidly changing business r...

23 hours ago

Creating AI-Powered Power Apps Using Azure OpenAI (2026 Guide)

Introduction Artificial Intelligence is rapidly transforming the way businesses build applications. Traditional business apps required users t...

2 days ago

How to Integrate ChatGPT with Dynamics 365 Using Azure Functions (Complete 2026 Guide)

Introduction Artificial Intelligence is transforming enterprise applications, and Microsoft Dynamics 365 is no exception. Businesses are incre...

3 days ago

How to build long-running MCP tools on Azure Functions

Learn how to build long-running MCP tools on Azure Functions using Durable Functions. This post explains why synchronous tool calls break down...

4 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy