Run ReportsContinuous Data Exports

Export Data to Snowflake

Set up continuous export of assets, vulnerabilities, and scan results from Mondoo to a Snowflake database.

Export your Mondoo security data to Snowflake so you can run SQL queries, build dashboards, and join it with other datasets in your warehouse. For how exports work in general, read Continuous Data Exports.

Mondoo data in Snowflake

Requirements

  • A Snowflake account with a database, warehouse, and schema already defined. See the Snowflake documentation for setup.
  • Editor or Owner access to the Mondoo space.

Find your Snowflake account identifier and region

Mondoo needs the account identifier and region ID for your Snowflake account.

  1. Log into the Snowflake web UI.

  2. At the bottom-left of the window, select the dropdown beside the Snowflake logo, then hover over your user ID for the account.

    Find your Snowflake account ID

  3. Note the Locator value. This is the account identifier Mondoo needs.

  4. Note the Region ID. Snowflake shows a description like US Central 1 (Iowa); Mondoo needs the ID form like us-central1.gcp.

Create the integration

  1. In the Mondoo App, navigate to the space. In the side navigation, select Integrations, then select INSTALL. Under Data Exports, select Snowflake.

    The Install Integration page in Mondoo with the Data Exports category selected, showing the export destinations

  2. Under Choose an integration name, enter a name for the integration.

    The Snowflake export integration form in Mondoo, with the integration name and the start of the account credentials section

  3. Under Configure Snowflake account credentials, fill in:

    • Account Identifier. The Locator value from above.
    • Region. The region ID from above.
    • User and Password. The Snowflake user Mondoo signs in as.

    The Snowflake account credentials and destination sections of the form, with the Account Identifier, Region, User, Password, Warehouse, and Database fields

  4. Under Configure Snowflake destination, enter the Warehouse, Database, and Schema Mondoo writes to.

  5. Select CREATE INTEGRATION.

Mondoo starts the initial export. When it completes, the integration's status becomes ACTIVE and subsequent exports run automatically about every 24 hours.

Manage this integration

After it's created, find your integration under Integrations in your space's side navigation. Select it to open the detail page, where you can:

  • Trigger a manual export. Exports run automatically about every 24 hours. To export immediately, select RUN.
  • Check the status. ACTIVE means the integration is healthy and exporting on schedule. PENDING means Mondoo hasn't attempted the first export yet. ERROR means the last export failed. The Export Details section shows when the last export succeeded and when Mondoo last attempted one.
  • Review the activity log. Most Recent Activity lists each export run's messages, such as when a job started, finished, or failed and why. Filter it to errors, warnings, or info messages.
  • Change the settings. Select the pencil icon to edit the integration, for example to update credentials.
  • Remove the integration. Select the trash can icon and confirm. Mondoo stops future exports but does not delete data that has already been exported.

Next steps

PostgreSQL

Set up continuous export of assets, vulnerabilities, and scan results from Mondoo to a PostgreSQL database.

Google Security Command Center

Send Mondoo findings to Google Security Command Center using Workload Identity Federation or a service account key.

On this page

RequirementsFind your Snowflake account identifier and regionCreate the integrationNext steps