Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-20-2026 02:49 AM
%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")
AT
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-20-2026 03:22 AM
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
