• Overview
  • Configuration

Related-apps

Snowflake

Automate Snowflake account lifecycle management and keep permissions current.

Identity provisioningDatabase

Overview

Snowflake is a cloud-based data platform that provides data warehousing, analytics, and secure data sharing capabilities. Integrating Snowflake with ADManager Plus enables IT teams to automate the synchronisation of user accounts between Active Directory (AD) and Snowflake. This ensures that user access to Snowflake is aligned with organizational policies and updated in real time based on changes in AD, eliminating manual provisioning efforts and improving data security.

 

Automated user provisioning

Automatically create user accounts in AD for employees based on their Snowflake attributes. This reduces manual tasks for IT teams and ensures that users gain timely access to data resources.

 

Streamlined deprovisioning

When users are disabled or removed in Snowflake, their user profiles are disabled/ removed in AD. This prevents unauthorized access and strengthens compliance with data governance policies.

 

How to integrate Snowflake with ADManager Plus

Prerequisites:

Snowflake uses OAuth 2.0 to authorize API requests. Please ensure to provide the client_id and client_secret with permissions to retrieve desired information and perform tasks in Snowflake. Refer to the Snowflake's API references page for more details.

Privileges:

  • To import users (inbound action): Ensure the account used for authorization has permission to read all user accounts.
  • To perform any action or query in Snowflake (outbound action): Ensure the account used for authorization has permission to perform the desired action.
Note: ADManager Plus comes with a preconfigured set of APIs that help perform basic actions with the integration. If the action you require is not available, please gather the necessary API details from the Snowflake API documentation to configure under inbound/outbound webhooks to perform the required actions.

Authorization configuration

  • Log in to ADManager Plus and navigate to Directory/Application Settings.
  • Go to Application Integrations, then search and select Snowflake.
  • Toggle the Enable Snowflake Integration button on.
  • In the Snowflake Configuration page, click Authorization.
  • Perform steps to generate client_id and client_secret from Snowflake, and paste them in the respective value fields.
  • Select Authorization Code as Grant Type.
  • In the Auth URL field and the Auth Token URL field replace {org-account} value with that of your Snowflake instance.
  • Click Configure.

Inbound webhook configuration

The inbound webhook enables you to get user data from Snowflake to ADManager Plus and perform desired action available in Automation feature on them. The attribute mapping configured in this section can be selected as the data source during automation configuration to perform the desired action on the list of users received from the API response. To configure an inbound webhook for Snowflake:

  • Under Inbound Webhook, click Snowflake Endpoint Configuration.
  • In the Endpoint Configuration tab, an endpoint, Snowflake LIST USERS ENDPOINT, comes preconfigured with an Endpoint URL, API Method, Headers, and Parameters fields to fetch user accounts from Snowflake. If you would like to use this preconfigured endpoint, replace {org-account} of your Snowflake instance in the Endpoint URL field. However, if you would like to use a new endpoint to import users, you can configure one using the + Add API endpoint button and filling in the required fields per Snowflake's API references. Click here to learn how. Note:
    • Authorization Header is preconfigured as a header for authenticating API requests as configured during Authorization Configuration.
    • Macros: You can add macros to your endpoint configuration to dynamically change it as per your requirement using the macro chooser component.
    • Refer to Snowflake's API references and configure additional headers and parameters, if required.
  • Once done, click Test & Save. A response window will display all the requested parameters that can be fetched using the API call. Click Proceed. Note:
    • Refer to Snowflake's API references to know the Parameters that must be configured to fetch specific parameters.
    • You can configure multiple endpoints for Snowflake using the + Add API endpoint button. Click here to learn how.
  • Click Data Source - LDAP Attribute Mapping to match endpoints and to map AD LDAP attributes with the respective attributes in Snowflake.
  • Click + Add New Configuration and perform the following:
    • Enter the Configuration Name and Description and select the Automation Category from the drop-down menu.
    • In the Select Endpoint field, select the desired endpoint and a Primary Key that is unique to a user (e.g. employeeIdentifier). Note: When multiple endpoints are configured, this attribute must hold the same value in all the endpoints.
    • In the Attribute Mapping field, select the attribute from the LDAP Attribute Name drop-down menu and map it with the respective column in Snowflake.
    • If you would like to create a new custom format for this, click Mapping Attribute.
    • Click Save.
Note: The attribute mapping configured in this section can be selected as the data source during automation configuration to perform the desired action on the list of users received from the API response.

Outbound webhook configuration

An outbound webhook enables you to send changes made in AD using ADManager Plus to Snowflake and carry out tasks in Snowflake—all from ADManager Plus.To configure an outbound webhook for Snowflake:

  • Under Outbound Webhook, click Snowflake Webhook Configuration.
  • Click + Add Webhook.
  • Enter a name and description for this webhook.
  • Decide on the action that has to be performed and refer to Snowflake's API references for the API details, such as the URL, headers, parameters, and other requirements.
  • Select the HTTP method that will enable you to perform the desired action on the endpoint from the drop-down menu.
  • Enter the endpoint URL.
  • Configure the Headers, Parameters, and Message Type in the appropriate format based on the API call that you would like to perform.
  • Click Test and Save.
  • A pop-up window will then display a list of AD users and groups on which to test the configured API call. Select the desired user or group on which this API request has to be tested and click OK. This will make a real-time call to the endpoint URL, and the selected objects will be modified according to the configuration.
  • The webhook response and request details will then be displayed. Verify them for the expected API behavior and click Save.
Note: The webhooks configured in this section can be included in Orchestration Templates, which can be used in event-driven and scheduled automations. They can also be applied directly to desired users to perform a sequence of actions on them (under Management > Advanced Management > Orchestration).