Send Assets Data - Snowflake Data Warehouse

Snowflake Data Warehouse - Ingest Data Files from Cloud Storage takes files from a cloud data storage (e.g., S3 on AWS) and uses a predefined pipe to insert the data from the files into Snowflake's Data Warehouse for:

• Assets returned by the selected query or assets selected on the relevant asset page.

Required Fields

These fields must be configured to run the Enforcement Set.

• Use stored credentials from Snowflake Data Warehouse adapter - Select this option to use credentials from the adapter connection.

  • When you select this option, the Select Adapter Connection drop-down becomes available. Select the adapter connection to use for this Enforcement Action.

  📘

  Note

  To use this option, you must successfully configure a Snowflake Data Warehouse adapter connection.

• Pipe Name - Case-sensitive fully-qualified name of a pipe that loads data from files as soon as they are available. For example, myDatabase.mySchema.myPipe.

• Compute Node - The Axonius node to use when connecting to the specified host. For more details, see Working with Axonius Compute Nodes.

Additional Fields

These fields are optional.

💡

Connection and Credentials

When Use stored credentials from the adapter is toggled off, some of the connection fields below are required to create the connection, while other fields are optional.

• Account Identifier - The Snowflake account within your organization. The preferred structure is: <organization_name>-<account_name>

  For more information, see Account Identifiers.

• Warehouse (default: COMPUTE_WH) - Enter the relevant data warehouse. Note that the value is case-sensitive.

• Username - The credentials for a user account that has required permissions to perform this action.

• RSA Private Key - Upload the RSA Private Key associated with a user account that has permissions perform this action.

• Devices View Name - Enter the View/Table that you want to push data to.

  • The View/Table requires one of the following identifiers in order to fetch devices: 'ID', 'id', 'SERIAL', 'assetname'. Note that the values are case-sensitive.

  • In each Snowflake account, the name of the View/Table is user-defined, such as ACCOUNT_USAGE.DATABASES.

  • The primary use of this field is to test that a connection to the vendor can be established.

• Key Passphrase - Enter the passphrase for an encrypted key.

• Verify SSL (optional) - Select whether to verify the SSL certificate of the server against the CA database inside of Axonius. For more details, see SSL Trust & CA Settings.

• Request ID - The ID of the request.

• Files - Click + for each CSV file with asset data that you want to push into the Snowflake data warehouse.

  • File Path - The path to the CSV file.
  • File Size - The size of the CSV file.

• Gateway Name - Select the Gateway through which to connect to perform the action.

APIs

Axonius uses the Snowpipe REST API.