Hi  Rishabh,

First i tired  but not working

create database if not exists sales_db
location "/mnt/lakehouse/gold/sales_db"
 
Later  started  below 

i am trying  to  create 

%sql
CREATE DATABASE IF NOT EXISTS sales_dbdb
LOCATION 'abfss://<storagelocation>.dfs.core.windows.net/<container>/sales_dbdb'

and
create table sales_dbdb.country_wise_daily_salesale
using PARQUEST as
select country, invoice_date, round(sum(quantity*unit_price),2) as total_sales from invoice_tbl group by country, invoice_date

not  working .

if have  steps   please tell me .

Shall we  create Blob container database directly  .

Thank You .

Praveen.