Building Data Mart inside Domo
Hi,
Can we build Data mart inside Domo? Are there any challenges or limitations we need to consider?
Best Answer
-
@vibhusharma2210 yes, I am doing some things like that with snapshots of data in similar windows from ETL. Also approaching as partitions in ETL (Current Month, Current Year, Prior Years) and appending all of those back together in a dataset view (logical storage). The tools allow for a lot of approaches. You should also check out this video on Domo's YouTube channel:
0
Answers
-
@vibhusharma2210 the short answer is yes you can build a data warehouse in Domo. Here is the knowledge base article on this topic:
As far as limitations/challenges it really depends on your use case, how much you want to do within the Domo instance vs before passing your data into Domo, etc. Really an architecture strategy…
2 -
Hi @swagner , I want to build ETL Logic or pipeline which should take time interval as parameters and based on interval provided , it should store resultant data in specific table . example if I pass last 6 months interval in ETL logic then post competition of ETL , it should store data for last 6 months in specific table T1(<6months), similarly if I pass more than 6 months interval in ETL logic then post competition of ETL , it should store data for more than 6 months in another table
0 -
@vibhusharma2210 yes, I am doing some things like that with snapshots of data in similar windows from ETL. Also approaching as partitions in ETL (Current Month, Current Year, Prior Years) and appending all of those back together in a dataset view (logical storage). The tools allow for a lot of approaches. You should also check out this video on Domo's YouTube channel:
0 -
Hi @swagner , Is there a way to pass time interval as parameters in Partitions example let say I want to create partitions based on time intervals - 0-6 months, 6 months-1 year and > 1 year etc.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 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
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 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