Add Data UI & File Upload

Databricks · Data Ingestion

Theory

The quickest way to get a file into Databricks is the add data UI. Click + New → Add or upload data (or Data Ingestion in the sidebar) and you land on the Add data page. From there you can upload a CSV, TSV, JSON, Avro, Parquet or text file with Create or modify table, which previews the file, lets you fix column names and types, and writes a Unity Catalog managed Delta table. Or you can use Upload files to a volume, which just copies the raw file into a Unity Catalog volume path such as /Volumes/main/sales/raw/.

For example, Priya from finance sends targets_2026.csv. You upload it with Create or modify table, pick catalog main and schema sales, name it sales_targets, check the inferred types in the preview and click Create table. Seconds later anyone with SELECT can query main.sales.sales_targets.

Why we use it

It removes the setup work for small, one-off data. No cloud bucket, credentials or code are needed, and the result is still a governed Unity Catalog table or volume file that you can query, join and secure like any other.

When to use it

Use it for small reference files, lookups, targets or a quick demo. Do not use it for recurring loads: files that arrive every day belong in a volume or cloud storage and should be loaded with Auto Loader, COPY INTO or a Lakeflow Connect connector.

How it works

  1. Open + New → Add or upload data
  2. Do you need a table right away? Yes: Choose Create or modify table. No: Choose Upload files to a volume.
  3. Drop the file and pick catalog main and schema sales
  4. Review the preview: column names, types, header row
  5. Click Create table (or Upload)
  6. Query main.sales.<table> or read the volume file with read_files

Syntax

UI: + New → Add or upload data → Create or modify table  (or)  Upload files to a volume
SQL afterwards: SELECT * FROM main.sales.<new_table>;
Files in a volume: /Volumes/<catalog>/<schema>/<volume>/<file>

Example

-- After uploading targets_2026.csv with 'Create or modify table'
SELECT * FROM main.sales.sales_targets LIMIT 10;

-- After 'Upload files to a volume' (file is NOT a table yet)
LIST '/Volumes/main/sales/raw/';

SELECT * FROM read_files(
  '/Volumes/main/sales/raw/targets_2026.csv',
  format => 'csv',
  header => true
);

-- Turn the volume file into a table
CREATE TABLE main.sales.sales_targets AS
SELECT * FROM read_files('/Volumes/main/sales/raw/targets_2026.csv', format => 'csv', header => true);

Key points

Databricks topics

Databricks Fundamentals

Compute

Notebooks & Development

Apache Spark on Databricks

Delta Lake

Unity Catalog & Governance

Data Ingestion

Declarative Pipelines (Lakeflow)

Lakeflow Jobs

Databricks SQL & BI

Architecture, Performance & Cost

Machine Learning & AI

Certification & Interview

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Master Databricks

The lakehouse platform from the ground up: Apache Spark, Delta Lake, Unity Catalog, Lakeflow pipelines and jobs, Databricks SQL and MLflow. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice SQL / Spark SQL Sharpen the SQL you use in Databricks SQL and Spark SQL: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Databricks  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Databricks needs a real workspace — there's no in-browser engine for it. Click Copy above, then paste it into a notebook or the SQL editor in Databricks Free Edition (free, no credit card) and run it on serverless compute.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic