# Databricks notebook source
# MAGIC %run ./Classroom-Setup

# COMMAND ----------

spark.sql("""CREATE TABLE IF NOT EXISTS events USING delta OPTIONS (path "{}")""".format(events_path))
spark.sql("""CREATE TABLE IF NOT EXISTS sales USING delta OPTIONS (path "{}")""".format(sales_path))
spark.sql("""CREATE TABLE IF NOT EXISTS users USING delta OPTIONS (path "{}")""".format(users_path))
spark.sql("""CREATE TABLE IF NOT EXISTS products USING delta OPTIONS (path "{}")""".format(products_path))

displayHTML("")


# Databricks notebook source
# MAGIC %run ./Classroom-Setup

# COMMAND ----------

spark.sql("""CREATE TABLE IF NOT EXISTS events USING delta OPTIONS (path "{}")""".format(events_path))
spark.sql("""CREATE TABLE IF NOT EXISTS sales USING delta OPTIONS (path "{}")""".format(sales_path))
spark.sql("""CREATE TABLE IF NOT EXISTS users USING delta OPTIONS (path "{}")""".format(users_path))
spark.sql("""CREATE TABLE IF NOT EXISTS products USING delta OPTIONS (path "{}")""".format(products_path))

displayHTML("")


# Databricks notebook source # MAGIC %run ./Classroom-Setup # COMMAND ---------- CREATE TABLE IF NOT EXISTS events USING delta OPTIONS (path "{}") CREATE TABLE IF NOT EXISTS sales USING delta OPTIONS (path "{}") CREATE TABLE IF NOT EXISTS users USING delta OPTIONS (path "{}") CREATE TABLE IF NOT EXISTS products USING delta OPTIONS (path "{}")