Load data
The following steps will guide you through setting up a Databricks account and uploading the demo dataset, which is stored as CSV files in a public S3 bucket.
First, download the following files to your local machine:
line_items.csv
(opens in a new tab)orders.csv
(opens in a new tab)users.csv
(opens in a new tab)products.csv
(opens in a new tab)
Next, let's ensure we have a SQL warehouse that is active. Log in to your Databricks account, then from the sidebar, click on SQL → SQL Warehouses:
Ensure the warehouse is active by checking its status; if it is inactive, click
▶️ to start it.
Next, click New → File upload from the sidebar, and upload
line_items.csv
. The UI will show a preview of the data within the file; when
ready, click Create table.
Repeat the above steps for the three other files.