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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive