I had tried this, but it creates in the delta format, viz., the json output file contains one row for each record in the table.

And the same thing happens if I use to_json as shown below. Since the examples in the databricks docs, I'm unable to construct a proper query:

Lastly, the intension of required json output as a file, is for the file based integration with other systems.

Hope that clarifies!