How Do I Migrate Data from OBS/S3 to ClickHouse?
Question
How do I migrate data from OBS/S3 to ClickHouse?
Answer
- Query data stored in S3.
select * from s3(path [,access_key_id, secret_access_key] [,format] [,structure])
- path: bucket URL with a file path.
- format: The file format.
- access_key_id and secret_access_key: long-term credentials of an account. Credentials can be used to authenticate requests. These parameters are optional. If no credential is specified, credentials are read from the configuration file.
- structure: The table schema.
- Obtain data from S3 to create a table.
CREATE TABLE test1_s3 (name String, value UInt32) ENGINE = S3(path, [access_key_id, secret_access_key,] format)
- View the created table.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.