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>"
}Computes schema differences between two database metadata. Permissions required: None
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>"
}The metadata of the source schema.
Show child attributes
The metadata of the target schema.
Show child attributes
The database engine of the schema.
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 OK
The diff of the metadata.
Was this page helpful?