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
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 737 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive