Skip to content

We've combined years of real world experience, with the the latest Microsoft Big Data platforms and tools to create a set of modern data platform blueprints, designed to get you up and running quickly, at scale and with confidence.

Our experience shows most projects fit into one of four tiers of services and data sizes.

Our blueprints encapsulate the learnings of thousands of hours solving real-world data problems for our customers across a wide range of industries.

We help our customers to develop their technology strategy, built on deep insight from their data, engineered securely and efficiently in the cloud.

Read our Analytics blogs

View all Analytics posts (115)

Endjin are Microsoft Gold Partners for Data Platform and Data Analytics.

Big Data LDN: highlights and how to survive your first data conference

Big Data LDN: highlights and how to survive your first data conference

Elisenda Gascon

Here are some of the highlights form this year's Big Data LDN conference.
Customizing Lake Databases in Azure Synapse Analytics

Customizing Lake Databases in Azure Synapse Analytics

Ed Freeman

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
What is a Lake Database in Azure Synapse Analytics?

What is a Lake Database in Azure Synapse Analytics?

Ed Freeman

Lake Databases in Azure Synapse Analytics are just great. If you're starting on a new Synapse Analytics project, chances are you can benefit from Lake Databases. Whether you need to analyze business data from Dataverse, share your Spark tables of data with SQL Serverless, or use Database Templates to visually design and define your standardized/semantic analytical data model, there's a use-case for you. In this blog we'll explore what Lake Databases are, why they're useful, and what you need to watch-out for when using them.