Building Data Mart inside Domo

vibhusharma2210
vibhusharma2210 Member
in SQL DataFlows

Hi,

Can we build Data mart inside Domo? Are there any challenges or limitations we need to consider?

Best Answer

Answers

  • swagner
    swagner Contributor

    @vibhusharma2210 the short answer is yes you can build a data warehouse in Domo. Here is the knowledge base article on this topic: https://domo-support.domo.com/s/article/360043430413?language=en_US

    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…

  • vibhusharma2210
    vibhusharma2210 Member

    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

  • swagner
    swagner Contributor
    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:

    https://www.youtube.com/live/mQtIgnaOEPw?si=jkZYjDZ53sIe4Zol

  • vibhusharma2210
    vibhusharma2210 Member
    edited September 2023

    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.

Categories