Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2024 11:25 PM
Thank you for your response @Retired_mod .
I resolved to adding the tables using this type of script:
%sql
-- Create table in Metastore for Bronze Tables
CREATE TABLE xxx_dataplatform_dev_dbx.bronze.x_x
(
date STRING,
orgid LONG,
org STRING,
advertiserid LONG,
advertiser STRING,
campaignid LONG,
campaign STRING,
adgroupid LONG,
adgroup STRING,
siteid LONG,
site STRING,
platformid LONG,
platform STRING,
imps LONG,
clicks LONG,
media_spend DOUBLE,
tech_spend STRING,
tech_fee DOUBLE,
currency STRING,
sourceSystem STRING,
loadDate STRING
)
USING DELTA
LOCATION 'abfss://bronze@dataplatformdevadls.dfs.core.windows.net/X/XX/';
And that works well. I will look into what you mention here and see if it gives a better workflow experience, otherwise this was fine!
Appreciate you responding to my question 🙂
