ODBC Driver for Redis

Build 24.0.9064

TablePattern

Define the tables exposed by the provider using Redis key patterns.

Data Type

string

Default Value

"*:*"

Remarks

This property is used to define the key patterns within Redis that will appear as tables. The value is a Redis key pattern. The Redis key pattern is a string pattern containing a separator to determine a hierarchical structure for the key-values stored in the Redis data store. Any other string patterns in the value will limit which keys will be pivoted and returned as tables.

For example, TablePattern="*:*" causes the ":" character to be used as the separator. Given the following keys,


user:1001, user:1002, user:1003, admin:001, admin:002, admin:003

two tables would be exposed, user and admin, with the related keys corresponding to individual rows in each table.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9064