Contents x
    Send Assets Data - Snowflake Data Warehouse
    • 13 Oct 2024
    • 2 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Send Assets Data - Snowflake Data Warehouse

    • Updated on 13 Oct 2024
    • 2 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    Send Assets Data - Snowflake Data Warehouse pushes CSV files containing asset data into their Snowflake data lake for:

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

    See Creating Enforcement Sets to learn more about adding Enforcement Actions to Enforcement Sets.

    Note:

    Required Fields

    These fields must be configured to run the Enforcement Set.

    • Action name - The name of this Enforcement Action. The system sets a default name. You can change the name.
    • Configure Dynamic Values - Toggle on to enter a Dynamic Value statement. See Creating Enforcement Action Dynamic Value Statements to learn more about Dynamic Value statement syntax.

    • 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 Connecting Additional Axonius Nodes.

    Additional Fields

    These 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.

    For more details about other Enforcement Actions available, see Action Library.

    Was this article helpful?
    What's Next