Create relational table¶
Create a relational table, with the associated schema type and relational columns, and attach it to a database.
More examples with all available properties for a table can be found in the sample collection
POST {serverURLRoot}/servers/{serverName}/open-metadata/access-services/data-engine/users/{userId}/relational-tables
{
"databaseQualifiedName": "(host)=HOST::(database)=MINIMAL-basic",
"table": {
"qualifiedName": "(host)=HOST::(database)=MINIMAL-basic::(database_schema)=DB2INST1::(database_table)=EMPLNAME-basic",
"displayName": "EMPLNAME-basic",
"columns": [
{
"qualifiedName": "(host)=HOST::(database)=MINIMAL-basic::(database_schema)=DB2INST1::(database_table)=EMPLNAME-basic::(database_column)=EMPID",
"displayName": "EMPID",
"dataType": "INTEGER"
},
{
"qualifiedName": "(host)=HOST::(database)=MINIMAL-basic::(database_schema)=DB2INST1::(database_table)=EMPLNAME-basic::(database_column)=FNAME",
"displayName": "FNAME",
"dataType": "STRING"
},
{
"qualifiedName": "(host)=HOST::(database)=MINIMAL-basic::(database_schema)=DB2INST1::(database_table)=EMPLNAME-basic::(database_column)=LOCID",
"displayName": "LOCID",
"dataType": "INTEGER"
},
{
"qualifiedName": "(host)=HOST::(database)=MINIMAL-basic::(database_schema)=DB2INST1::(database_table)=EMPLNAME-basic::(database_column)=SURNAME",
"displayName": "SURNAME",
"dataType": "STRING"
}
]
},
"externalSourceName": "(organization)=Company::(project)=ExternalDataPlatform"
}
databaseQualifiedName
- qualifiedName of the database.
externalSourceName
- qualifiedName of the external data engine tool.
Note that you need to register the data engine tool with register-data-engine-tool
before creating any process.
GUIDResponse
- response containing the database GUID, with status and error message if failing.
Raise an issue or comment below