Skip to main content
POST
/
v1
/
schemaDesign:diffMetadata
cURL
curl --request POST \
  --url https://api.example.com/v1/schemaDesign:diffMetadata \
  --header 'Content-Type: application/json' \
  --data '
{
  "sourceMetadata": {
    "name": "<string>",
    "schemas": [
      {
        "name": "<string>",
        "tables": [
          {
            "name": "<string>",
            "columns": [
              {
                "name": "<string>",
                "position": 123,
                "hasDefault": true,
                "default": "<string>",
                "defaultOnNull": true,
                "onUpdate": "<string>",
                "nullable": true,
                "type": "<string>",
                "characterSet": "<string>",
                "collation": "<string>",
                "comment": "<string>",
                "generation": {
                  "type": "TYPE_UNSPECIFIED",
                  "expression": "<string>"
                },
                "isIdentity": true,
                "identityGeneration": "IDENTITY_GENERATION_UNSPECIFIED",
                "identitySeed": "<string>",
                "identityIncrement": "<string>",
                "defaultConstraintName": "<string>"
              }
            ],
            "indexes": [
              {
                "name": "<string>",
                "expressions": [
                  "<string>"
                ],
                "keyLength": [
                  "<string>"
                ],
                "descending": [
                  true
                ],
                "type": "<string>",
                "unique": true,
                "primary": true,
                "visible": true,
                "comment": "<string>",
                "definition": "<string>",
                "parentIndexSchema": "<string>",
                "parentIndexName": "<string>",
                "granularity": "<string>",
                "isConstraint": true,
                "spatialConfig": {
                  "method": "<string>",
                  "tessellation": {
                    "scheme": "<string>",
                    "gridLevels": [
                      {
                        "level": 123,
                        "density": "<string>"
                      }
                    ],
                    "cellsPerObject": 123,
                    "boundingBox": {
                      "xmin": 123,
                      "ymin": 123,
                      "xmax": 123,
                      "ymax": 123
                    }
                  },
                  "storage": {
                    "fillfactor": 123,
                    "buffering": "<string>",
                    "tablespace": "<string>",
                    "workTablespace": "<string>",
                    "sdoLevel": 123,
                    "commitInterval": 123,
                    "padIndex": true,
                    "sortInTempdb": "<string>",
                    "dropExisting": true,
                    "online": true,
                    "allowRowLocks": true,
                    "allowPageLocks": true,
                    "maxdop": 123,
                    "dataCompression": "<string>"
                  },
                  "dimensional": {
                    "dimensions": 123,
                    "dataType": "<string>",
                    "srid": 123,
                    "constraints": [
                      {
                        "dimension": "<string>",
                        "minValue": 123,
                        "maxValue": 123,
                        "tolerance": 123
                      }
                    ]
                  }
                },
                "opclassNames": [
                  "<string>"
                ],
                "opclassDefaults": [
                  true
                ]
              }
            ],
            "engine": "<string>",
            "collation": "<string>",
            "charset": "<string>",
            "rowCount": "<string>",
            "dataSize": "<string>",
            "indexSize": "<string>",
            "dataFree": "<string>",
            "createOptions": "<string>",
            "comment": "<string>",
            "foreignKeys": [
              {
                "name": "<string>",
                "columns": [
                  "<string>"
                ],
                "referencedSchema": "<string>",
                "referencedTable": "<string>",
                "referencedColumns": [
                  "<string>"
                ],
                "onDelete": "<string>",
                "onUpdate": "<string>",
                "matchType": "<string>"
              }
            ],
            "partitions": [
              {
                "name": "<string>",
                "type": "TYPE_UNSPECIFIED",
                "expression": "<string>",
                "value": "<string>",
                "useDefault": "<string>",
                "subpartitions": "<array>",
                "indexes": [
                  {
                    "name": "<string>",
                    "expressions": [
                      "<string>"
                    ],
                    "keyLength": [
                      "<string>"
                    ],
                    "descending": [
                      true
                    ],
                    "type": "<string>",
                    "unique": true,
                    "primary": true,
                    "visible": true,
                    "comment": "<string>",
                    "definition": "<string>",
                    "parentIndexSchema": "<string>",
                    "parentIndexName": "<string>",
                    "granularity": "<string>",
                    "isConstraint": true,
                    "spatialConfig": {
                      "method": "<string>",
                      "tessellation": {
                        "scheme": "<string>",
                        "gridLevels": [
                          {
                            "level": 123,
                            "density": "<string>"
                          }
                        ],
                        "cellsPerObject": 123,
                        "boundingBox": {
                          "xmin": 123,
                          "ymin": 123,
                          "xmax": 123,
                          "ymax": 123
                        }
                      },
                      "storage": {
                        "fillfactor": 123,
                        "buffering": "<string>",
                        "tablespace": "<string>",
                        "workTablespace": "<string>",
                        "sdoLevel": 123,
                        "commitInterval": 123,
                        "padIndex": true,
                        "sortInTempdb": "<string>",
                        "dropExisting": true,
                        "online": true,
                        "allowRowLocks": true,
                        "allowPageLocks": true,
                        "maxdop": 123,
                        "dataCompression": "<string>"
                      },
                      "dimensional": {
                        "dimensions": 123,
                        "dataType": "<string>",
                        "srid": 123,
                        "constraints": [
                          {
                            "dimension": "<string>",
                            "minValue": 123,
                            "maxValue": 123,
                            "tolerance": 123
                          }
                        ]
                      }
                    },
                    "opclassNames": [
                      "<string>"
                    ],
                    "opclassDefaults": [
                      true
                    ]
                  }
                ],
                "checkConstraints": [
                  {
                    "name": "<string>",
                    "expression": "<string>"
                  }
                ]
              }
            ],
            "checkConstraints": [
              {
                "name": "<string>",
                "expression": "<string>"
              }
            ],
            "owner": "<string>",
            "sortingKeys": [
              "<string>"
            ],
            "triggers": [
              {
                "name": "<string>",
                "event": "<string>",
                "timing": "<string>",
                "body": "<string>",
                "sqlMode": "<string>",
                "characterSetClient": "<string>",
                "collationConnection": "<string>",
                "comment": "<string>",
                "skipDump": true
              }
            ],
            "skipDump": true,
            "shardingInfo": "<string>",
            "primaryKeyType": "<string>"
          }
        ],
        "externalTables": [
          {
            "name": "<string>",
            "externalServerName": "<string>",
            "externalDatabaseName": "<string>",
            "columns": [
              {
                "name": "<string>",
                "position": 123,
                "hasDefault": true,
                "default": "<string>",
                "defaultOnNull": true,
                "onUpdate": "<string>",
                "nullable": true,
                "type": "<string>",
                "characterSet": "<string>",
                "collation": "<string>",
                "comment": "<string>",
                "generation": {
                  "type": "TYPE_UNSPECIFIED",
                  "expression": "<string>"
                },
                "isIdentity": true,
                "identityGeneration": "IDENTITY_GENERATION_UNSPECIFIED",
                "identitySeed": "<string>",
                "identityIncrement": "<string>",
                "defaultConstraintName": "<string>"
              }
            ]
          }
        ],
        "views": [
          {
            "name": "<string>",
            "definition": "<string>",
            "comment": "<string>",
            "dependencyColumns": [
              {
                "schema": "<string>",
                "table": "<string>",
                "column": "<string>"
              }
            ],
            "columns": [
              {
                "name": "<string>",
                "position": 123,
                "hasDefault": true,
                "default": "<string>",
                "defaultOnNull": true,
                "onUpdate": "<string>",
                "nullable": true,
                "type": "<string>",
                "characterSet": "<string>",
                "collation": "<string>",
                "comment": "<string>",
                "generation": {
                  "type": "TYPE_UNSPECIFIED",
                  "expression": "<string>"
                },
                "isIdentity": true,
                "identityGeneration": "IDENTITY_GENERATION_UNSPECIFIED",
                "identitySeed": "<string>",
                "identityIncrement": "<string>",
                "defaultConstraintName": "<string>"
              }
            ],
            "triggers": [
              {
                "name": "<string>",
                "event": "<string>",
                "timing": "<string>",
                "body": "<string>",
                "sqlMode": "<string>",
                "characterSetClient": "<string>",
                "collationConnection": "<string>",
                "comment": "<string>",
                "skipDump": true
              }
            ],
            "skipDump": true
          }
        ],
        "functions": [
          {
            "name": "<string>",
            "definition": "<string>",
            "signature": "<string>",
            "characterSetClient": "<string>",
            "collationConnection": "<string>",
            "databaseCollation": "<string>",
            "sqlMode": "<string>",
            "comment": "<string>",
            "dependencyTables": [
              {
                "schema": "<string>",
                "table": "<string>"
              }
            ],
            "skipDump": true
          }
        ],
        "procedures": [
          {
            "name": "<string>",
            "definition": "<string>",
            "signature": "<string>",
            "characterSetClient": "<string>",
            "collationConnection": "<string>",
            "databaseCollation": "<string>",
            "sqlMode": "<string>",
            "comment": "<string>",
            "skipDump": true
          }
        ],
        "streams": [
          {
            "name": "<string>",
            "tableName": "<string>",
            "owner": "<string>",
            "comment": "<string>",
            "type": "TYPE_UNSPECIFIED",
            "stale": true,
            "mode": "MODE_UNSPECIFIED",
            "definition": "<string>"
          }
        ],
        "tasks": [
          {
            "name": "<string>",
            "id": "<string>",
            "owner": "<string>",
            "comment": "<string>",
            "warehouse": "<string>",
            "schedule": "<string>",
            "predecessors": [
              "<string>"
            ],
            "state": "STATE_UNSPECIFIED",
            "condition": "<string>",
            "definition": "<string>"
          }
        ],
        "materializedViews": [
          {
            "name": "<string>",
            "definition": "<string>",
            "comment": "<string>",
            "dependencyColumns": [
              {
                "schema": "<string>",
                "table": "<string>",
                "column": "<string>"
              }
            ],
            "triggers": [
              {
                "name": "<string>",
                "event": "<string>",
                "timing": "<string>",
                "body": "<string>",
                "sqlMode": "<string>",
                "characterSetClient": "<string>",
                "collationConnection": "<string>",
                "comment": "<string>",
                "skipDump": true
              }
            ],
            "indexes": [
              {
                "name": "<string>",
                "expressions": [
                  "<string>"
                ],
                "keyLength": [
                  "<string>"
                ],
                "descending": [
                  true
                ],
                "type": "<string>",
                "unique": true,
                "primary": true,
                "visible": true,
                "comment": "<string>",
                "definition": "<string>",
                "parentIndexSchema": "<string>",
                "parentIndexName": "<string>",
                "granularity": "<string>",
                "isConstraint": true,
                "spatialConfig": {
                  "method": "<string>",
                  "tessellation": {
                    "scheme": "<string>",
                    "gridLevels": [
                      {
                        "level": 123,
                        "density": "<string>"
                      }
                    ],
                    "cellsPerObject": 123,
                    "boundingBox": {
                      "xmin": 123,
                      "ymin": 123,
                      "xmax": 123,
                      "ymax": 123
                    }
                  },
                  "storage": {
                    "fillfactor": 123,
                    "buffering": "<string>",
                    "tablespace": "<string>",
                    "workTablespace": "<string>",
                    "sdoLevel": 123,
                    "commitInterval": 123,
                    "padIndex": true,
                    "sortInTempdb": "<string>",
                    "dropExisting": true,
                    "online": true,
                    "allowRowLocks": true,
                    "allowPageLocks": true,
                    "maxdop": 123,
                    "dataCompression": "<string>"
                  },
                  "dimensional": {
                    "dimensions": 123,
                    "dataType": "<string>",
                    "srid": 123,
                    "constraints": [
                      {
                        "dimension": "<string>",
                        "minValue": 123,
                        "maxValue": 123,
                        "tolerance": 123
                      }
                    ]
                  }
                },
                "opclassNames": [
                  "<string>"
                ],
                "opclassDefaults": [
                  true
                ]
              }
            ],
            "skipDump": true
          }
        ],
        "packages": [
          {
            "name": "<string>",
            "definition": "<string>"
          }
        ],
        "owner": "<string>",
        "sequences": [
          {
            "name": "<string>",
            "dataType": "<string>",
            "start": "<string>",
            "minValue": "<string>",
            "maxValue": "<string>",
            "increment": "<string>",
            "cycle": true,
            "cacheSize": "<string>",
            "lastValue": "<string>",
            "ownerTable": "<string>",
            "ownerColumn": "<string>",
            "comment": "<string>",
            "skipDump": true
          }
        ],
        "events": [
          {
            "name": "<string>",
            "definition": "<string>",
            "timeZone": "<string>",
            "sqlMode": "<string>",
            "characterSetClient": "<string>",
            "collationConnection": "<string>",
            "comment": "<string>"
          }
        ],
        "enumTypes": [
          {
            "name": "<string>",
            "values": [
              "<string>"
            ],
            "comment": "<string>",
            "skipDump": true
          }
        ],
        "skipDump": true,
        "comment": "<string>"
      }
    ],
    "characterSet": "<string>",
    "collation": "<string>",
    "extensions": [
      {
        "name": "<string>",
        "schema": "<string>",
        "version": "<string>",
        "description": "<string>"
      }
    ],
    "owner": "<string>",
    "searchPath": "<string>"
  },
  "targetMetadata": {
    "name": "<string>",
    "schemas": [
      {
        "name": "<string>",
        "tables": [
          {
            "name": "<string>",
            "columns": [
              {
                "name": "<string>",
                "position": 123,
                "hasDefault": true,
                "default": "<string>",
                "defaultOnNull": true,
                "onUpdate": "<string>",
                "nullable": true,
                "type": "<string>",
                "characterSet": "<string>",
                "collation": "<string>",
                "comment": "<string>",
                "generation": {
                  "type": "TYPE_UNSPECIFIED",
                  "expression": "<string>"
                },
                "isIdentity": true,
                "identityGeneration": "IDENTITY_GENERATION_UNSPECIFIED",
                "identitySeed": "<string>",
                "identityIncrement": "<string>",
                "defaultConstraintName": "<string>"
              }
            ],
            "indexes": [
              {
                "name": "<string>",
                "expressions": [
                  "<string>"
                ],
                "keyLength": [
                  "<string>"
                ],
                "descending": [
                  true
                ],
                "type": "<string>",
                "unique": true,
                "primary": true,
                "visible": true,
                "comment": "<string>",
                "definition": "<string>",
                "parentIndexSchema": "<string>",
                "parentIndexName": "<string>",
                "granularity": "<string>",
                "isConstraint": true,
                "spatialConfig": {
                  "method": "<string>",
                  "tessellation": {
                    "scheme": "<string>",
                    "gridLevels": [
                      {
                        "level": 123,
                        "density": "<string>"
                      }
                    ],
                    "cellsPerObject": 123,
                    "boundingBox": {
                      "xmin": 123,
                      "ymin": 123,
                      "xmax": 123,
                      "ymax": 123
                    }
                  },
                  "storage": {
                    "fillfactor": 123,
                    "buffering": "<string>",
                    "tablespace": "<string>",
                    "workTablespace": "<string>",
                    "sdoLevel": 123,
                    "commitInterval": 123,
                    "padIndex": true,
                    "sortInTempdb": "<string>",
                    "dropExisting": true,
                    "online": true,
                    "allowRowLocks": true,
                    "allowPageLocks": true,
                    "maxdop": 123,
                    "dataCompression": "<string>"
                  },
                  "dimensional": {
                    "dimensions": 123,
                    "dataType": "<string>",
                    "srid": 123,
                    "constraints": [
                      {
                        "dimension": "<string>",
                        "minValue": 123,
                        "maxValue": 123,
                        "tolerance": 123
                      }
                    ]
                  }
                },
                "opclassNames": [
                  "<string>"
                ],
                "opclassDefaults": [
                  true
                ]
              }
            ],
            "engine": "<string>",
            "collation": "<string>",
            "charset": "<string>",
            "rowCount": "<string>",
            "dataSize": "<string>",
            "indexSize": "<string>",
            "dataFree": "<string>",
            "createOptions": "<string>",
            "comment": "<string>",
            "foreignKeys": [
              {
                "name": "<string>",
                "columns": [
                  "<string>"
                ],
                "referencedSchema": "<string>",
                "referencedTable": "<string>",
                "referencedColumns": [
                  "<string>"
                ],
                "onDelete": "<string>",
                "onUpdate": "<string>",
                "matchType": "<string>"
              }
            ],
            "partitions": [
              {
                "name": "<string>",
                "type": "TYPE_UNSPECIFIED",
                "expression": "<string>",
                "value": "<string>",
                "useDefault": "<string>",
                "subpartitions": "<array>",
                "indexes": [
                  {
                    "name": "<string>",
                    "expressions": [
                      "<string>"
                    ],
                    "keyLength": [
                      "<string>"
                    ],
                    "descending": [
                      true
                    ],
                    "type": "<string>",
                    "unique": true,
                    "primary": true,
                    "visible": true,
                    "comment": "<string>",
                    "definition": "<string>",
                    "parentIndexSchema": "<string>",
                    "parentIndexName": "<string>",
                    "granularity": "<string>",
                    "isConstraint": true,
                    "spatialConfig": {
                      "method": "<string>",
                      "tessellation": {
                        "scheme": "<string>",
                        "gridLevels": [
                          {
                            "level": 123,
                            "density": "<string>"
                          }
                        ],
                        "cellsPerObject": 123,
                        "boundingBox": {
                          "xmin": 123,
                          "ymin": 123,
                          "xmax": 123,
                          "ymax": 123
                        }
                      },
                      "storage": {
                        "fillfactor": 123,
                        "buffering": "<string>",
                        "tablespace": "<string>",
                        "workTablespace": "<string>",
                        "sdoLevel": 123,
                        "commitInterval": 123,
                        "padIndex": true,
                        "sortInTempdb": "<string>",
                        "dropExisting": true,
                        "online": true,
                        "allowRowLocks": true,
                        "allowPageLocks": true,
                        "maxdop": 123,
                        "dataCompression": "<string>"
                      },
                      "dimensional": {
                        "dimensions": 123,
                        "dataType": "<string>",
                        "srid": 123,
                        "constraints": [
                          {
                            "dimension": "<string>",
                            "minValue": 123,
                            "maxValue": 123,
                            "tolerance": 123
                          }
                        ]
                      }
                    },
                    "opclassNames": [
                      "<string>"
                    ],
                    "opclassDefaults": [
                      true
                    ]
                  }
                ],
                "checkConstraints": [
                  {
                    "name": "<string>",
                    "expression": "<string>"
                  }
                ]
              }
            ],
            "checkConstraints": [
              {
                "name": "<string>",
                "expression": "<string>"
              }
            ],
            "owner": "<string>",
            "sortingKeys": [
              "<string>"
            ],
            "triggers": [
              {
                "name": "<string>",
                "event": "<string>",
                "timing": "<string>",
                "body": "<string>",
                "sqlMode": "<string>",
                "characterSetClient": "<string>",
                "collationConnection": "<string>",
                "comment": "<string>",
                "skipDump": true
              }
            ],
            "skipDump": true,
            "shardingInfo": "<string>",
            "primaryKeyType": "<string>"
          }
        ],
        "externalTables": [
          {
            "name": "<string>",
            "externalServerName": "<string>",
            "externalDatabaseName": "<string>",
            "columns": [
              {
                "name": "<string>",
                "position": 123,
                "hasDefault": true,
                "default": "<string>",
                "defaultOnNull": true,
                "onUpdate": "<string>",
                "nullable": true,
                "type": "<string>",
                "characterSet": "<string>",
                "collation": "<string>",
                "comment": "<string>",
                "generation": {
                  "type": "TYPE_UNSPECIFIED",
                  "expression": "<string>"
                },
                "isIdentity": true,
                "identityGeneration": "IDENTITY_GENERATION_UNSPECIFIED",
                "identitySeed": "<string>",
                "identityIncrement": "<string>",
                "defaultConstraintName": "<string>"
              }
            ]
          }
        ],
        "views": [
          {
            "name": "<string>",
            "definition": "<string>",
            "comment": "<string>",
            "dependencyColumns": [
              {
                "schema": "<string>",
                "table": "<string>",
                "column": "<string>"
              }
            ],
            "columns": [
              {
                "name": "<string>",
                "position": 123,
                "hasDefault": true,
                "default": "<string>",
                "defaultOnNull": true,
                "onUpdate": "<string>",
                "nullable": true,
                "type": "<string>",
                "characterSet": "<string>",
                "collation": "<string>",
                "comment": "<string>",
                "generation": {
                  "type": "TYPE_UNSPECIFIED",
                  "expression": "<string>"
                },
                "isIdentity": true,
                "identityGeneration": "IDENTITY_GENERATION_UNSPECIFIED",
                "identitySeed": "<string>",
                "identityIncrement": "<string>",
                "defaultConstraintName": "<string>"
              }
            ],
            "triggers": [
              {
                "name": "<string>",
                "event": "<string>",
                "timing": "<string>",
                "body": "<string>",
                "sqlMode": "<string>",
                "characterSetClient": "<string>",
                "collationConnection": "<string>",
                "comment": "<string>",
                "skipDump": true
              }
            ],
            "skipDump": true
          }
        ],
        "functions": [
          {
            "name": "<string>",
            "definition": "<string>",
            "signature": "<string>",
            "characterSetClient": "<string>",
            "collationConnection": "<string>",
            "databaseCollation": "<string>",
            "sqlMode": "<string>",
            "comment": "<string>",
            "dependencyTables": [
              {
                "schema": "<string>",
                "table": "<string>"
              }
            ],
            "skipDump": true
          }
        ],
        "procedures": [
          {
            "name": "<string>",
            "definition": "<string>",
            "signature": "<string>",
            "characterSetClient": "<string>",
            "collationConnection": "<string>",
            "databaseCollation": "<string>",
            "sqlMode": "<string>",
            "comment": "<string>",
            "skipDump": true
          }
        ],
        "streams": [
          {
            "name": "<string>",
            "tableName": "<string>",
            "owner": "<string>",
            "comment": "<string>",
            "type": "TYPE_UNSPECIFIED",
            "stale": true,
            "mode": "MODE_UNSPECIFIED",
            "definition": "<string>"
          }
        ],
        "tasks": [
          {
            "name": "<string>",
            "id": "<string>",
            "owner": "<string>",
            "comment": "<string>",
            "warehouse": "<string>",
            "schedule": "<string>",
            "predecessors": [
              "<string>"
            ],
            "state": "STATE_UNSPECIFIED",
            "condition": "<string>",
            "definition": "<string>"
          }
        ],
        "materializedViews": [
          {
            "name": "<string>",
            "definition": "<string>",
            "comment": "<string>",
            "dependencyColumns": [
              {
                "schema": "<string>",
                "table": "<string>",
                "column": "<string>"
              }
            ],
            "triggers": [
              {
                "name": "<string>",
                "event": "<string>",
                "timing": "<string>",
                "body": "<string>",
                "sqlMode": "<string>",
                "characterSetClient": "<string>",
                "collationConnection": "<string>",
                "comment": "<string>",
                "skipDump": true
              }
            ],
            "indexes": [
              {
                "name": "<string>",
                "expressions": [
                  "<string>"
                ],
                "keyLength": [
                  "<string>"
                ],
                "descending": [
                  true
                ],
                "type": "<string>",
                "unique": true,
                "primary": true,
                "visible": true,
                "comment": "<string>",
                "definition": "<string>",
                "parentIndexSchema": "<string>",
                "parentIndexName": "<string>",
                "granularity": "<string>",
                "isConstraint": true,
                "spatialConfig": {
                  "method": "<string>",
                  "tessellation": {
                    "scheme": "<string>",
                    "gridLevels": [
                      {
                        "level": 123,
                        "density": "<string>"
                      }
                    ],
                    "cellsPerObject": 123,
                    "boundingBox": {
                      "xmin": 123,
                      "ymin": 123,
                      "xmax": 123,
                      "ymax": 123
                    }
                  },
                  "storage": {
                    "fillfactor": 123,
                    "buffering": "<string>",
                    "tablespace": "<string>",
                    "workTablespace": "<string>",
                    "sdoLevel": 123,
                    "commitInterval": 123,
                    "padIndex": true,
                    "sortInTempdb": "<string>",
                    "dropExisting": true,
                    "online": true,
                    "allowRowLocks": true,
                    "allowPageLocks": true,
                    "maxdop": 123,
                    "dataCompression": "<string>"
                  },
                  "dimensional": {
                    "dimensions": 123,
                    "dataType": "<string>",
                    "srid": 123,
                    "constraints": [
                      {
                        "dimension": "<string>",
                        "minValue": 123,
                        "maxValue": 123,
                        "tolerance": 123
                      }
                    ]
                  }
                },
                "opclassNames": [
                  "<string>"
                ],
                "opclassDefaults": [
                  true
                ]
              }
            ],
            "skipDump": true
          }
        ],
        "packages": [
          {
            "name": "<string>",
            "definition": "<string>"
          }
        ],
        "owner": "<string>",
        "sequences": [
          {
            "name": "<string>",
            "dataType": "<string>",
            "start": "<string>",
            "minValue": "<string>",
            "maxValue": "<string>",
            "increment": "<string>",
            "cycle": true,
            "cacheSize": "<string>",
            "lastValue": "<string>",
            "ownerTable": "<string>",
            "ownerColumn": "<string>",
            "comment": "<string>",
            "skipDump": true
          }
        ],
        "events": [
          {
            "name": "<string>",
            "definition": "<string>",
            "timeZone": "<string>",
            "sqlMode": "<string>",
            "characterSetClient": "<string>",
            "collationConnection": "<string>",
            "comment": "<string>"
          }
        ],
        "enumTypes": [
          {
            "name": "<string>",
            "values": [
              "<string>"
            ],
            "comment": "<string>",
            "skipDump": true
          }
        ],
        "skipDump": true,
        "comment": "<string>"
      }
    ],
    "characterSet": "<string>",
    "collation": "<string>",
    "extensions": [
      {
        "name": "<string>",
        "schema": "<string>",
        "version": "<string>",
        "description": "<string>"
      }
    ],
    "owner": "<string>",
    "searchPath": "<string>"
  },
  "engine": "ENGINE_UNSPECIFIED"
}
'
{
  "diff": "<string>"
}

Body

application/json
sourceMetadata
object
required

The metadata of the source schema.

targetMetadata
object
required

The metadata of the target schema.

engine
enum<string>

The database engine of the schema.

Available options:
ENGINE_UNSPECIFIED,
CLICKHOUSE,
MYSQL,
POSTGRES,
SNOWFLAKE,
SQLITE,
TIDB,
MONGODB,
REDIS,
ORACLE,
SPANNER,
MSSQL,
REDSHIFT,
MARIADB,
OCEANBASE,
STARROCKS,
DORIS,
HIVE,
ELASTICSEARCH,
BIGQUERY,
DYNAMODB,
DATABRICKS,
COCKROACHDB,
COSMOSDB,
TRINO,
CASSANDRA

Response

OK

diff
string

The diff of the metadata.