Schema name
- Last Updated: December 4, 2024
- 1 minute read
- DataDirect Connectors
- JDBC
- Autonomous REST Connector 6.0
- Documentation
You can change the name of your schema by modifying the Model file. In the table object,
specify the schema name you want to use before the table name and separated by a period. If
no schema name is specified, tables are mapped to the AUTOREST schema by
default.
Table entries that specify user-provided schema names take the following form:
"<schema_name1>.<table_name1>":"<host_name1>/<endpoint_path1>",
"<schema_name2>.<table_name2>":"<host_name2>/<endpoint_path2>"[, ...]
- schema_name
- is the name of the schema to which the driver maps the table. For example, MYSCHEMA.
- table_name
- is the name of the relational table to which the driver maps the endpoint. For example, countries.
- host_name
- (optional) is the protocol and host name components of the URL endpoint. For example, http://example.com. You can omit this value by specifying the host name using the ServerName property.
- endpoint_path
- is the path component of the URL endpoint. For example,
country. This can be an unparameterized or parameterized path, a path that uses query parameters, or an array of paths. See "Query paths" for examples and more information.
In the following example, the employees table maps to the
MYSCHEMA schema, and, because no schema was specified for the table, the
countries table maps to AUTOREST schema by default:
"myschema.employees":"https://example.com/employees",
"countries":""http://example.com/countries/"