How to connect to oralce database and import the data into csv format using dask?

Question

---

How can I connect to oracle database using dask and fetch the data from it and create a csv file using the fetched data.

Answer 1

You can read a SQL table into a Dask DataFrame with dask.dataframe.read_sql_table.

This question should help you create a Dask DataFrame from an Oracle table.

You can use to_csv to write out CSV files after creating the DataFrame.

It'll look something like this:

import dask.dataframe as dd

ddf = dd.read_sql_table(...)
ddf.to_csv(...)