Demo Slam: Dataset Access Requests
Hi All! Hope you enjoyed my demo in the first ever Domo Demo Slam today. Here is a link to it if you missed out:
1. Set up the Domo Governance Datasets connector:
2. Choose the 'Datasets' report from the Domo Governance connector available reports
3. Create a new dataset using the DataSet via Email Connector:
and choose the following settings:4. Build a table card with the following fields (or more, up to you!): Name, Description, Owner Name, etc… In my demo there is a field called "System" that we have created using naming conventions for our datasets. This could also be accomplished using dataset tagging. There are a few fields available in the connector such as: Type, Display Processing Type, and Data Provider ProcessingType that could be used as well. Create quick filters for the Name and Description so end users can search for terms related to the data they want. NOTE: following strict naming and dataset description processes will ensure this works efficiently.
5. Create a beastmode that will be used for end users to click to request access to the dataset:
CONCAT('<a href="mailto:emailAddressFromYourEmailConnectorInStep3?subject=New%20Dataset%20Access%20Request:%20',`Name`,'&body=Access%20has%20been%20requested%20to%20',`Name`,'. Here is a link to the dataset: ',
' https://yourCompany.domo.com/datasources/',`Dataset ID`,'/details/overview . Please share the dataset with the sender of this email.','"></a>Request Access')
6. Add the above beastmode to your table card. When an end user clicks the link for the beastmode in the table card it will pre-populate an email requesting access to the dataset. When they send the email, a row will be added to the dataset you created in step 3.
7. Use a dataset alert to notify you when new requests have been submitted. Each request will create a row in the dataset from step 3. You can create a dataset alert to let you know anytime a row is added:
8. OPTIONAL: use a writeback connector to push the requests into Smartsheet, Salesforce, etc…
Here is what your end result card will look like:
And there it is! Let me know if you have any questions or feedback!
If I solved your problem, please select "yes" above
Comments
-
This looks awesome, thanks for sharing!
**If this answer solved your problem be sure to like it and accept it as a solution!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive