Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2024 10:11 AM
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.