API Reference
  1. Database Optimizer
  2. DBAgentAPI

Ingest MySQL table DDL for a database instance

post
https://api.cast.ai/database-optimizer/advisor/v1alpha/organizations//database-instances//databases//mysql-table-ddl:ingest

Ingest MySQL table DDL for a database instance

Stores the DDL of MySQL tables, used to rebuild the schema for recommendation validation.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required

Organization identifier

string
required

Database instance ID

string
required

Database name

Body Params

Request to ingest MySQL table DDL for a database instance

string
required

Organization identifier

string
required

Database instance ID

string
required

Database name

tables
array of objects
required

The MySQL table DDL to ingest.
A maximum of 100 items can be sent in a batch. Senders should also close a batch
once its accumulated create_table_sql size reaches about 4 MB, so wide schemas stay
under message size limits of proxies between the agent and the server.

tables*
Responses

Updated 1 hour ago

Did this page help you?
Language
Credentials
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 1 hour ago

Did this page help you?