topic creating tables in Databricks Free Edition Help

creating tables

Thomas_Aimiuwu — Tue, 20 Jan 2026 10:49:45 GMT

%sql

This in pay-as-you-go

create table if not exists demo.test

(country string,

indicator string,

date string,

year_week string,

value string,

source string,

url string)

using csv

options(path "/mnt/formal1/hospital_admissions.csv")

the above worked in a pay-as-you-go workspace with storage already mounted.

Below is Databricks free edition which does work but came back with an error, please is there a workaroud?

%sql

create table if not exists demo.test

(country string,

indicator string,

date string,

year_week string,

value string,

source string,

url string)

using csv

options(path "/Volumes/workspace/demo/raw/hospital_admissions.csv")

Re: creating tables

szymon_dybczak — Tue, 20 Jan 2026 11:22:02 GMT

Hi @Thomas_Aimiuwu ,

Here's a workaround. Of course adjust following piece of code to your needs.

%sql SELECT * FROM read_files( '/Volumes/workspace/demo/raw/hospital_admissions.csv', format => 'csv', sep => ',', header => true );

The reason why it doesn't work you can find at below thread:

Solved: can I use volume for external table location? - Databricks Community - 61295