Explore and create tables with the Data tab
You can use the Data tab in the Data Science & Engineering workspace to create, view, and delete tables.
Databricks recommends using features in Databricks SQL to complete these tasks; the Data explorer provides an improved experience for viewing data objects and managing ACLs and the create table UI allows users to easily ingest small files into Delta Lake.
To view and create databases and tables, you must be connected to a running cluster.
View databases and tables
Click Data in the sidebar. Azure Databricks selects a running cluster to which you have access. The Databases folder displays the list of databases with the
default database selected. The Tables folder displays the list of tables in the
Click the at the top of the Databases folder.
Select a cluster.
If you have small data files on your local machine that you want to analyze with Azure Databricks, you can import them to DBFS using the UI.
This feature may be disabled by admin users. To enable or disable this setting, see Manage data upload.
Files imported to DBFS using these methods are stored in FileStore.
Create a table
When you create a table using the UI, you cannot update the table.
With the UI, you can only create external tables.
Click Data in the sidebar. The Databases and Tables folders appear.
In the Databases folder, select a database.
Above the Tables folder, click Create Table.
Choose a data source and follow the steps in the corresponding section to configure the table.
If an Azure Databricks administrator has disabled the Upload File option, you do not have the option to upload files; you can create tables using one of the other data sources.
Drag files to the Files dropzone or click the dropzone to browse and choose files. After upload, a path displays for each file. The path will be something like
/FileStore/tables/<filename>-<integer>.<file-type>. You can use this path in a notebook to read data.
Click Create Table with UI.
In the Cluster drop-down, choose a cluster.
- Select a file.
- Click Create Table with UI.
- In the Cluster drop-down, choose a cluster.
Click Preview Table to view the table.
In the Table Name field, optionally override the default table name. A table name can contain only lowercase alphanumeric characters and underscores and must start with a lowercase letter or underscore.
In the Create in Database field, optionally override the selected
In the File Type field, optionally override the inferred file type.
If the file type is CSV:
- In the Column Delimiter field, select whether to override the inferred delimiter.
- Indicate whether to use the first row as the column titles.
- Indicate whether to infer the schema.
If the file type is JSON, indicate whether the file is multi-line.
Click Create Table.
In the Create New Table UI you can use quickstart notebooks provided by Azure Databricks to connect to any data source.
- DBFS: Click Create Table in Notebook.
- Other Data Sources: In the Connector drop-down, select a data source type. Then click Create Table in Notebook.
The table details view shows the table schema and sample data.
Click Data in the sidebar.
In the Databases folder, click a database.
In the Tables folder, click the table name.
In the Cluster drop-down, optionally select another cluster to render the table preview.
To display the table preview, a Spark SQL query runs on the cluster selected in the Cluster drop-down. If the cluster already has a workload running on it, the table preview may take longer to load.
- Click Data in the sidebar.
- Click the next to the table name and select Delete.
Submit and view feedback for