Avoiding metric inflation during data processing in Dedicated SQL Pool (formerly SQL DW)

PS 396 Reputation points
2024-06-13T20:36:41.2533333+00:00

Hi all ,

Here is the scenario for which I am seeking suggestions:

Whenever our data jobs run to refresh dimensions and facts, and a Tableau extract refresh occurs simultaneously, the extracts report inflated metrics. When we validate, the metrics on the Tableau dashboard do not match those in the fact tables. There are no traces left to identify the cause of the inflated metrics on the Tableau dashboard. However, re-running the extract corrects the metrics on the dashboards. Has anyone experienced a similar issue, and if so, how can we prevent Tableau extract refreshes from coinciding with the data job runs dynamically?

Thank you!

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,673 questions
{count} votes