Create a cache rule for a proxy database

post

https://api.cast.ai/database-optimizer/caching/v1alpha/organizations/{organizationId}/proxies/{proxyId}/databases/{databaseName}/rules

Create a cache rule for a specific logical database behind a proxy.

Adds a per-table or per-query TTL override rule. Exactly one of table or
template_hash must be set on the rule.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Path Params

organizationId

string

required

Organization identifier

proxyId

string

required

Proxy identifier

databaseName

string

required

Name of the logical database within the proxy

Body Params

A cache rule configuring a per-table or per-query TTL override for a logical database behind a proxy.

Exactly one of table or template_hash must be set: table selects a Table rule,
template_hash selects a Query rule. The rule type is derived from which field is set.

templateHash

string

Hash of the normalized SQL template. Set for Query rules.

table

string

Table name. Set for Table rules.

mode

string

enum

required

Cache mode to use for this rule.

Allowed:

manualTtl

uint32

TTL value in seconds. Only applicable when mode is QUERY_CACHE_MODE_MANUAL.

Responses

Language

Credentials

URL

Loading…

Response

Click Try It! to start a request and see the response here! Or choose an example:

application/json

200OK

defaultDefault error response