Data exports (public preview)

📘

Data exports are in public preview and will be GA in May 2025.

Overview

Monte Carlo's data exports make it easy to access and analyze critical metadata about your your data observability platform. It replaces our legacy "Insights" reports with a more aligned, flexible, and transparent approach to exporting Monte Carlo data.

With data exports, you can retrieve structured information on Monitors, Alerts, Events (the underlying events in an alert), and Assets—directly from the UI, via API/CLI, or through Snowflake data shares. These exports are refreshed daily and mirror what you see in Monte Carlo, allowing for easy integration into internal workflows, self-service reporting, and deep analysis.

📘

Data exports are available to workspaces on the Scale and Enterprise plans.

Key Benefits

  • Rich, structured data for Monitors, Alerts, Events, and Assets
  • Reliable, daily-refreshed exports that match what you see in Monte Carlo
  • Download directly from relevant Monte Carlo product pages for one-off analysis
  • Snowflake data shares available through Monte Carlo customer support

Access methods

MethodDescription
UINavigate to Monitors, Alerts, or Assets pages and download CSVs.
API / CLIFor programmatic access.
SnowflakeAccess shared tables via Snowflake data share. Enable through Monte Carlo customer support.
BigQueryExample script to export from the CLI coming soon.
DatabricksExample notebook to export from the CLI coming soon.

Note: The Alerts export includes both Alerts and their related Events.

CLI

Follow the CLI guide to get set up and see the export CLI docs for more information. Direct download and direct upload to S3 are both options.

Snowflake data share

For Snowflake users, we offer the ability to use data exports via Snowflake's Data Sharing capabilities. This is an opt-in feature, and is available in the following Snowflake data warehouse regions:

AWS: us-east-1, us-east-2, us-west-2, ca-central-1, eu-west-1, eu-central-1, ap-northeast-1, ap-southeast-2

Azure: eastus2, centralus, westeurope, australiaeast, canadacentral

GCP: us-central1, us-east4

Please reach out to support@montecarlodata.com to enable the Snowflake data share.

Migration from Legacy Insights

We're sunsetting the legacy Insights system. Here's what to expect:

  • The Insights tab will be removed from the UI
  • The “Monitored Tables” insight has been moved to Settings → Table monitors
  • Full deprecation will be July 1, 2025. If you have concerns about losing specific insight reports, please reach out to your customer success manager or support@montecarlodata.com.

FAQs

Are exports filtered by domain or audience?

No. Exports include all relevant records. Users restricted to specific domains do not have access to data exports.

Where can I find the export option in the UI?

Look for export/download buttons within the Monitors, Alerts, and Assets pages. There is no centralized "Exports" tab at this time.

How often are exports refreshed?

Daily, roughly between 01:00 - 03:00 UTC. You can generally expect the refresh to be available by 04:00 UTC daily.

Data export schemas

Each export contains a clean, well-documented schema. Fields are consistently named, and join keys are aligned across exports.

Monitors

FieldDescriptionData TypeExample
MONITOR_IDUUID of the monitorSTRING39280e8e-689a-49a8-9ccd-e70b7a7e1bcf
MONITOR_TYPEType of monitor (e.g., validation, custom_sql)STRINGValidation
TITLEMonitor name or descriptionSTRINGSFDC → Account → Account info
PRIORITYPriority levelSTRINGP3
STATUSMonitor statusSTRINGEnabled
SCHEDULEHuman-readable scheduleSTRINGevery 1 week(s) starting at Nov 18th 2024 12:30 UTC
CREATED_ATCreation timestampTIMESTAMP2025-01-02T06:25:13.842Z
CREATED_BYCreator emailSTRINGbhetzel@montecarlodata.com
LAST_MODIFIED_ATLast modified timestampTIMESTAMP2025-01-06T06:25:13.842Z
LAST_MODIFIED_BYLast modifier emailSTRINGbhetzel@montecarlodata.com
AUDIENCESAudience namesLIST["data engineering"]
MONITOR_TAGSCustom tagsLIST["ADDP", "MC-Pilot"]
DATA_QUALITY_DIMENSIONDimension categorySTRINGCompleteness
ASSETAssociated assetsLIST["raw.monolith_export.warehouse_tables"]
ASSET_IDUUIDs of assetsLIST["asset-123"]
DOMAINSAssociated domainsLIST["Prod Analytics", "Gold Datamart"]
MONITOR_URLLink to monitor in UISTRINGhttps://getmontecarlo.com/monitors/...

