Mondoo
Docs
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 ID and region

Mondoo needs the account ID 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 (the account ID 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. Under Exports, select Snowflake.

    Add an export integration

  2. Enter a name for the integration.

    Snowflake integration - top

  3. Fill in:

    • Snowflake Account ID. The Locator value from above.
    • Database, Warehouse, Schema. Your destination names.
    • Region. The region ID from above.
    • Account credentials. Your Snowflake user name and password.
    • Role. If your database requires a specific role.

    Snowflake integration - bottom

  4. Select CREATE INTEGRATION.

Mondoo starts the initial export. When it completes, the integration's status becomes active and subsequent exports run automatically 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 SCHEDULE NOW.
  • 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.
  • 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.

S3-Compatible Service

Set up continuous export of assets, vulnerabilities, and scan results from Mondoo to MinIO, Ceph, or any other S3-compatible storage service.

On this page

RequirementsFind your Snowflake account ID and regionCreate the integrationNext steps