All Products
Search
Document Center

Create OSS schemas

Last Updated: Apr 25, 2019

DLA allows you to create an OSS schema by following the wizard or by manually compiling an SQL statement. This topic describes how to create an OSS schema by following the wizard.

To compile an SQL statement for creating an OSS schema, see Compile SQL statements to create an OSS schema.

Prerequisites

Before you can create an OSS schema, you must activate an OSS data source for DLA.

  1. Log on to the Data Lake Analytics console.

  2. In the left-side navigation pane, click Schema, and then click New Schema.

  3. On the New Schema page, locate the target OSS instance, and click Create by Wizard in Object Storage Service. If you have not activated any OSS data sources for your account, activate one as prompted.

Procedure

  1. Log on to the Data Lake Analytics console.

  2. In the left-side navigation pane, click Schema, and then click Create Schema.

  3. On the New Schema page, choose Create by Wizard in Object Storage Service.

  4. On the Configuration page, configure the parameters as prompted.

    2

    Parameters:

    • Bucket: You can select an OSS bucket of the same Alibaba Cloud primary account in the same region from the drop-down list.

    • File name: The system displays folders under the bucket you selected. Click a folder in a bucket. Sub-folders of the folder are displayed.

    • Arrow icon: You can click the arrow icon to return to the upper-layer folder.

    • Schema name: You can specify the name of the schema in this field.

  5. After the preceding parameters are configured, click Next.

  6. When you preview the schema SQL statement, you can modify the SQL statement based on your needs.

    Currently, DLA only allows you to modify CREATE clauses.

  7. After you confirm that the SQL statement is correct, click Execute. In the Execute confirmation dialog box, click OK.

Next step

Create OSS tables