I have a need to export a Crate DB table to S3, I can do this with COPY TO command by providing s3 endpoint. But I need this to be exported to a different S3 endpoint and not default AWS S3 endpoint. How to provide the alternate s3 endpoint and credentials?

Export table using COPY TO command to alternate S3 endpoint

miguel.arregui May 28, 2020, 6:11pm 2

Hi,

What command are you using, could I see it?

This is the supported syntax to define an end point in the latest release:

s3://[<accesskey>:<secretkey>@]<bucketname>/<path>

Kind regards

How to export data using `COPY TO` to non-Amazon object storage?

Topic		Replies	Views
How to export data using `COPY TO` to non-Amazon object storage? CrateDB	2	648	November 22, 2021
If I use use COPY TO for a big table with many shards, will there be different files on different nodes? CrateDB	1	553	September 13, 2021
Setting MinIO as a CrateDB backup repository Tutorials integration , data-storage	3	1077	December 21, 2021
Snapshot restore is failing CrateDB	0	574	November 17, 2021
Why does COPY TO create empty JSON files and how is data distributed to these files? SQL	1	636	November 12, 2021