CREATE SCHEMA [IF NOT EXISTS] db_name
with dbproperties (
CATALOG = <catalog>,
LOCATION = <endpoint>
CATALOG indicates the type of the schema. Valid values are Table Store, OSS, AnalyticDB, MySQL, SQL Server, PostgreSQL, MongoDB, and Redis.
LOCATION indicates the connection information. The LOCATION format varies with the schema type.
The following example shows how to create an OSS schema. The location is specified as the storage path of the OSS file and ended with
/ to indicate a directory.
CREATE SCHEMA oss_log_schema with DBPROPERTIES(
location = 'oss://analyticdb-bucket/log/'