# Extracting data from Scylla for data mining

**URL:** <https://forum.scylladb.com/t/extracting-data-from-scylla-for-data-mining/692>\
**Category:** ScyllaDB\
**Tags:** integration\
**Created:** [July 12, 2023, 9:46pm UTC](https://forum.scylladb.com/t/extracting-data-from-scylla-for-data-mining/692 "2023-07-12T21:46:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bill\_Dunmire](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/bill_dunmire/32/235_2.png) [@Bill\_Dunmire](https://forum.scylladb.com/u/Bill_Dunmire)\
**Post date:** [July 12, 2023, 9:46pm UTC](https://forum.scylladb.com/t/extracting-data-from-scylla-for-data-mining/692/1 "2023-07-12T21:46:38Z")

</div>

I would like to extract data in batches from ScyllaDB and dump them into files or an OLAP database for data mining. Do you have a suggestion?

---

<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:** [July 13, 2023, 9:00am UTC](https://forum.scylladb.com/t/extracting-data-from-scylla-for-data-mining/692/2 "2023-07-13T09:00:03Z")

</div>

There are a number of ways to achieve this. One is using Presto (see [this tech talk](https://www.scylladb.com/tech-talk/gps-insight-on-using-presto-with-scylla-for-data-analytics-and-data-archival/)).  
Another is by using Spark with ScyllaDB. By doing so, you deploy analytics workloads on information stored in ScyllaDB. You can learn more about this and see a hands-on lab in the [Using Spark with ScyllaDB](https://university.scylladb.com/courses/the-mutant-monitoring-system-training-course/lessons/using-spark-with-scylla/) lesson on ScyllaDB University.