Skip to main content

Snowflake

snowflake

Version: 1.2
Updated: Jul 26, 2023

Use the Snowflake integration to query and update your Snowflake database.

Actions

  • Execute Async Query (Enrichment) - Send a Query to be executed. A Query ID is returned which can be used to check the status of the query and get the results of the query.
  • Get Query Status (Enrichment) - Check the status of the query.
  • Cancel Query (Containment) - Cancel a query by Query ID.
  • Get Results From Query ID (Enrichment) - Get the results for the given Query ID.
  • Execute Query (Enrichment) - Execute a single query and return the results.
  • Execute Multiple Queries (Enrichment) - Execute multiple queries. Queries should be separated by a semicolon (;).

External libraries

Snowflake in Automation Service and Cloud SOAR

  1. To configure the integration, log into the application, expand the configuration menu in the top right corner by hovering over the gear icon and click Automation.
    snowflake
  2. In the Automation section, on the left menu, click Integrations.
    snowflake
  3. After the list of the integrations appears, search/look for the integration and click on the row.
  4. The integration details will appear. Click on the "+" button to add new Resource.
    snowflake
  5. Populate all the required fields (*) and then click SAVE:
    • Label. Name of the resource.
    • Username. Snowflake username.
    • Password. Snowflake password.
    • Account Name. The SQL API is available at https://(account_name).snowflakecomputing.com/, copy the account_name.
    • Database Name. The name of the database to be used for the queries.
      snowflake
  6. To make sure the resource is working, hover over the resource and then click the pencil icon that appears on the right.
    snowflake
  7. Click TEST SAVED SETTINGS.
    snowflake
  8. You should receive a successful notification in the bottom right corner.
    snowflake

Change Log

  • February 14, 2022 - First upload
  • June 23, 2023 (v1.1) - Updated the integration with Environmental Variables
  • July 26, 2023 (v1.2) - Integration refactored
Legal
Privacy Statement
Terms of Use

Copyright © 2024 by Sumo Logic, Inc.