Skip to content

Migrate sql-o11y endpoints to be tenant-scoped #89429

@THardy98

Description

@THardy98

This is an issue tracking the status of migrating sql-o11y endpoints that need work to become tenant-scoped:

ENDPOINTS

  • Databases: /_admin/v1/databases
  • Database Details: /_admin/v1/databases/{database}
  • Table Details: /_admin/v1/databases/{database}/tables/{table}
  • Table Stats: /_admin/v1/databases/{database}/tables/{table}/stats
  • Events: /_admin/v1/events
  • StatementDiagnosticsRequest: /_status/stmtdiagreports (GET)
  • CreateStatementDiagnosticsRequest: /_status/stmtdiagreports (POST)
  • CancelStatementDiagnosticsRequest: /_status/stmtdiagreports/cancel

CORRESPONDING V2 ENDPOINTS
Note that the /api/v2 endpoints use the same logic as the as their corresponding v1 endpoints above. Work done to make the v1 endpoint tenant-scoped will correspondingly make its v2 endpoint tenant-scoped.

Databases
/api/v2/databases/
/api/v2/databases/{database}/
/api/v2/databases/{database}/grants/
/api/v2/databases/{database}/tables/
/api/v2/databases/{database}/tables/{table}/

Events
/api/v2/events


TRACKING ISSUES
server: the TableDetails, TableStats, DatabaseDetails API don't decode with a proper tenant prefix:
#82879

server: tenant span stats for TableStats, TableDetails & DatabaseDetails endpoints
#90267

server: APIv2 HTTP interface missing for SQL-only servers (blocks sql-over-http endpoints)
#80789

server: make Databases endpoint tenant-scoped
#90257

server: make the DatabaseDetails endpoint tenant-scoped (has blockers)
#90261

server: make TableDetails endpoint tenant-scoped (has blockers)
#90264

server: make TableStats endpoint tenant-scoped (has blockers)
#90268

server: make the Events endpoint tenant-scoped
#90272

server: make the StatementDiagnosticsRequests endpoint tenant-scoped
#90273

server: make CreateStatementDiagnosticsReport tenant-scoped
#90274

server: make CancelStatementDiagnosticsReport tenant-scoped
#90275

Epic CRDB-16704

Metadata

Metadata

Assignees

Labels

C-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)GA-blockerbranch-release-23.1Used to mark GA and release blockers, technical advisories, and bugs for 23.1

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions