Microsoft OneLake integration
Your models, in Microsoft OneLake.
A built-in ingestr destination: load modelled tables into Microsoft OneLake.
name: out.microsoft_onelake
type: ingestr
parameters:
source_connection: postgres
source_table: analytics.daily_revenue
destination: microsoft_onelake$ bruin run assets/out/microsoft_onelake.asset.yml
- extract · postgres analytics.daily_revenue
- load · Microsoft OneLakereplace
Delivered to Microsoft OneLake.
How it connects
Connected in three steps.
OneLake is the unified, lake-centric storage layer of Microsoft Fabric. It exposes an ADLS Gen2-compatible endpoint at onelake.dfs.fabric.microsoft.com, where each workspace acts as a container and items (Lakehouses, Warehouses, …) live underneath it. It can write to either area of a Lakehouse:
- 01
Add a Microsoft OneLake connection.
- 02
Point an ingestion asset at Microsoft OneLake as its destination.
- 03
Bruin loads it on your schedule and checks every load.
Connection parameters
- workspace
- the Fabric workspace name or GUID (the first path segment)
- lakehouse
- the Lakehouse name or GUID (the second path segment). A .Lakehouse item suffix is added automatically unless the value is a GUID or already contains a . — Fabric addresses items by GUID with no type suffix. Pass an explicit suffix (e.g. mywh.Warehouse) to target a different item type.
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
01 · Move
02 · Model & govern
03 · Use
Frequently asked
Questions about Microsoft OneLake.
Does Bruin have a built-in Microsoft OneLake integration?
Yes. Built-in ingestr destination.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect Microsoft OneLake?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.