Azure SQL Database integration
Azure SQL Database data, in your warehouse.
A built-in ingestr connector: add credentials, pick tables, schedule it.
name: raw.table
type: ingestr
parameters:
source_connection: azure_sql_database
source_table: '<table>'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/azure_sql_database.asset.yml
- extract · Azure SQL Database dataincremental
- load · snowflake raw.datamerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
Azure SQL Database is Microsoft's managed SQL Server database service.
- 01
Add a Azure SQL Database connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
Connection parameters
- user
- SQL username, Microsoft Entra username, managed identity client ID, or service principal client ID
- password
- SQL password, Microsoft Entra password, access token, or service principal secret
- host
- Azure SQL server host, usually <server>.database.windows.net
- port
- optional, defaults to 1433
- database
- the database to read from
- encrypt
- optional, defaults to true
- fedauth
- optional Microsoft Entra authentication workflow
- tenantid
- optional tenant ID; with service principal auth, ingestr appends it to the client ID as clientid@tenantid
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 Azure SQL Database.
Does Bruin have a built-in Azure SQL Database integration?
Yes. Built-in ingestr source.
Where can Azure SQL Database data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
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 Azure SQL Database?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.