Synapse integration
Your models, in Synapse.
A built-in ingestr destination: load modelled tables into Synapse.
name: out.azure_synapse_analytics
type: ingestr
parameters:
source_connection: postgres
source_table: analytics.daily_revenue
destination: azure_synapse_analytics$ bruin run assets/out/synapse.asset.yml
- extract · postgres analytics.daily_revenue
- load · Synapsereplace
Delivered to Synapse.
How it connects
Connected in three steps.
Azure Synapse Analytics is a limitless analytics service that brings together enterprise data warehousing and big data analytics with serverless on-demand or provisioned resources.
- 01
Add a Azure Synapse Analytics connection.
- 02
Point an ingestion asset at Azure Synapse Analytics as its destination.
- 03
Bruin loads it on your schedule and checks every load.
Every way Synapse works with Bruin
- DestinationBuilt-in ingestr destination
- Query engineRuns SQL and Python assetsDocs →
Tables
4 tables, ready to load.
dedicated_pool_tablesserverless_viewsspark_tablesexternal_tables
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
Sources
DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scrapingMove
Data IngestionFrequently asked
Questions about Synapse.
Does Bruin have a built-in Synapse integration?
Yes. Built-in ingestr destination. Runs SQL and Python assets.
Which Synapse tables can Bruin load?
dedicated_pool_tables, serverless_views, spark_tables, external_tables.
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 Synapse?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.