Plan the storage location of exported data in OBS.
You need to specify the OBS path (to directory) for storing data that you want to export. The exported data can be saved to a file in CSV format. The system also supports TEXT so that you can import the exported data to various applications.
The target directory cannot contain any files.
The user used to export data must:
You can configure ACL permissions for the OBS bucket to grant the write permission to a specific user.
You must prepare data to be exported in the database table, and the data volume per row must be less than 1 GB. Based on the data to be exported, plan foreign tables whose attributes such as columns, column types, and length match those of user data.
Click Service List and choose Object Storage Service to open the OBS management console.
For details about how to create a bucket, see OBS Console Operation Guide > Managing Buckets > Creating a Bucket in the Object Storage Service User Guide.
For example, create a bucket named mybucket.
In the OBS bucket, create a folder for storing exported data.
For details, see OBS Console Operation Guide > Managing Objects > Creating a Folder in the Object Storage Service User Guide.
For example, create a folder named output_data in the created mybucket OBS bucket.
Specify the OBS path for storing exported data files. This path is the value of the location parameter used for creating a foreign table.
The OBS folder path in the location parameter consists of obs://, a bucket name, and a file path. Example:
In this example, the OBS folder path is as follows:
When exporting data, a user must have the write permission on the OBS bucket where the data export path is located. You can configure ACL permissions for the OBS bucket to grant the write permission to a specific user.
For details, see OBS Browser Operation Guide > Bucket ACL > Configuring Bucket ACL in the Object Storage Service User Guide.