One Click Data Warehouse (OneClickDw) allows you to configure the ApsaraDB for RDS (RDS) data source and Object Storage Service (OSS) data warehouse (new schema) in the Data Lake Analytics (DLA) console. The system automatically and seamlessly synchronizes data from RDS to OSS at the specified time, and creates the same table structure in OSS as in RDS. You can analyze data in OSS without creating any tables, so that online RDS services are not affected.
Before you use OneClickDw, you must create a RDS instance and an OSS bucket.
Note: Make sure that the DLA service, RDS instance, and OSS bucket are in the same region.
Create an OSS bucket as the data warehouse.
You can determine whether to create a folder to store RDS data according to your service requirements.
After you create a schema, DLA automatically synchronizes data from RDS to OSS at the specified time, creates the same table structure in OSS as in RDS, and creates a corresponding OSS table in DLA.
After you create a schema, you can synchronize data at any time, and create the same table structure in OSS as in RDS, and create a corresponding OSS table in DLA.