Saved explorer queries
saved_explorer_queries
- Schema: public
- PK: query_id (varchar)
Columns
| Column |
Type |
Nullable |
Default |
Notes |
| query_id |
varchar |
NO |
|
PK |
| workspace_id |
bigint |
NO |
|
|
| connection_id |
varchar |
NO |
|
|
| connector_type |
varchar |
NO |
|
|
| query_language |
varchar |
NO |
|
|
| name |
varchar |
NO |
|
|
| query_text_encrypted |
text |
NO |
|
Encrypted query body |
| query_text_sha256 |
varchar |
NO |
|
Hash for dedup |
| created_by |
bigint |
NO |
|
|
| last_modified_by |
bigint |
NO |
|
|
| created_time |
timestamp |
YES |
now() |
|
| updated_time |
timestamp |
YES |
now() |
|
Key indexes
saved_explorer_queries_pkey — primary key on query_id- Index on (workspace_id, connection_id, updated_time DESC)
Copilot