Create a table description

Once you have set your db credentials request this endpoint to scan your database. It maps all tables and columns so It will help the SQL Agent to generate an accurate answer. In addition, it retrieves logs, which consist of historical queries associated with each database table. These records are then stored within the query_history collection. The historical queries retrieved encompass data from the past three months and are grouped based on query and user.

The ids param is used to set the table description ids that you want to scan.

The process is carried out through Background Tasks, ensuring that even if it operates slowly, taking several minutes, the HTTP response remains swift.

Request this POST endpoint:

/api/v1/table-descriptions/sync-schemas

Request body

{
   "db_connection_id": "string",
   "ids": ["string"]
 }

Responses

HTTP 201 code response

true

Request example

 curl -X 'POST' \
'<localhost>/api/v1/table-descriptions/sync-schemas' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
    -d '{
    "db_connection_id": "db_connection_id",
    "ids": ["14e52c5f7d6dc4bc510d6d27", "15e52c5f7d6dc4bc510d6d34"]
  }'