Skip to Content

Workspace settings

Cache query results

Serve repeated queries from a cache so dashboards load faster and your warehouse does less work.

Cache row in workspace settings with the Cache query results switch, the Use Databrain's managed cache checkbox and the Expire after field.
Turn on caching, then choose the managed cache or your own Redis.

Before you start

  • Your company is on the Business plan or higher.
  • You are an Admin, or your role has the Cache Settings Edit permission. With View only, you see the settings but cannot change them.

Steps

  1. Open the workspace and select Settings in the header.
  2. Expand Cache and turn on Cache query results.
  3. Choose where the cache runs:
    • Use Databrain’s managed cache: Databrain runs it. No connection details needed. Databrain cloud only.
    • Your own Redis: leave the box clear and enter Host, Port and Password (access key or AUTH token).
  4. Enter Expire after in seconds, 10 or more. 86400 is one day.
  5. Optional, for your own Redis: set SSH tunnel to Enabled to reach a cache that is not on the public internet. Enter SSH host, SSH port, SSH username and SSH private key.
  6. Select Save changes.

The cache shows Connected. Repeated queries in this workspace are now served from the cache until they expire.

Clear the cache

  1. In the Cache row, select Clear cache.
  2. Confirm.

Every cached result for this workspace is dropped. The next query runs on the warehouse.

If something goes wrong

  • Connection failed. Check the host, port and password, and that Databrain can reach your Redis.
  • An expiry is required. Enter Expire after.

On this page