Exporting data from databricks to external csv

[ronaldolopes]

I need to export some data from the database to csv which will be downloaded to another application. What would be the procedure for that? I don't have a lot of knowledge in DataBricks and I didn't find much information in the documentation.

Thanks.

[AmanSehgal · Accepted solution]

• You can manually download data to your local in CSV from databricks notebook cell and pass it to your another application.
• Your application can run Databricks notebook inside a workflow via an API that writes data to S3 bucket in CSV and in response you get the S3 location. You can then download the file from the bucket.
• In the above step you can also make use of lambda function for an asynchronous call.