When to use delta lake versus relational database as a source for BI reporting?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-23-2021 10:24 AM
Assume all of your data exists in delta tables and also in SQL server so you have a choice to report from either. Can someone share thoughts on "In what scenario you would not want report created from delta table and instead use the traditional relational database source and why" . Now one can create reports on delta tables using BI tools (Qlik, SSRS, Tableau etc)
For e.g. Interactive query /report is better on relational db versus delta lake because of performance etc. ( this may not be necessarily true), Business User does not understand steps involved in setting up spark cluster and connection to delta table from a BI tool , it's a hassle (or training issue?). I am interested in hearing what would be technical and non-technical reasons people think of not pointing BI tool to delta lake for reporting
- Labels:
-
BI Integrations
-
Delta Tables
-
SQL