Overview

Using the Access on Hire2Retire you can provision and deprovision users on Snowflake. Read the official documentation of Snowflake here.

Figure 1. Snowflake Application on Hire2Retire

Define Profile Definition

Provisioning Type

Define Profile(s)

You can assign a Profile to any user based on their AD attributes. You can define complex conditions using AND and OR logic. You can also use the Group memberships in AD to define Profiles. For Example: In Figure 2, the rules are defined on the basis of Department (Equals). If the rules are passed then only user(s) will get provisioned. If no rule passes and the user(s) is present in Snowflake then deprovisioning is performed for the user(s).

Figure 2. Provision access based on Profiles

You can enable the "Do not deprovision app access upon change of profile" checkbox to prevent users from being deprovisioned on Snowflake due to a profile mismatch.

Figure 3. Do not deprovision app access upon change of profile

Process All Employees

All user(s) will be provisioned on Snowflake.

Figure 3. Process All Employees

Provision User

You can decide to either provision or deprovision user(s) using Access.

• Provisioning - You can provision one or more user(s) to the Snowflake according to the requirement. User(s) can be created, updated or reactivated in provisioning operation.

• Deprovisioning - You can deprovision one or more user(s) according to the requirement. User accounts will be deactivated on Snowflake upon deprovisioning.

Figure 4. Configure lifecycle operations for Snowflake

Map attributes on Snowflake

You can populate a user's profile in Snowflake by mapping attributes incoming from the AD. You can also use Hire2Retire's powerful data transformation capabilities using Excel Style functions.

Figure 5. Select Snowflake attributes

Employee Identifier

An employee identifier is a unique code, number, or combination assigned to each employee within an organization. It is used to differentiate employees for record-keeping, payroll, tracking performance, and managing access to resources.

Figure 6. Employee Identifier