Summarized Data from Source system into Bronze

TinaDouglass
New Contributor

Hello,

We are just starting with Databricks. Quick question.  We have a table in our legacy source system that summarizes values that are used on legacy reports and used for payment in our legacy system.  The business wants a dashboard on our new platform that contains some of these metrics.  I am thinking that we should be investigating the transactional tables that are used in our legacy system to bring into Databricks and have that summarize for analytics and reporting occur in Databricsk.  If we brought over the summarized data, we would have the risk that measures from the summarization in legacy is different than when/if there is another reason that the transactional data would be brought into Databricks and summarized.  Also, our legacy will be retired in 1-3 years.  Suggestions?  Thoughts?