Snowflake Data Warehouse

Snowflake is a data warehouse built on top of the Amazon Web Services or Microsoft Azure cloud infrastructure, and allows storage and compute to scale independently.

Types of Assets Fetched

This adapter fetches the following types of assets:

• Devices
• Users
• SaaS Data

Parameters

1. Account Identifier (required) - The Snowflake account within your organization. The preferred structure is: <organization_name>-<account_name>

   For more information, see Account Identifiers.

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

3. View Name (required) - Enter the View/Table that you want to extract data from. Note that the value is case-sensitive.

4. Fetch users - Toggle this option on to fetch users. When you select this option, you must enter a Users view name, this is the View/Table that you want to extract data from. Note that the value is case-sensitive.

5. Username (required) - The credentials for a user account that has required permissions to fetch assets.

6. RSA Private Key (required) - Select to upload an RSA Private Key associated with a user account that has permissions to fetch assets.

7. Key Passphrase (optional) - Enter the passphrase for an encrypted key.

7. Verify SSL - 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.

8. HTTPS Proxy (optional) - Connect the adapter to a proxy instead of directly connecting it to the domain.

9. HTTPS Proxy User Name (optional) - The user name to use when connecting to the value supplied in Host Name or IP Address via the value supplied in HTTPS Proxy.

10. HTTPS Proxy Password (optional) - The password to use when connecting to the server using the HTTPS Proxy.

11. Organization Region (optional) (Only for accounts with SaaS Management capability) - The parameter in the account URL that represents the region where the organization’s account is located.

12. To learn more about common adapter connection parameters and buttons, see Adding a New Adapter Connection.

## Advanced Settings

• Fetch Snowflake Instance Admins (optional) (Only for accounts with SaaS Management capability)- Fetch users with the capability to manage the Snowflake instance.

APIs

Axonius uses the Snowflake SQL API.

Required Permissions

The value supplied in Username must have Read permissions for the Table/View specified in the connection details.

Version Matrix

This adapter was only tested with the versions marked as supported, but may work with other versions. Contact Axonius Support if you have a version that is not listed, which is not functioning as expected.

Supported From Version

Supported from Axonius version 4.5