unity catalog

[Thomas_Aimiuwu]

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

[szymon_dybczak · Accepted solution]

Hi @Thomas_Aimiuwu ,

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

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

CREATE CATALOG demo

[Thomas_Aimiuwu]

thanks @szymon_dybczak

[Thomas_Aimiuwu]

%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")