Cache configuration
Hello Folks,
I understand for a Federated Connection, the DOMO cards will fire queries directly to Snowflake. However, I have few questions around this:
- Will there be any cache stored at card level?
- Will there be any cache stored at user account / user session level?
- Will there be any cache stored in DOMO for my connected Federated Dataset?
- Will there be any cache set based on the cards browsed (irrespective of the users)?
Also, how will the Time-to-live (TTL) impact the cache mechanism? Apart from these, are there any other areas I should be looking at in terms of Cache and Performance tuning of dashboards?
Thanks in advance.
Best Answers
-
Hi @LearningNinja!
- The cache for federated queries will save the query results for a specific query for up to 24 hours (this is the TTL mechanism and is configurable by user)
- Cache is stored at the query level on card queries, and only caches query results. Because this cache is at the query level, if multiple users view the same card in Domo that produces the same query under the hood, then those query results could be returned for multiple users.
If using an OAuth configuration for your federated connection that requires users to authenticate to the cloud warehouse before it can return queries, those queries result caches would not apply across users, as each user potentially has different levels of data access.
Data previews on the dataset details page are not cached - See above
- See response for #1
1 - The cache for federated queries will save the query results for a specific query for up to 24 hours (this is the TTL mechanism and is configurable by user)
-
@LearningNinja - Editing the TTL on an existing federated connection should clear the cache.
1
Answers
-
Hi @LearningNinja!
- The cache for federated queries will save the query results for a specific query for up to 24 hours (this is the TTL mechanism and is configurable by user)
- Cache is stored at the query level on card queries, and only caches query results. Because this cache is at the query level, if multiple users view the same card in Domo that produces the same query under the hood, then those query results could be returned for multiple users.
If using an OAuth configuration for your federated connection that requires users to authenticate to the cloud warehouse before it can return queries, those queries result caches would not apply across users, as each user potentially has different levels of data access.
Data previews on the dataset details page are not cached - See above
- See response for #1
1 - The cache for federated queries will save the query results for a specific query for up to 24 hours (this is the TTL mechanism and is configurable by user)
-
@JoshMillheim - Thanks for providing detailed information around cache. Is there any mechanism available on DOMO to clear the cache created from Federated connection? Something like a force flush?
0 -
@LearningNinja - Editing the TTL on an existing federated connection should clear the cache.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive