02_BronzeSQL.sql

-- Databricks notebook source
-- MAGIC %run ./Include

-- COMMAND ----------

-- MAGIC %python
-- MAGIC dbutils.widgets.text('username', get_user_name())

-- COMMAND ----------

CREATE OR REPLACE TABLE ${username}.Airlines_Bronze AS
SELECT * FROM ${username}.airlines_pt0_csv

-- COMMAND ----------

SELECT * FROM ${username}.Airlines_Bronze

-- COMMAND ----------

describe detail ${username}.airlines_pt0_csv

-- COMMAND ----------

describe detail ${username}.Airlines_Bronze

-- COMMAND ----------

-- MAGIC %fs ls /user/hive/warehouse/odl_instructor_637201.db/airlines_bronze

-- COMMAND ----------