ListProjectModifyRecords
You can use this operation to query modification records of a data migration or data synchronization task by its ID.
Try it now
Test
RAM authorization
|
Action |
Access level |
Resource type |
Condition key |
Dependent action |
|
oceanbase:ListProjectModifyRecords |
list |
*All Resource
|
None | None |
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| Id |
string |
Yes |
The ID of the data migration or data synchronization task. |
np_598jmu**** |
Response elements
|
Element |
Type |
Description |
Example |
|
object |
The response. |
||
| Success |
boolean |
Indicates whether the call succeeded. |
true |
| ErrorDetail |
object |
Error details. |
|
| Code |
string |
The error code (legacy). |
INNER_ERROR |
| Level |
string |
The error level. Valid values: FATAL, ERROR, WARNING, and CRITICAL. |
ERROR |
| Message |
string |
The error message (legacy). |
A system error occurred. |
| ExtraContext |
object |
The context used to fill placeholders in the Message field. |
|
|
any |
The context used to fill placeholders in the Message field. |
null |
|
| MessageMcmsKey |
string |
The key of the error message. |
null |
| MessageMcmsContext |
object |
The context used to fill placeholders in the MessageMcmsKey field. |
|
|
string |
The context used to fill placeholders in the MessageMcmsKey field. |
null |
|
| Reason |
string |
The cause of the error. |
null |
| ReasonMcmsKey |
string |
The key of the error reason. |
null |
| ReasonMcmsContext |
object |
The context of the error reason. |
|
|
string |
The context of the error reason. |
null |
|
| Proposal |
string |
The suggestion (new). |
Contact the administrator. |
| ProposalMcmsKey |
string |
The key of the suggestion. |
null |
| ProposalMcmsContext |
object |
The context of the suggestion. |
|
|
string |
The context of the suggestion. |
null |
|
| UpstreamErrorDetail |
any |
The upstream error details for handling HTTP requests. |
null |
| Code |
string |
The error code (legacy). |
INNER_ERROR |
| Message |
string |
The error message (legacy). |
A system error occurred. |
| Advice |
string |
The suggestion. |
Contact the administrator. |
| RequestId |
string |
The request ID. |
EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C |
| PageNumber |
integer |
The page number. This parameter takes effect only for paged queries. |
1 |
| PageSize |
integer |
The number of entries per page. This parameter takes effect only for paged queries. |
10 |
| TotalCount |
integer |
The total number of entries. This parameter takes effect only for paged queries. |
100 |
| Cost |
string |
The time consumed by the request, in seconds. |
30 |
| Data |
array<object> |
The information about task modification records. |
|
|
array<object> |
|||
| Id |
integer |
The ID of the modification record. |
344000005 |
| SubProjectId |
string |
The ID of the subtask (generated when adding tables). |
np_598qm*** |
| MergeRequestId |
integer |
The ticket ID for merging parent and child tasks, used when adding tables. |
id |
| UpdateRequestId |
integer |
The ticket ID for updating the parent task, used when removing tables or updating existing table objects. |
id |
| Type |
string |
The type of the modification record task. Valid values: INCREASE_OBJECT (add object) and DECREASE_OBJECT (remove object). |
INCREASE_OBJECT |
| Status |
string |
The status of the modification record. Valid values:
|
PENDING |
| ErrorDetail |
object |
Error details. |
|
| Code |
string |
The error code (legacy). |
INNER_ERROR |
| Level |
string |
The error level. Valid values: FATAL, ERROR, WARNING, and CRITICAL. |
ERROR |
| Message |
string |
The error message (legacy). |
A system error occurred. |
| ExtraContext |
object |
The context used to fill placeholders in the Message field. |
|
|
any |
The context used to fill placeholders in the Message field. |
null |
|
| MessageMcmsKey |
string |
The key of the error message. |
null |
| MessageMcmsContext |
object |
The context used to fill placeholders in the MessageMcmsKey field. |
|
|
string |
The context used to fill placeholders in the MessageMcmsKey field. |
null |
|
| Reason |
string |
The cause of the error. |
null |
| ReasonMcmsKey |
string |
The key of the error reason. |
null |
| ReasonMcmsContext |
object |
The context of the error reason. |
|
|
string |
The context of the error reason. |
null |
|
| Proposal |
string |
The suggestion (new). |
null |
| ProposalMcmsKey |
string |
The key of the suggestion. |
null |
| ProposalMcmsContext |
object |
The context of the suggestion. |
|
|
string |
The context of the suggestion. |
null |
|
| UpstreamErrorDetail |
any |
The upstream error details for handling HTTP requests. |
null |
| Databases |
array<object> |
The removed objects (synchronization). |
|
|
array<object> |
|||
| MappedName |
string |
The mapped name of the database. |
mapped_db |
| Name |
string |
The name of the database. |
db_name |
| Id |
string |
The ID of the database. |
db_id |
| Tables |
array<object> |
The configuration of table objects to be transferred in the current database. |
|
|
array<object> |
|||
| MappedName |
string |
The mapped name of the table or topic. |
mapped_name |
| Name |
string |
The name of the table. |
table_name |
| Id |
string |
The ID of the table. |
table_id |
| WhereClause |
string |
Configure row filtering using the |
id < 1 |
| FilterColumns |
array |
The list of filter columns. |
|
|
string |
A filter column. |
col |
|
| ShardColumns |
array |
The list of sharding key columns. |
|
|
string |
A sharding key column. |
col1 |
|
| Columns |
array<object> |
The list of columns to be transferred. |
|
|
object |
|||
| ColumnName |
string |
The name of the column. |
col_name |
| MappedName |
string |
The mapped name of the column. |
mapped_col |
| Position |
integer |
The position of the column. |
null |
| ColumnType |
string |
The type of the column. |
FLOAT |
| RecordFieldType |
string |
The extended type of the column. Valid values include INT8, INT16, INT24, INT32, INT64, BIGINT, BOOLEAN, FLOAT, DOUBLE, DECIMAL, NUMBER, SMALL_MONEY, MONEY, DEC_FLOAT, REAL, UCHAR_STRING, GRAPHIC_STRING, CHAR_STRING, NCHAR_STRING, VAR_GRAPHIC_STRING, VAR_UCHAR_STRING, VAR_STRING, VAR_CHAR_STRING, VAR_NCHAR_STRING, ROW_ID, UROWID, TEXT, NTEXT, UTEXT, TINY_TEXT, MEDIUM_TEXT, LONG_TEXT, BINARY_BYTES, VAR_BINARY_BYTES, RAW, LONG_RAW, BIT, VAR_BIT, BLOB, TINY_BLOB, MEDIUM_BLOB, LONG_BLOB, BFILE, IMAGE, JSONB, UUID, ENUM, SET, INTERVAL_DAY_TO_SECOND, INTERVAL_YEAR_TO_MONTH, INTERVAL_DATE_TIME, CLOB, NCLOB, XML, JSON, LONG_VAR_CHAR, LONG_VAR_GRAPHIC, GEOGRAPHY, GEOMETRY, POINT, LSEG, BOX, PATH, CIRCLE, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION, CIDR, INET, MACADDR, MACADDR8, TSVERCTOR, TSQUERY, YEAR, DATE, MYSQL_NEW_DATE, TIME, TIME_WITH_NANOS, TIME_WITH_TIMEZONE, SMALL_DATETIME, DATETIME, DATETIME_WITH_NONAS, TIMESTAMP_IN_LONG, TIMESTAMP_IN_LONG_WITH_NANOS, TIMESTAMP, TIMESTAMP_WITH_NANOS, TIMESTAMP_WITH_TIMEZONE, TIMESTAMP_WITH_LOCAL_TIMEZONE, ZONED_DATETIME, OID, REGCLASS, REGCOLLATION, REGCONFIG, REGDICTIONARY, REGNAMESPACE, REGOPER, REGOPERATOR, REGROLE, REGTYPE, INT4RANGE, INT8RANGE, NUMRANGE, TSRANGE, TSTZRANGE, DATERANGE, STRUCT, LIST, NULL, CUSTOM_TYPE, UNIQUEIDENTIFIER, UNSUPPORTED_TYPE. |
INT8 |
| RawColumnType |
string |
The raw string of the column type recorded in the database. |
null |
| ColumnKey |
string |
The index type. Valid values: PRI, UNI, and MUL. |
PRI |
| Nullable |
boolean |
Indicates whether the column can be null. |
true |
| DefaultValue |
string |
The default value. |
null |
| DataLength |
integer |
The length of the column. |
null |
| DataPrecision |
integer |
The precision of the column. |
64 |
| DataScale |
integer |
The number of decimal places. |
null |
| Encoding |
string |
The character encoding of the column. |
utf8 |
| ColumnComment |
string |
The comment of the column. |
comments |
| IsGenerateField |
boolean |
Indicates whether the column is hidden. |
false |
| Type |
string |
Valid values: DATABASE and TABLE. |
DATABASE |
| AdbTableSchema |
object |
The mapping information of the ADB data source. |
|
| PrimaryKeys |
array |
The list of primary key columns. |
|
|
string |
A primary key column. |
pk |
|
| DistributedKeys |
array |
The list of distribution key columns. |
|
|
string |
A distribution key column. |
col2 |
|
| PartitionStatement |
string |
The partition filter expression. |
PARTITION BY VALUE('id') |
| PartitionLifeCycle |
integer |
The lifecycle of the table. |
30 |
| Views |
array<object> |
The configuration list of view objects to be transferred in the current database. |
|
|
array<object> |
|||
| MappedName |
string |
The mapped name of the view. |
mapped_view |
| Name |
string |
The name of the table. |
table_name |
| Id |
string |
The ID of the table. |
table_id |
| WhereClause |
string |
Configure row filtering using the |
id<1 |
| FilterColumns |
array |
The list of filter columns. |
|
|
string |
A filter column. |
col |
|
| ShardColumns |
array |
The list of sharding key columns. |
|
|
string |
A sharding key column. |
col1 |
|
| Columns |
array<object> |
The list of columns to be transferred. |
|
|
object |
|||
| ColumnName |
string |
The name of the column. |
col_name |
| MappedName |
string |
The mapped name of the column. |
mapped_name |
| Position |
integer |
The position of the column. |
null |
| ColumnType |
string |
The type of the column. |
FLOAT |
| RecordFieldType |
string |
The extended type of the column. |
INT8 |
| RawColumnType |
string |
The raw string of the column type recorded in the database. |
null |
| ColumnKey |
string |
The index type. Valid values: PRI, UNI, and MUL. |
PRI |
| Nullable |
boolean |
Indicates whether the column can be null. |
false |
| DefaultValue |
string |
The default value. |
null |
| DataLength |
integer |
The length of the column. |
null |
| DataPrecision |
integer |
The precision of the column. |
64 |
| DataScale |
integer |
The number of decimal places. |
null |
| Encoding |
string |
The character encoding of the column. |
utf16 |
| ColumnComment |
string |
The comment of the column. |
comments |
| IsGenerateField |
boolean |
Indicates whether the column is hidden. |
false |
| Type |
string |
Valid values: DATABASE and TABLE. |
DATABASE |
| AdbTableSchema |
object |
The mapping information of the ADB data source. |
|
| PrimaryKeys |
array |
The list of primary key columns. |
|
|
string |
A primary key column. |
pk |
|
| DistributedKeys |
array |
The list of distribution key columns. |
|
|
string |
A distribution key column. |
col2 |
|
| PartitionStatement |
string |
The partition filter expression. |
PARTITION BY VALUE('id') |
| PartitionLifeCycle |
integer |
The lifecycle of the table. |
30 |
| SpecificTables |
array<object> |
The configuration set of specific table objects. |
|
|
array<object> |
|||
| MappedName |
string |
The mapped name of the table or topic. |
mapped_name |
| Name |
string |
The name of the table. |
table_name |
| Id |
string |
The ID of the table. |
table_id |
| WhereClause |
string |
Configure row filtering using the |
id<3 |
| FilterColumns |
array |
The list of filter columns. |
|
|
string |
A filter column. |
col |
|
| ShardColumns |
array |
The list of sharding key columns. |
|
|
string |
A sharding key column. |
col2 |
|
| Columns |
array<object> |
The list of columns to be transferred. |
|
|
object |
|||
| ColumnName |
string |
The name of the column. |
col_name |
| MappedName |
string |
The mapped name of the column. |
mapped_name |
| Position |
integer |
The position of the column. |
null |
| ColumnType |
string |
The type of the column. |
FLOAT |
| RecordFieldType |
string |
The extended type of the column. |
INT8 |
| RawColumnType |
string |
The raw string of the column type recorded in the database. |
null |
| ColumnKey |
string |
The index type. Valid values: PRI, UNI, and MUL. |
PRI |
| Nullable |
boolean |
Indicates whether the column can be null. |
false |
| DefaultValue |
string |
The default value. |
null |
| DataLength |
integer |
The length of the column. |
null |
| DataPrecision |
integer |
The precision of the column. |
64 |
| DataScale |
integer |
The number of decimal places. |
null |
| Encoding |
string |
The character encoding of the column. |
utf16 |
| ColumnComment |
string |
The comment of the column. |
comments |
| IsGenerateField |
boolean |
Indicates whether the column is hidden. |
false |
| Type |
string |
Valid values: DATABASE and TABLE. |
DATABASE |
| AdbTableSchema |
object |
The mapping information of the ADB data source. |
|
| PrimaryKeys |
array |
The list of primary key columns. |
|
|
string |
A primary key column. |
pk |
|
| DistributedKeys |
array |
The list of distribution key columns. |
|
|
string |
A distribution key column. |
col2 |
|
| PartitionStatement |
string |
Partition filter expression. |
PARTITION BY VALUE('id') |
| PartitionLifeCycle |
integer |
The lifecycle of the table. |
30 |
| SpecificViews |
array<object> |
The configuration list of specific view objects. |
|
|
array<object> |
|||
| MappedName |
string |
The mapped name of the table or topic. |
mapped_name |
| Name |
string |
The name of the table. |
table_name |
| Id |
string |
The ID of the table. |
table_id |
| WhereClause |
string |
Configure row filtering using the |
id < 1 |
| FilterColumns |
array |
The list of filter columns. |
|
|
string |
A filter column. |
col1 |
|
| ShardColumns |
array |
The list of sharding key columns. |
|
|
string |
A sharding key column. |
col2 |
|
| Columns |
array<object> |
The list of columns to be transferred. |
|
|
object |
|||
| ColumnName |
string |
The name of the column. |
col_name |
| MappedName |
string |
The mapped name of the column. |
mapped_name |
| Position |
integer |
The position of the column. |
null |
| ColumnType |
string |
The type of the column. |
FLOAT |
| RecordFieldType |
string |
The extended type of the column. |
INT8 |
| RawColumnType |
string |
The raw string of the column type recorded in the database. |
null |
| ColumnKey |
string |
The index type. Valid values: PRI, UNI, and MUL. |
PRI |
| Nullable |
boolean |
Indicates whether the column can be null. |
true |
| DefaultValue |
string |
The default value. |
null |
| DataLength |
integer |
The length of the column. |
null |
| DataPrecision |
integer |
The precision of the column. |
64 |
| DataScale |
integer |
The number of decimal places. |
null |
| Encoding |
string |
The character encoding of the column. |
utf16 |
| ColumnComment |
string |
The comment of the column. |
comments |
| IsGenerateField |
boolean |
Indicates whether the column is hidden. |
false |
| Type |
string |
Valid values: DATABASE and TABLE. |
DATABASE |
| AdbTableSchema |
object |
The mapping information of the ADB data source. |
|
| PrimaryKeys |
array |
The list of primary key columns. |
|
|
string |
A primary key column. |
pk |
|
| DistributedKeys |
array |
The list of distribution key columns. |
|
|
string |
A distribution key column. |
col2 |
|
| PartitionStatement |
string |
The partition filter expression. |
PARTITION BY VALUE('id') |
| PartitionLifeCycle |
integer |
The lifecycle of the table. |
30 |
| MigrationObjectsInfo |
object |
The removed objects (migration). |
|
| WildcardMode |
boolean |
Indicates whether wildcard mode is enabled. |
true |
| Tables |
array<object> |
The list of tables to be migrated. |
|
|
object |
|||
| Schema |
string |
The name of the database. |
schema_name |
| Name |
string |
The name of the migration object. |
table_name |
| TablesBlack |
array<object> |
The blacklist of tables to be migrated. |
|
|
object |
|||
| Schema |
string |
The name of the database. |
schema_name |
| Name |
string |
The name of the object. |
table_name |
| Views |
array<object> |
The list of views to be migrated. |
|
|
object |
|||
| Schema |
string |
The name of the database. |
schema_name |
| Name |
string |
The name of the object. |
view_name |
| ViewsBlack |
array<object> |
The blacklist of views to be migrated. |
|
|
object |
|||
| Schema |
string |
The name of the database. |
schema_name |
| Name |
string |
The name of the object. |
view_name |
| OmsProjectMappingInfo |
object |
The matching rules for removed objects (migration). |
|
| SchemaMappings |
array<object> |
The list of schema mapping information. |
|
|
object |
|||
| SourceName |
string |
The name of the source schema. |
source_name |
| DestName |
string |
The mapped name of the schema. |
mapped_schema |
| TableMappings |
array<object> |
The list of table mapping information. |
|
|
object |
|||
| SourceSchema |
string |
The name of the source schema. |
source_schema |
| SourceName |
string |
The name of the source object. |
source_name |
| DestName |
string |
The mapped name of the object. |
dest_name |
| ColumnMappings |
array<object> |
The list of column mapping information. |
|
|
object |
|||
| SourceSchema |
string |
The name of the source schema. |
source_schema |
| SourceTable |
string |
The name of the source table. |
source_table |
| SourceName |
string |
The name of the source object. |
source_name |
| DestName |
string |
The name of the destination object. |
dest_name |
| ViewMappings |
array<object> |
The list of view mapping information. |
|
|
object |
|||
| SourceSchema |
string |
The name of the source schema. |
schema_name |
| SourceName |
string |
The name of the source object. |
source_name |
| DestName |
string |
The mapped name of the object. |
dest_name |
| TableEtlList |
array<object> |
The ETL information of removed objects (migration). |
|
|
object |
|||
| TenantName |
string |
The name of the tenant. |
tenant_name |
| Database |
string |
The name of the source database. |
db_name |
| DestDatabase |
string |
The name of the destination database. |
dest_db |
| TableName |
string |
The name of the source table. |
table_name |
| DestName |
string |
The name of the destination table or topic. |
dest_name |
| WhereClause |
string |
Configure row filtering using the |
id>1 |
| FilterColumns |
array |
The list of filter columns. |
|
|
string |
A filter column. |
col |
|
| ShardColumns |
array |
The list of sharding key columns. |
|
|
string |
A sharding key column. |
null |
|
| LogicTableId |
string |
The ID of the logical table for logical tables. |
null |
| SourceEndpointId |
string |
The endpoint ID passed for physical tables. |
null |
| GmtModified |
string |
The time when the task was updated, displayed in UTC+0. |
2023-07-13T06:26:15 |
Examples
Success response
JSON format
{
"Success": true,
"ErrorDetail": {
"Code": "INNER_ERROR",
"Level": "ERROR",
"Message": "A system error occurred.\n",
"ExtraContext": {
"key": "null"
},
"MessageMcmsKey": "null",
"MessageMcmsContext": {
"key": "null"
},
"Reason": "null",
"ReasonMcmsKey": "null",
"ReasonMcmsContext": {
"key": "null"
},
"Proposal": "Contact the administrator. ",
"ProposalMcmsKey": "null",
"ProposalMcmsContext": {
"key": "null"
},
"UpstreamErrorDetail": "null"
},
"Code": "INNER_ERROR",
"Message": "A system error occurred.\n",
"Advice": "Contact the administrator. ",
"RequestId": "EE205C00-30E4-XXXX-XXXX-87E3A8A2AA0C",
"PageNumber": 1,
"PageSize": 10,
"TotalCount": 100,
"Cost": "30",
"Data": [
{
"Id": 344000005,
"SubProjectId": "np_598qm***",
"MergeRequestId": 0,
"UpdateRequestId": 0,
"Type": "INCREASE_OBJECT",
"Status": "PENDING",
"ErrorDetail": {
"Code": "INNER_ERROR",
"Level": "ERROR",
"Message": "A system error occurred.\n",
"ExtraContext": {
"key": "null"
},
"MessageMcmsKey": "null",
"MessageMcmsContext": {
"key": "null"
},
"Reason": "null",
"ReasonMcmsKey": "null",
"ReasonMcmsContext": {
"key": "null"
},
"Proposal": "null",
"ProposalMcmsKey": "null",
"ProposalMcmsContext": {
"key": "null"
},
"UpstreamErrorDetail": "null"
},
"Databases": [
{
"MappedName": "mapped_db",
"Name": "db_name",
"Id": "db_id",
"Tables": [
{
"MappedName": "mapped_name",
"Name": "table_name",
"Id": "table_id",
"WhereClause": "id < 1",
"FilterColumns": [
"col"
],
"ShardColumns": [
"col1"
],
"Columns": [
{
"ColumnName": "col_name",
"MappedName": "mapped_col",
"Position": 0,
"ColumnType": "FLOAT",
"RecordFieldType": "INT8",
"RawColumnType": "null",
"ColumnKey": "PRI",
"Nullable": true,
"DefaultValue": "null",
"DataLength": 0,
"DataPrecision": 64,
"DataScale": 0,
"Encoding": "utf8",
"ColumnComment": "comments",
"IsGenerateField": false,
"Type": "DATABASE"
}
],
"AdbTableSchema": {
"PrimaryKeys": [
"pk"
],
"DistributedKeys": [
"col2"
],
"PartitionStatement": "PARTITION BY VALUE('id')",
"PartitionLifeCycle": 30
}
}
],
"Views": [
{
"MappedName": "mapped_view",
"Name": "table_name",
"Id": "table_id",
"WhereClause": "id<1",
"FilterColumns": [
"col"
],
"ShardColumns": [
"col1"
],
"Columns": [
{
"ColumnName": "col_name",
"MappedName": "mapped_name",
"Position": 0,
"ColumnType": "FLOAT",
"RecordFieldType": "INT8",
"RawColumnType": "null",
"ColumnKey": "PRI",
"Nullable": false,
"DefaultValue": "null",
"DataLength": 0,
"DataPrecision": 64,
"DataScale": 0,
"Encoding": "utf16",
"ColumnComment": "comments",
"IsGenerateField": false,
"Type": "DATABASE"
}
],
"AdbTableSchema": {
"PrimaryKeys": [
"pk"
],
"DistributedKeys": [
"col2"
],
"PartitionStatement": "PARTITION BY VALUE('id')",
"PartitionLifeCycle": 30
}
}
],
"SpecificTables": [
{
"MappedName": "mapped_name",
"Name": "table_name",
"Id": "table_id",
"WhereClause": "id<3",
"FilterColumns": [
"col"
],
"ShardColumns": [
"col2"
],
"Columns": [
{
"ColumnName": "col_name",
"MappedName": "mapped_name",
"Position": 0,
"ColumnType": "FLOAT",
"RecordFieldType": "INT8",
"RawColumnType": "null",
"ColumnKey": "PRI",
"Nullable": false,
"DefaultValue": "null",
"DataLength": 0,
"DataPrecision": 64,
"DataScale": 0,
"Encoding": "utf16",
"ColumnComment": "comments",
"IsGenerateField": false,
"Type": "DATABASE"
}
],
"AdbTableSchema": {
"PrimaryKeys": [
"pk"
],
"DistributedKeys": [
"col2"
],
"PartitionStatement": "PARTITION BY VALUE('id')",
"PartitionLifeCycle": 30
}
}
],
"SpecificViews": [
{
"MappedName": "mapped_name",
"Name": "table_name",
"Id": "table_id",
"WhereClause": "id < 1",
"FilterColumns": [
"col1"
],
"ShardColumns": [
"col2"
],
"Columns": [
{
"ColumnName": "col_name",
"MappedName": "mapped_name",
"Position": 0,
"ColumnType": "FLOAT",
"RecordFieldType": "INT8",
"RawColumnType": "null",
"ColumnKey": "PRI",
"Nullable": true,
"DefaultValue": "null",
"DataLength": 0,
"DataPrecision": 64,
"DataScale": 0,
"Encoding": "utf16",
"ColumnComment": "comments",
"IsGenerateField": false,
"Type": "DATABASE"
}
],
"AdbTableSchema": {
"PrimaryKeys": [
"pk"
],
"DistributedKeys": [
"col2"
],
"PartitionStatement": "PARTITION BY VALUE('id')",
"PartitionLifeCycle": 30
}
}
]
}
],
"MigrationObjectsInfo": {
"WildcardMode": true,
"Tables": [
{
"Schema": "schema_name",
"Name": "table_name"
}
],
"TablesBlack": [
{
"Schema": "schema_name",
"Name": "table_name"
}
],
"Views": [
{
"Schema": "schema_name",
"Name": "view_name"
}
],
"ViewsBlack": [
{
"Schema": "schema_name",
"Name": "view_name"
}
]
},
"OmsProjectMappingInfo": {
"SchemaMappings": [
{
"SourceName": "source_name",
"DestName": "mapped_schema"
}
],
"TableMappings": [
{
"SourceSchema": "source_schema",
"SourceName": "source_name",
"DestName": "dest_name"
}
],
"ColumnMappings": [
{
"SourceSchema": "source_schema",
"SourceTable": "source_table",
"SourceName": "source_name",
"DestName": "dest_name"
}
],
"ViewMappings": [
{
"SourceSchema": "schema_name",
"SourceName": "source_name",
"DestName": "dest_name"
}
]
},
"TableEtlList": [
{
"TenantName": "tenant_name",
"Database": "db_name",
"DestDatabase": "dest_db",
"TableName": "table_name",
"DestName": "dest_name",
"WhereClause": "id>1",
"FilterColumns": [
"col"
],
"ShardColumns": [
"null"
],
"LogicTableId": "null",
"SourceEndpointId": "null"
}
],
"GmtModified": "2023-07-13T06:26:15"
}
]
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.