Azure SQL Database (beta)
Connection overview. Requires: CLI v0.70.2 and Data Collector v16221 or newer
Integrating Monte Carlo with your Azure SQL Database allows you to monitor your data assets through custom SQL monitors, which can be created in either the UI wizard and/or programmatically via monitors as code (API/SDK too). These monitors can be used to generate notifications (incidents) to relevant stakeholders and circuit break pipelines.
Integration Setup
To connect Monte Carlo to a Azure Dedicated SQL Pool, follow these steps:
- Enable network connectivity between the database and Monte Carlo's data collector.
- Create a read-only service account for your Dedicated SQL Pool.
- Provide service account credentials to Monte Carlo (requires Using the CLI).
1. Enable network connectivity
Follow the Network Connectivity guide to IP Allowlist or VPC peer to provide access to Azure Synapse.
2. Create a read-only service account
Prerequisites
To create a readonly service account, you will need access to a SQL admin user.
Connect to the master
database as the SQL admin and run:
CREATE LOGIN montecarlo WITH PASSWORD = '<password>';
Connect to the Dedicated SQL Pool database as the SQL admin and run:
CREATE USER montecarlo FROM LOGIN montecarlo;
EXEC sp_addrolemember 'db_datareader', 'montecarlo';
3. Provide service account credentials to Monte Carlo
- Please follow this guide to install and configure the CLI.
- Please use the command
montecarlo integrations add-azure-sql-database
to connect. For reference, see help here.
montecarlo integrations add-azure-sql-database \
--host myservername.database.windows.net \
--port 1433 \
--user montecarlo \
--password -1 \
--database mydbname \
--name name_for_dedicated_sql_pool_connection_in_mc
Monitor Support
Below are the supported monitors for the Azure Synapse integration today. Please reach out to your Monte Carlo representative if you have requirements for additional Monitors.
Category | Monitor Type | Support |
---|---|---|
Automated Anomaly Detection | Freshness | |
Automated Anomaly Detection | Volume | |
Automated Monitoring | Schema Changes | |
Opt-in Monitor | SQL Rule | |
Opt-in Monitor | Comparison Rule | |
Opt-in Monitor | Field Quality Rule | |
Opt-in Monitor | Freshness Rule | |
Opt-in Monitor | Volume Rule | |
Opt-in Monitor | Volume Anomaly Detection | |
Opt-in Monitor | Field Health Monitor | |
Opt-in Monitor | Dimension Tracking | |
Opt-in Monitor | JSON Schema Changes |
FAQs
What hosting solutions are supported?
This integration supports any instance that is reachable from the AWS cloud (e.g. AWS hosted, site-to-site VPN with AWS, publicly accessible, etc). Please see the networking docs for more detail.
Updated 5 months ago