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.

[sgannavaram]

Yes, Kaniz