For qualifying customers, Mode’s Discovery Database provides access to your Workspace’s usage data. This data is provided via Secure Data Sharing by Snowflake which allows Mode to securely share your usage data in a Snowflake database unique to your Workspace.
Usage data is accessible in a Snowflake Database that can be connected directly to Mode. You can use the Discovery Database to measure what’s most important to your Workspace, whether that’s understanding adoption, tracking your most popular reports, assessing database load, or auditing usage for compliance.
In other words, with the Discovery Database, you can use Mode to measure and manage how you use Mode.
See the full documentation for Mode's Discovery Database here
Q: How to check which reports are scheduled and viewed
You can loop through every single report in the workspace (the ones in public/private collections, but not other members' personal collections), and check each individual report to see whether it's scheduled. The API documentation on how to get all the reports in your workspace is here.
From there you can see the
view_count property which will allow you to see the view count for an individual report.
Discovery Database Method
You can also use the Discovery Database to obtain the same information for their reporting. The documentation for the Discovery Database can be found here.
Q: How often is data in the Discovery Database refreshed?
The Discovery database is updated daily overnight, specifically at 4:00 am Pacific time. Because data is synced to Snowflake on an hourly basis, data from 3am - 4am Pacific will not sync to Snowflake before the 4am daily update. In this case, it will not appear in the query results until the next daily update. If changes are made to a query via the Mode API, a query run may be needed to reflect those changes in the Discovery Database on the next update.
Was this article helpful?