All Products
Search
Document Center

Create OSS schemas

Last Updated: Apr 25, 2019

Procedure

  1. Log on to the DLA console.

  2. In the left-side navigation pane, click Endpoint. In the endpoint list, locate the row that contains the target endpoint and click Log on in DMS in the Actions column. Run the following statement to create an OSS schema in DLA:

    1. CREATE SCHEMA oss_log_schema with DBPROPERTIES(
    2. catalog='oss',
    3. location = 'oss://analyticdb-bucket/log/'
    4. );

    location: indicates the directory of the file in the OSS bucket, which must end with a slash /. analyticdb-bucket is the name of the OSS bucket.

Next step

Create tables based on OSS logs and read data from the logs