Write output of DataFrame to a file with tild ( ~) separator in Databricks Mount or Storage Mount with VM.

[sgannavaram]

I need to write output of Data Frame to a file with tilde ( ~) separator in Databricks Mount or Storage Mount with VM. 

Could you please help with some sample code if you have any?

[Hubert-Dudek · Accepted solution]

@Srinivas Gannavaram​ ,

Does it have to be CSV with fields separated by ~?

If yes is enough to add .option("sep", "~")

(df
.write
.option("sep", "~")
.csv(mount_path))

[sgannavaram]

Thank you Hubert, It's helpful.

[Kaniz]

Hi @Srinivas Gannavaram​ , Great to hear that you got an answer. Would you like to mark @Hubert Dudek​ 's answer as the best?

[Kaniz]

Hi @Srinivas Gannavaram​ , How are you? Does the code provided by @Hubert Dudek​ help you?

[sgannavaram]

Yes, Kaniz