Databricks uses Delta Lake as the default format for storing output data and tables. Delta Lake is an open-source storage layer that brings reliability and performance to data lakes. It offers ACID transactions, scalable metadata handling, and unified batch and streaming data processing.

While Delta Lake is the default, Databricks also supports various other output formats, including:

• Parquet: A columnar storage format widely used for efficiency in the extensive data ecosystem.
• ORC: Another columnar format that offers similar benefits to Parquet.
• CSV: A simple text format for storing tabular data.
• JSON: A standard format for semi-structured data.

You can choose the desired output format based on your requirements and use cases. Databricks provides flexibility in working with different data formats to suit diverse needs.