UUID / GUID Functions in Rank and Window


There are times where I may need to generate a unique ID so I can tie related batches of records together under said ID without worrying much about collisions with another group of related records in the same dataset. This will also allow me to treat them as a partition key if I want to target a handful of records for reprocessing in situations where a normal key like dates would cause a ton more reprocessing of records and more overhead.
It would be nice to have this option in Rank and Window tiles so I could easily generate unique IDs when needed. Sure, you could do this with row numbers, or concatenating but that doesn't guarantee unique keys on historical data if row counts change or there arent enough fields in your dataset to concatenate to make a good unique key in the first place.
In my scenario, I have an ETL that generates/updates a dataset that one of our apps also reads from and updates. Having a UUID/GUID across batches of my records on the ETL side to act as a key of sorts would allow the App in AppDB to know which records belong together for processing and storing on its side and vice versa. It just allows for more clean conversation between two processes that work on the same records.
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 742 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive