unity catalog

Thomas_Aimiuwu
New Contributor III

‎01-20-2026 02:16 AM

please how do you create a unity catalog in a free edition? 

AT
0 Kudos

szymon_dybczak
Esteemed Contributor III

‎01-20-2026 02:35 AM

Hi @Thomas_Aimiuwu ,

Unity Catalog is preconfigured for you in Free Edition. You should have access to default catalog called workspace:

szymon_dybczak_0-1768905257178.png

Of course if you need to create your own catalog you can do it using UI or SQL:

CREATE CATALOG demo

View solution in original post

Thomas_Aimiuwu
New Contributor III
In response to szymon_dybczak

‎01-20-2026 02:42 AM

thanks @szymon_dybczak

AT
0 Kudos

Thomas_Aimiuwu
New Contributor III

‎01-20-2026 02:47 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
0 Kudos

Thomas_Aimiuwu
New Contributor III

‎01-23-2026 05:55 AM

create table demo.cases_test as
select * from csv.`/Volumes/workspace/demo/raw/cases_test.csv`
WITH (
  header = "true",
  inferSchema  "true"
);
 
The above query also works for csv file and below works for json,parquet files respectively
 %sql
drop table if exists demo.constructors;
create table demo.constructors as
select * from json.`/Volumes/workspace/demo/raw/constructors.json`
 %sql
drop table if exists demo.constructors;
create table demo.constructors as
select * from parquet.`/Volumes/workspace/demo/raw/constructors.parquet`
Once @szymon_dybczak  thanks again, really appreciate
AT
0 Kudos