# Copying ScyllaDB data to S3, using Spark, performance optimization

**URL:** https://forum.scylladb.com/t/copying-scylladb-data-to-s3-using-spark-performance-optimization/3196
**Category:** ScyllaDB
**Tags:** performance, sstable, backup-restore
**Created:** [November 17, 2024, 10:46am UTC](https://forum.scylladb.com/t/copying-scylladb-data-to-s3-using-spark-performance-optimization/3196 "2024-11-17T10:46:14Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Guy](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/guy/32/9_2.png) [@Guy](https://forum.scylladb.com/u/Guy)
#### Post date: [November 17, 2024, 10:46am UTC](https://forum.scylladb.com/t/copying-scylladb-data-to-s3-using-spark-performance-optimization/3196/1 "2024-11-17T10:46:14Z")

</div>

> [@](#):
>
> [**Originally from the User Slack**](https://scylladb-users.slack.com/)
> 
> ![Nilesh_Kumar](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/2X/6/61274690e003de56d94f79a7b21dea67b9f20ec3.png) **@Nilesh\_Kumar:** Hi everybody,  
> I am looking for some way to copy the scylla table partitions key data to s3. Spark is one way but within spark as well is there any optimisation I can do to scan faster with less resource consumption of scylla so it doesn’t impact the running system?  
> Any help or direction will be of great use.  
> Data Info - Table contains billions of partitions and per partition there is just one row. I am trying to take dump of all the partition key available in the table.
> 
> Thanks
> 
> ![Felipe_Cardeneti_Mendes](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/1X/233a9d524fbc97e39f08633c16b3dd2575d1d1f4.jpeg) **@Felipe\_Cardeneti\_Mendes:** Use the token() function to scan and limit concurrency as acceptable by your source system, add bypass cache to prevent polluting the cache. See [https://www.scylladb.com/2017/03/28/parallel-efficient-full-table-scan-scylla/](https://www.scylladb.com/2017/03/28/parallel-efficient-full-table-scan-scylla/)