Skip to content

Interpres Application - Snowflake

  • Type: SIEM/Data Lake
  • Vendor: Snowflake

Snowflake

Vendor setup

Service user creation and authentication

  • Under the Horizon Catalog section click on Governance and security then Users & Roles and Users. Create a service user
  • Under the Horizon Catalog section click on Governance and security then Users & Roles and Roles. Create a role that will be assigned to the service user
  • Create and configure key-pair by Follow Snowflake documentation on configuring and creating Key-pair authentication
  • Get the account identifier by following Snowflake documentation on configuring third-party application access

App Configuration

App Parameters:

  • User (string): User
  • Account identifier (string): Account identifier
  • Private key (string): Private key to authenticate
  • Private key passphrase (string): Passphrase of the private key
  • Warehouse (string): Warehouse
  • Database (string): Database
  • Schema (string): Schema
  • Asset query (string): SQL query to collect assets

App Validation

Implemented Actions

  • Get Assets: Run a custom query to get assets from Snowflake database.