Exporting data from databricks

[DimitrisMpizos]

I couldn't find in documentation a way to export an RDD as a text file to a local folder by using python. Is it possible?

[raela]

Sounds like you're looking for saveAsTextFile().

Refer to the documentation here:

https://spark.apache.org/docs/latest/api/python/pyspark.html#pyspark.RDD.saveAsTextFile

[miklos]

You can use the FileStore to save a data file to that location and retrieve it by going to your shard and retrieve it there. Look at the Databricks Guide -> Product Overview -> FileStore.

You can access the files saved there by going to:

https://xxxxx.cloud.databricks.com/files/folder/specific_file

[nassir_m]

What is the code to save a data object to the file store? I have a list object with JSON elements that I want to save to local disk, but am unable to do so.

[lefish]

Hello all, hello ​@Miklos_C​ ,

How do you access the files? I don't understand what is the "xxxx" in the URL "https://xxxxx.cloud.databricks.com/files/folder/specific_file". Do we need to replace it with the 16-numbers sequence that identifies us? With our username/mail adress? I'm using Databricks Community Edition, do I need to put the string "community" somewhere?

Thank you for your answer

Have a nice day

[gachet]

Do you know what is xxxxx in the URL?, I have the same problem.

Regards

Diego

[lefish]

Simply replace it with "community"

Thibault

[gachet]

Thanks a lot. It works !!

[gachet]

do you know how to acces the filestore with wget?

[lefish]

Absolutely not... 😞

[Bill_Chambers]

This won't work because you'd have to authenticate with Databricks in order to download it. This is suitable for doing things like loading javascript libraries but not for extracting data from Databricks. In order to download data you should connect to amazon S3 or use the DBFS api.

http://docs.databricks.com/spark/latest/data-sources/amazon-s3.html

http://docs.databricks.com/api/latest/dbfs.html

[gachet]

Thank you for the answer.

[grfiv]

I use s3 as an intermediary. rdd.saveAsTextFile("s3a://...")

[PaulLintilhac]

there should really be a way to simply export a file to your desktop

[Manu1]

To: Export a file to local desktop

Workaround : Basically you have to do a "Create a table in notebook" with DBFS

The steps are:

1. Click on "Data" icon >
2. Click "Add Data" button >
3. Click "DBFS" button >
4. Click "FileStore" folder icon in 1st pane "Select a file from DBFS" >
5. In the 2nd pane, scroll down to locate folder icon "tables" >
6. Click to select folder icon "tables" >
7. In the 3rd pane, Click to select folder icon "FileStore" >
8. In the 4th pane, Click to select folder icon "tables" >
9. In the 5th pance locate your file, (mine was a .csv), click to select >
10. Click "Create table in Notebook" button >
11. This will create a notebook >
12. Click on "Run All" to run the notebook (create clustes, if needed) >
13. Click "OK" when prompted to "Attach and Run" >
14. There would be download ICON in a couple of places which you can click to download to the local machine.

(Tweak this notebook to download different files)