Alerts

FieldDescriptionData TypeExample
ALERT_IDUUID of the alertSTRING646bb94d-28ec-4ab3-8b2e-283a7bd9e509
MONITOR_IDAssociated monitor IDSTRING6798620c-a44f-432a-b1cd-e68d585852ba
DESCRIPTIONAlert messageSTRINGFreshness anomalies in [snowflake] analytics:prod
CREATED_ATAlert creation timeTIMESTAMP2024-09-26T12:04:50.264Z
STATUSCurrent status (e.g., ACKNOWLEDGED)STRINGFixed
FIRST_RESPONSE_TIMESTAMPTime of first responseTIMESTAMP2024-09-27T12:04:50.264Z
HOURS_TO_FIRST_RESPONSETime to respond (hours)NUMBER24
RESOLVED_TIMESTAMPResolution timeTIMESTAMP2024-09-28T12:04:50.264Z
HOURS_TO_RESOLVEDTime to resolve (hours)NUMBER48
OWNEROwner of the alertSTRINGwrobins@montecarlodata.com
PRIORITYPriority levelSTRINGP3
IS_INCIDENTFlag for incident statusBOOLEANTRUE
SEVERITYSeverity levelSTRINGSEV-2
AUDIENCESTarget audiencesLIST["platform_services", "data-engineering"]
RECIPIENT_CHANNELSNotification channelsLIST["wills-slack-channel", "bhetzel@montecarlodata.com"]
EXTERNAL_LINKSLinked issues (Jira, etc.)LIST["https://sofi.atlassian.net/browse/ST-686"]
DOMAINSAssociated domainsLIST["analytics"]
ALERT_URLLink to alert in UISTRINGhttps://getmontecarlo.com/alerts/...

Events

FieldDescriptionData TypeExample
EVENT_IDUUID of the eventSTRINGe1800f7b-0cc4-4345-93aa-4b64c022a9fe
ALERT_IDLinked alert IDSTRINGe1800f7b-0cc4-4345-93aa-4b64c022a9fe
MONITOR_IDLinked monitor IDSTRING0277dba3-226c-473d-b738-51959a7d097e
ASSET_IDAssociated asset UUIDSTRINGasset-123
DATABASE_NAMESource DBSTRINGraw
SCHEMA_NAMESource schemaSTRINGmonolith_export
ASSET_NAMETable or view nameSTRINGwarehouse_tables
FULL_ASSET_NAMEFull asset pathSTRINGraw.monolith_export.warehouse_tables
EVENT_TYPEType of anomalySTRINGnull_rate
FIELDAffected fieldSTRINGevent_app_url
SEGMENTED_BYSegment dimension or SQLSTRINGproduct_type
SEGMENTSegment valueSTRINGloans
CREATED_ATEvent timestampTIMESTAMP2025-01-07T06:25:13.842Z
ANOMALY_TIMESTAMPTimestamp of anomaly bucketTIMESTAMP2025-01-06T03:00:00.000Z
LOWER_THRESHOLD_VALUELower boundSTRING0
UPPER_THRESHOLD_VALUEUpper boundSTRING.0167
ACTUAL_VALUEObserved valueSTRING.35
SCHEMA_CHANGESChanges to schemaLIST["fields_added: ['audiences']"]
DOMAINSAssociated domainsLIST["equity_domain", "low_carbon_transition"]
EVENT_URLLink to event (if available)STRINGTBD

Assets

FieldDescriptionData TypeExample
ASSET_IDUUID of the assetSTRINGasset-123
SOURCE_NAMEIntegration nameSTRINGsnowflake-staging
DATABASE_NAMESource DBSTRINGraw
SCHEMA_NAMESource schemaSTRINGmonolith_export
ASSET_NAMETable or view nameSTRINGwarehouse_tables
FULL_ASSET_NAMEFull asset pathSTRINGraw.monolith_export.warehouse_tables
ASSET_TYPEObject typeSTRINGView
IMPORTANCE_SCOREAsset importanceNUMBER.99
ASSET_TAGSCustom tagsLIST["critical", "finance"]
DOMAINSAssociated domainsLIST["Gold", "analytics"]
ASSET_URLLink to assetSTRINGTBD