Databricks Export Tool
The Databricks export tool provided by RazorSQL allows users to export data from Databricks in the following formats:
- Excel Spreadsheets - The Databricks export tool can write data to XLSX / XLS files / Excel spreadsheets.
- SQL Insert Statements - The Databricks export tool can generate the corresponding SQL insert statements for the data contained in the Databricks database, and write these insert statements to an output file.
- XML - the export tool can generate XML output using the column names and data contained in the table.
- HTML - the export tool can generate HTML output using HTML tables using the column names and data contained in the Databricks table.
- Delimited files such as CSV - The export tool can separte the data using delimiters such as commas, tabs, spaces, or other delimiters of the users choosing.
- JSON - the export tool can generate JSON output using the column names and data contained in the table.
- Formatted Text - The Databricks export tool can write the data to a text file with formatting to pad any values so that all columns of data line up correctly.
The Databricks database export tool allows users to export one table at a time, or to export all tables or a selection of tables in a given Databricks database. If exporting multiple tables, the export tool allows the user to specify whether to save all of the exported data to a single file, or to create a new file for each Databricks table.
For more information on the Databricks export tool, see the following documentation:
Export Tool Documentation
