Update Table

Alters the table specified with the table_name and schema to the Table object specified in the body parameter.

Instructions

In order to update an object, simply change the values of the Table objects in the request body. To delete, simply remove the object from the request body. To add, add the desired object to the request body.

The query is built in the following order:

DROP UNIQUE CONSTRAINT -> DROP PRIMARY KEY -> DROP FOREIGN KEY -> DROP COLUMN -> ADD COLUMN -> ALTER COLUMN -> RENAME COLUMN -> ADD UNIQUE CONSTRAINT -> ADD PRIMARY KEY -> ADD FOREIGN KEY -> RENAME TABLE -> SET SCHEMA

Caution:

For the columns, it is important to note that the id is the unique key used to identify the column. If you remove the column_id key from the Column object, it will be dropped from the database and be recreated.

Since there is a given order for execution, if your alter requires to not follow the order above, make sure to separate the API calls.

Parameters

table_name: str,
schema : str, default “public” The schema to retrieve the tables from. If no parameter is provided, defaults to “public”.
body: AlterTableRequest, default None

Returns

A Table Pydantic object.

PUT

api

table

{table_name}

curl --request PUT \
  --url https://your-engine-url/api/v1/table/{table_name} \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "table": {
    "name": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "id": 123,
        "default": "<string>",
        "is_nullable": true,
        "type": "<string>",
        "name": "<string>"
      }
    ],
    "constraints": {
      "unique": [
        {
          "name": "",
          "columns": []
        }
      ],
      "primary_key": {
        "name": "",
        "columns": []
      },
      "foreign_keys": [
        {
          "name": "<string>",
          "reference_schema": "public",
          "reference_column": "<string>",
          "reference_table": "<string>",
          "column": "<string>"
        }
      ]
    }
  }
}'

{
  "table": {
    "name": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "id": 123,
        "default": "<string>",
        "is_nullable": true,
        "type": "<string>",
        "name": "<string>"
      }
    ],
    "constraints": {
      "unique": [
        {
          "name": "",
          "columns": []
        }
      ],
      "primary_key": {
        "name": "",
        "columns": []
      },
      "foreign_keys": [
        {
          "name": "<string>",
          "reference_schema": "public",
          "reference_column": "<string>",
          "reference_table": "<string>",
          "column": "<string>"
        }
      ]
    }
  }
}

Authorizations

Authorization

string

header

required

Enter: 'Bearer <JWT>', where JWT is the access token. Example: Bearer access_token_comes_here

Path Parameters

table_name

string

required

Query Parameters

schema

string

default:public

Body

application/json

Response

200

application/json

Successful Response

The response is of type object.

curl --request PUT \
  --url https://your-engine-url/api/v1/table/{table_name} \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "table": {
    "name": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "id": 123,
        "default": "<string>",
        "is_nullable": true,
        "type": "<string>",
        "name": "<string>"
      }
    ],
    "constraints": {
      "unique": [
        {
          "name": "",
          "columns": []
        }
      ],
      "primary_key": {
        "name": "",
        "columns": []
      },
      "foreign_keys": [
        {
          "name": "<string>",
          "reference_schema": "public",
          "reference_column": "<string>",
          "reference_table": "<string>",
          "column": "<string>"
        }
      ]
    }
  }
}'

{
  "table": {
    "name": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "id": 123,
        "default": "<string>",
        "is_nullable": true,
        "type": "<string>",
        "name": "<string>"
      }
    ],
    "constraints": {
      "unique": [
        {
          "name": "",
          "columns": []
        }
      ],
      "primary_key": {
        "name": "",
        "columns": []
      },
      "foreign_keys": [
        {
          "name": "<string>",
          "reference_schema": "public",
          "reference_column": "<string>",
          "reference_table": "<string>",
          "column": "<string>"
        }
      ]
    }
  }
}

Update Table

Alters the table specified with the table_name and schema to the Table object specified in the body parameter.

Instructions

The query is built in the following order:

Caution:

Since there is a given order for execution, if your alter requires to not follow the order above, make sure to separate the API calls.

Parameters

table_name: str,
schema : str, default “public” The schema to retrieve the tables from. If no parameter is provided, defaults to “public”.
body: AlterTableRequest, default None

Returns

A Table Pydantic object.

PUT

api

table

{table_name}

curl --request PUT \
  --url https://your-engine-url/api/v1/table/{table_name} \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "table": {
    "name": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "id": 123,
        "default": "<string>",
        "is_nullable": true,
        "type": "<string>",
        "name": "<string>"
      }
    ],
    "constraints": {
      "unique": [
        {
          "name": "",
          "columns": []
        }
      ],
      "primary_key": {
        "name": "",
        "columns": []
      },
      "foreign_keys": [
        {
          "name": "<string>",
          "reference_schema": "public",
          "reference_column": "<string>",
          "reference_table": "<string>",
          "column": "<string>"
        }
      ]
    }
  }
}'

{
  "table": {
    "name": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "id": 123,
        "default": "<string>",
        "is_nullable": true,
        "type": "<string>",
        "name": "<string>"
      }
    ],
    "constraints": {
      "unique": [
        {
          "name": "",
          "columns": []
        }
      ],
      "primary_key": {
        "name": "",
        "columns": []
      },
      "foreign_keys": [
        {
          "name": "<string>",
          "reference_schema": "public",
          "reference_column": "<string>",
          "reference_table": "<string>",
          "column": "<string>"
        }
      ]
    }
  }
}

Authorizations

Authorization

string

header

required

Enter: 'Bearer <JWT>', where JWT is the access token. Example: Bearer access_token_comes_here

Path Parameters

table_name

string

required

Query Parameters

schema

string

default:public

Body

application/json

Response

200

application/json

Successful Response

The response is of type object.

curl --request PUT \
  --url https://your-engine-url/api/v1/table/{table_name} \
  --header 'Authorization: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "table": {
    "name": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "id": 123,
        "default": "<string>",
        "is_nullable": true,
        "type": "<string>",
        "name": "<string>"
      }
    ],
    "constraints": {
      "unique": [
        {
          "name": "",
          "columns": []
        }
      ],
      "primary_key": {
        "name": "",
        "columns": []
      },
      "foreign_keys": [
        {
          "name": "<string>",
          "reference_schema": "public",
          "reference_column": "<string>",
          "reference_table": "<string>",
          "column": "<string>"
        }
      ]
    }
  }
}'

{
  "table": {
    "name": "<string>",
    "schema": "<string>",
    "columns": [
      {
        "id": 123,
        "default": "<string>",
        "is_nullable": true,
        "type": "<string>",
        "name": "<string>"
      }
    ],
    "constraints": {
      "unique": [
        {
          "name": "",
          "columns": []
        }
      ],
      "primary_key": {
        "name": "",
        "columns": []
      },
      "foreign_keys": [
        {
          "name": "<string>",
          "reference_schema": "public",
          "reference_column": "<string>",
          "reference_table": "<string>",
          "column": "<string>"
        }
      ]
    }
  }
}

Authorizations

Path Parameters

Query Parameters

Body

Response

FAQs

Authorizations

Path Parameters

Query Parameters

Body

Response