Skip to content

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