This topic describes how to import data files into an OceanBase Cloud instance. You can import files from your local drive or cloud storage (Amazon S3, Alibaba Cloud OSS, Huawei Cloud OBS, and Tencent Cloud COS) into an OceanBase Cloud instance or load sample data of various sizes for a quick experience of OceanBase Cloud.
Limitations
Only users with the Project Owner, Project Admin or Data Services Admin roles are allowed to create and check load data tasks.
Only users with the Instance Admin, Data Read/Write or Project Member roles are allowed to check load data tasks.
Considerations
Regions available for Alibaba Cloud: Singapore.
Regions available for Huawei Cloud: Singapore.
Regions available for Google Cloud Platform: Jakarta and Virginia.
Regions available for Amazon Web Services (AWS): Singapore, Tokyo, California, and Mumbai.
Data import supports both OceanBase MySQL compatible mode and OceanBase Oracle compatible mode.
For more information about file format and encoding format for data import, see Supported file formats and encoding formats for data import.
Navigate to the Load Data page
Log in to the OceanBase Cloud console and navigate to your project's cluster page. You can go the target cluster's import page as follows:
In the left-side navigation pane, click Instances. On the Instances page, click the instance name. In the Overview page of the instance, click Tenants. In the tenant list, click ... under the tenant. Click Import Data Files or Import Sample Data.
In the left navigation pane, click Instance List. On the Instance List page, click the instance name. On the Overview page of the instance, click Tenants. On the Tenants page, click Import Data. On the Import Data page, click Import Sample Data or Import Data File.
In the left navigation pane, click Instances. On the Instances page, click the instance name. On the Overview page of the instance, click Tenants. Click ... on the right, click Import Sample Data or Import Data File.
Follow these steps to import sample data:
Navigate to the Import Data page.
Click Import Sample Data.
In the Import Sample Data dialogue box, select Type, Sample Dataset and Select an empty database.
Type supports Benchmarking Test, Life Services, E-Commerce and Tech & Education. Benchmarking Test supports 25 MB, 128 MB, and 1 G data volume. You can click on the dropdown list to select an existing empty database, or click Create Database to create a new one.
Click Import. OceanBase Cloud will begin importing the sample dataset into your database. Before importing the sample data, make sure that you have prepared an empty database.
For more information on sample datasets, refer to Sample data introduction.
Follow these steps to import data files:
Open the Import Data page.
Click Import Data Files. On the Load Data page, select Local File or Cloud Storage File.
After you select Local File, you can drag and drop the local file into the upload area or click the upload area to select and upload the target local file. OceanBase Cloud only supports importing local files up to 1 GB and cloud storage files up to 10 GB. After you select Cloud Storage File, you can import files from Alibaba Cloud OSS, Huawei Cloud OBS, and Tencent Cloud COS, Amazon S3, and Google Cloud Storage into OceanBase Cloud. You can import CSV, INSERT SQL, Apache Parquet, and Apache ORC files from cloud storage to OceanBase Cloud. However, Apache Parquet and Apache ORC files are only available for OceanBase MySQL compatible mode at present.
To import cloud storage files, provide these information:
Option Description Object URL The URL for accessing the file. Region The region of the storage. AccessKey ID AccessKey ID for cloud resources AccessKey Secret Access key secret for cloud resources. Select Database Account Database account to be imported. You can choose an existing database or create a new database account. Table Table to be imported. On the Load Data page, click Preview. Follow the prompts on the page, select a database and create a table. You can edit the CSV configuration or check Skip Header and Ignore Task Errors and Continue.
After the Preview is complete, click Import. Before importing data files, make sure that you have prepared a table matching the data file's structure.
View Import Tasks
On the Overview page of the instance, click Import Data. You can view detailed information about the import tasks by clicking on Details in the Actions column.