Export Data to Snowflake

Export your Mondoo security data to Snowflake so you can run SQL queries, build dashboards, and join it with other datasets in your data warehouse. Once configured, Mondoo automatically exports assets, vulnerabilities, and scan results approximately every 24 hours.

Requirements

To export data to Snowflake you must have:

• A Snowflake account, database, warehouse, and schema already defined. To learn about setting these up, read the Snowflake documentation.

• Editor or Owner access to the space from which you want to export data.

Find your Snowflake account ID and region ID

Mondoo needs the ID and region ID of a Snowflake account to which to export data. To find them:

1. Log into the Snowflake web-based UI.

2. Find the Snowflake logo at the bottom-left corner of the window. Select the nearby dropdown arrow and then hover over your user ID for the account to which you want to export data.

3. Find the Locator value. This is the account ID that Mondoo requires.

4. Find the Region value. Snowflake shows the description of the region, such as US Central 1 (Iowa). Instead of the description, Mondoo needs the ID, such as us-central1.gcp.

Add a Snowflake integration

1. In the Mondoo Console, navigate to the space from which you want to export data. In the side navigation bar, select Integrations. Under Exports, select Snowflake.

   

2. Enter a name for the integration.

   

3. In the Snowflake Account ID box, enter the account's Locator value (see Find your Snowflake account ID and region ID above).

4. Enter the Database, Warehouse, and Schema names for your export destination.

   

5. In the Region box, enter the region ID (see Find your Snowflake account ID and region ID above).

6. Under Account credentials, enter your Snowflake user name and password.

7. If your database requires a specific role, enter it in the Role box.

8. Select CREATE INTEGRATION.

   Mondoo begins exporting data from your space. When the initial export completes, the status becomes active. Exports then run automatically approximately every 24 hours.

Manage your integration

To view your integration, select Snowflake under Integrations in the side navigation bar, then select the integration.

Trigger a manual export

Exports run approximately every 24 hours. To export immediately, select the SCHEDULE NOW button on the integration detail page.

Statuses

Remove the integration

Select the trash can icon and confirm the deletion. Mondoo stops future exports but does not delete data already exported to Snowflake.

Next steps

• Export data to other destinations

---