My team is using Tableau with Databricks on Delta Lake. We're seeing a bunch of slow queries (around 20%) that for some reason involve massive scans - 5x to 30x more - compared to the median queries.

Summary

A team using Tableau with Databricks on Delta Lake is experiencing slow queries (around 20%) that require massive data scans, 5x to 30x higher than median queries. The issue appears to stem from how Tableau constructs queries based on user actions, which are not being optimized by Databricks. The team is seeking best practices to resolve this problem.