This topic describes how to create a PolarDB schema in Data Lake Analytics (DLA).

  1. Log on to the DLA console.

  2. In the left-side navigation pane, choose Serverless Pretso > SQL access point. On the SQL access point page, find your VPC in the VPC Network section and click Log on in DMS in the Actions column to create a PolarDB schema by using the following statement:

    CREATE SCHEMA `hello_polardb_vpc_rds` WITH DBPROPERTIES 
     ( 
     CATALOG = 'mysql', 
     LOCATION = 'jdbc:mysql://************.rds.aliyuncs.com:3306/hello_polardb_vpc_rds',
      USER='rds_polardb_username',
      PASSWORD='rds_polardb_password',
      INSTANCE_ID = 'rds_polardb_instance_id',
      VPC_ID = 'rds_polardb_vpcid'
     );​
    Parameters
    Parameter Description
    CATALOG='mysql' Indicates that the PolarDB database is fully compatible with MySQL. You can directly use the MySQL protocol to access the PolarDB database.
    LOCATION The format of the parameter value is jdbc:mysql://Internal endpoint of the PolarDB cluster:Port number/Name of the PolarDB database
    USER The username that is used to log on to the PolarDB database.
    PASSWORD The password of the username.
    VPC_ID The ID of the VPC to which the PolarDB cluster belongs.
    INSTANCE_ID The ID of the PolarDB cluster.