Sprinkle Docs
Search…
πŸ”„
Syncing users
Automatically sync users and permissions from your databases
If you have large number of users and their permissions are maintained within your own database, you can map those users and permissions in Sprinkle automatically.
Sprinkle has an upload service, for uploading user keys and user attributes. If the user has user keys and/or user attributes in their data sources and these are frequently updated, then the user can make use of this service to schedule them.
Here, firstly the user has to configure those data sources in sprinkle and ingest the data into data warehouse tables. And then they can schedule an explore to query on the data, to get the data in the specific format of user-email, keys, and secret for uploading user keys or user-email and attributes for uploading user attributes.
Below
πŸ”½
is an example of user attributes explore for upload service-
The explore should contain the following columns in the order: email and attribute-value. After the explore is ready, the user has to check/create a user attribute by going to Admin--> Access Management -> Configure Permissions--> User Attributes, which will be used in the upload service.
Then the user can create the upload service by going to Admin--> Access Management -> Configure Permissions--> Uploads, click on the New button and then provide a name, select User Keys or User Attribute from the Type field. Here we have selected User Attribute, then select the user attribute and explore created in the previous steps from the respective drop-down lists and click on Save And Run button.
If the job is running fine, the user can schedule the upload service from Right-top --> Autorun, then enable it and schedule the frequency as required by clicking on the Change Frequency button.
Below
πŸ”½
is an example of user keys explore for the upload service
The explore should contain the following columns in the order: email, access-key, access-secret, and status code (optional).
The status code column contains '0' or some non-zeros values. While running the user key upload job it will check the value for the status code column for that user Activation & Deactivation so if it is '0' then the user will be created and marked as 'ACTIVE' and if in case user exists already but marked as 'INACTIVE' then that user will now become 'ACTIVE'.
For Non zero status code values, the user will be marked as 'INACTIVE' if that user exists already in 'ACTIVE' state and if not then that user will not be created.
After the explore is ready, the user can create the upload service by going to Admin--> Access Management -> Configure Permissions--> Uploads, click on the New button and then provide a name, select User Keys or User Attribute from the Type field. Here we have selected User Keys, then provide the no. of expiry days, select the Groups for the non-existing users, and explore those created in the previous step from the respective drop-down lists. Then click on Save And Run button.
Note: If the explore contains non-existing users, then a Group has to be selected for them from the drop-down list. If not selected, the job will fail.
Copy link