All Products
Search
Document Center

Create schemas by using the wizard

Last Updated: Aug 13, 2019

This topic describes how to configure the ApsaraDB for RDS (RDS) data source and Object Storage Service (OSS) data warehouse (new schemas) by using the wizard.

Procedure

  1. Log on to the Data Lake Analytics console.

  2. In the upper-left corner of the page, select the region where your DLA service is located.

  3. In the left-side navigation pane, click Schema.

  4. On the Schema page, click Create Schema.

  5. On the Popular tab of the New Schema page, click Create By Wizard under One Click Data Warehouse.

    Create by Wizard

  6. Authorize DLA to access OSS and RDS. After authorization, click Next.

    Note: This authorization grants the OSS and RDS read-only permission to DLA.

  7. Configure the RDS source data and OSS warehouse for storing data as prompted.

    Set up the source data for interconnection

    Category Parameter Description
    RDS List Type The type of the source data, which is ApsaraDB RDS for MySQL.

    Click the radio button for an RDS instance to add the instance to Source Data.

    Database Name The explanatory name of the RDS instance.
    Instance ID The ID of the RDS instance. The system automatically pulls RDS instances in the same region as DLA.

    You can search RDS instances by using fuzzy match.

    Source Data Server The RDS source data of OneClickDw, which is selected from the RDS instance list on the left.
    Port The connection port of the RDS instance, which is always port 3306.
    User name The username for the RDS instance.
    Password The password for the username.
    Schema name The database name of the RDS instance.

    After configuring the source data, click Test Connection to test connectivity.

    Position opening configuration Schema name The schema name, which is the RDS database name mapped in DLA.
    Location The detailed address for storing RDS data in OSS when you create the data warehouse.

    The system automatically pulls the OSS bucket in the same region as DLA. Click Select Location, where you can select buckets and objects based on your business needs.

    To use the OneClickDw function, DLA must have the permission to delete OSS data so that it can perform the Extract, Transform and Load (ETL) operations. For more information about authorization, see the topic Authorize DLA to delete OSS files.

    Sync Time The time for synchronizing RDS data to OSS.

    The default data synchronization time is 02:00 a.m. Alternatively, you can change the data synchronization time to off-peak hours based on business conditions, to minimize impact on the business during synchronization.

  8. After setting the preceding parameters, click Create to create the schema.

Notes

If RDS contains an empty table (with only the table structure but no data), DLA cannot synchronize the structure of the empty table to OSS during data synchronization, and you cannot create a mapping table for the empty table in DLA too.