Issues with Data idempotency

Hi there

I user snowflake and metabase and built a dashboard to try to measure the changes in a time period for some chosen metrics by a group of users. The group of users can be defined / changed via putting in their IDs.

I am facing issues where I get different results from time to time. Same metrics, but different results. Eg: count of users who hit milestone 1 in funnel, milestone 2 in funnel. One day it will be 10, the next day 9.

The issue is exacerbated when i calculate the difference between before / after the time period. As the data changes, one day the difference is 10, the next it is 11, etc.

Any idea why this is happening? Is this a snowflake caching issue, etc?

Check if this is coming from the source data. If your query data changes then it’s a problem outside of Metabase.

Do you have query caching enabled?