Azure Synapse (beta)

Connection overview. Requires: CLI v0.69.2 and Data Collector v16129 or newer

Integrating Monte Carlo with your Azure Synapse Dedicated SQL Pool allows you to monitor your data and tables. We'll detect anomalous volume changes, schema changes, field-details, and run any further custom SQL monitors.

🚧

Dedicated SQL Pools

Monte Carlo only connects to Azure Synapse Dedicated SQL Pools (formerly SQL DW). If you require additional Azure Synapse support, please fill out the form here.

Integration Setup

To connect Monte Carlo to a Azure Dedicated SQL Pool, follow these steps:

  1. Enable network connectivity between the database and Monte Carlo's data collector.
  2. Create a read-only service account for your Dedicated SQL Pool.
  3. Provide the service account credentials in your Monte Carlo onboarding wizard to validate and complete the integration.

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';

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.

CategoryMonitor TypeSupport
Automated Anomaly DetectionFreshness
Automated Anomaly DetectionVolumeβœ…
Automated MonitoringSchema Changesβœ…
Opt-in MonitorSQL Ruleβœ…
Opt-in MonitorComparison Ruleβœ…
Opt-in MonitorField Quality Ruleβœ…
Opt-in MonitorFreshness Ruleβœ…
Opt-in MonitorVolume Ruleβœ…
Opt-in MonitorVolume Anomaly Detectionβœ…
Opt-in MonitorField Health Monitorβœ…
Opt-in MonitorDimension Trackingβœ…
Opt-in MonitorJSON 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.