Add a table in Databricks

In Databricks, you can easily create a table from a data file (e.g. csv).

Go to the Data section, click on the default database and then click on the + (plus) sign at the top to create a new table.

For the Data source, select "Upload file" and click on "Drop file or click here to upload". Browse to the file you want to upload.

Once the file has been uploaded, click on "Create Table with UI".

Select a running Cluster and click on "Preview Table".

Finally, you should be able to specify the table attributes, such as the table and the columns name and the data type of each column.

Click on "Create Table" once you are done. You can now access the table in Databricks using Spark SQL commands.