Prerequisites
Before using the function of one-click data warehouse (one-click DW), perform the following steps:
Note: Before creating an Object Storage Service (OSS) data warehouse, make sure that Data Lake Analytics (DLA), ApsaraDB for RDS (RDS), and OSS are in the same region. Otherwise, the one-click DW function is unavailable.
RDS
Create an RDS instance as the data source according to your service requirements. For more information, see Quick Start for MySQL, Quick Start for SQL Server, Quick Start for PostgreSQL, or Quick Start for PPAS.
OSS
When using the OSS bucket as a data warehouse for storing RDS data or data in a user-created database based on Elastic Compute Service (ECS), perform the following steps:
-
You can determine whether to create a folder to store RDS data based on your business needs.
DLA
Procedure
-
After you create a data warehouse, you can synchronize data at any time, create the same table structure in the target data warehouse (OSS data warehouse) as in the data source (RDS instance or user-created ECS-based database), and create a corresponding data warehouse table structure in DLA.