Exporting data from databricks to external csv

ronaldolopes
New Contributor

‎09-05-2022 06:41 AM

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.

Labels:
0 Kudos

AmanSehgal
Honored Contributor III

‎09-05-2022 07:01 AM

  • 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.

View solution in original post

0 Kudos