EXTERNAL_REDIS

All functions > SOURCE > EXTERNAL_REDIS

Returns the value of the given key and field (optionally) from the given Redis source

Signatures

Returns: Value from Redis key or hash field

EXTERNAL_REDIS(source: REDISSOURCE, key: VARCHAR, [field: VARCHAR]) → VARCHAR
sql
ParameterTypeRequiredDescription
sourceREDISSOURCEYesREDISSOURCE connection from SOURCE_REDIS
keyVARCHARYesRedis key to fetch
fieldVARCHARNoOptional field name for Redis Hash lookups

Notes

  • Fetches value from Redis with low latency
  • Supports Redis Strings (key only) and Hashes (key + field)
  • For Strings: EXTERNAL_REDIS(source, key)
  • For Hashes: EXTERNAL_REDIS(source, key, field)
  • Returns VARCHAR - parse/cast as needed
  • Online-only restriction (for real-time serving)
  • Complements EXTERNAL_VIEW for key-value lookups
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19