Hi all , I have real time fact table update requirements. A fact table will be created by joining multiple azure SQL tables . These SQL table are transactional table. I need to keep the fact table updated with the changes happening in the transactional table. Should I create the fact table as a streaming table in spark ? If yes , has anyone done this already ? If there is any other way please suggest

Not specific about deltalake... So better suited for a different site/forum ...