How do I copy exported data from the Matomo Cloud S3 bucket to my AWS S3 bucket?
When using the Data Warehouse Connector in Matomo Cloud, exported data is temporarily stored in a Matomo Cloud-managed AWS S3 bucket. Exported files are retained for up to 14 days.
Matomo does not currently provide a built-in feature to automatically transfer exported data to your own AWS S3 bucket. However, you can copy the exported files yourself using tools such as AWS CLI, AWS Lambda functions, or scheduled automation workflows.
At a high level, the process involves:
- Connecting to the Matomo Cloud-managed S3 bucket.
- Authenticating with your AWS account.
- Copying the exported files to your own AWS S3 bucket.
Read the guide on how to connect and query the S3 bucket using the Data Warehouse Connector.
Once connected, you can use standard AWS S3 commands such as aws s3 cp or aws s3 sync to transfer exported data between buckets. For example:
aws s3 sync s3://matomo-export-bucket s3://my-own-bucket
You can also automate the transfer process using AWS services or other orchestration tools. For more information about AWS S3 copy and sync commands, refer to the AWS documentation.