Creating a Custom Table Schema

This topic provides how to create the custom table.

POST--/pem/sql-service/config is used to create a custom table schema.

This example shows how to create a custom table named CUSTOMER containing the following fields:

• CUSTOMER_ID
• CUSTOMER_NAME
• CUSTOMER_ADDRESS
• CUSTOMER_PHN

Sample JSON:

Input: {
,"columnName1":"CUSTOMER_ID"
,"columnName2":"CUSTOMER_NAME"
,"columnName3":"CUSTOMER_ADDRESS"
,"columnName4":"CUSTOMER_PHN"
."distinctColumnName":"CUSTOMER_NAME"
# Used to perform distinct or unique operations on named column
,"seqId":1,
# To match table configuration for API reference
,"tableName":"CUSTOMER"
,"whereColumnName1":"any column name from table"
# To perform filter operations
,"whereColumnName2":"any column name from table"
,"whereColumnName3":"any column name from table"
}

Result: