Sandbox and Virtual Datasets: Virtualize on the Source or The Target? Seeking Opinions.
Virtual Datasets are very helpful when implementing Sandbox. But where should they reside, on the Sandbox source instance or the target instance?
Since the release of Sandbox, the recommendation has always been to put materialized data where users will consume it to ensure best performance. If the source instance is a development instance and the target instance is a production, we materialize data on the target and virtualize on the source as needed.
However, multiple recent use cases seek to do the opposite. The logic surrounds better governance. The source as a dev instance will have only a few domo users who are vetted for qualifications before allowed access. They have wide discretion for creating content on the source. The target as a prod instance is where most users access domo and they can only view and consume data. Very little to no allowance is given for the creation of content on the target. You can better control the content on the target via virtualization. You can build dataflows as needed on the source and virtualize the output only the target. Pages and Card are promoted on the target and use the virtual datasets. There may be some need for dataflows on the target, but they would be an exception and only created via Sandbox promote.
This appeals to customers that have to deal with a less governed environment that's resulted in an overabundance of dataflows and datasets, many of which are redundant. By controlling the data via virtualizations dataflow restrictions on the target, a much cleaner production environment occurs.
The tradeoff to this approach is performance. The question is whether that performance difference is tolerable.
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive