text: -- Databricks notebook source
  -- MAGIC %md
  -- MAGIC # Create SQL Tables
  -- MAGIC #### Using Databricks Datasets
  -- MAGIC 
  -- MAGIC Run on your "standard" and your "high concurrency" clusters. <br>
  -- MAGIC Must be user with admin privs!
  
  -- COMMAND ----------
  
  -- Drop database w/cascade if it exists
  DROP DATABASE IF EXISTS NWDEMO CASCADE;
  CREATE DATABASE NWDemo;
  -- Should return nothing
  SHOW TABLES;
  
  -- COMMAND ----------
  
  -- Set database for session
  USE NWDemo;
  
  -- COMMAND ----------
  
  -- Create tables
  DROP TABLE IF EXISTS online_retail;
  
  CREATE TABLE online_retail
  USING csv
  OPTIONS (path "/databricks-datasets/online_retail/data-001/data.csv", header "true", inferSchema "true");
  
  -- COMMAND ----------
  
  DROP TABLE IF EXISTS diamonds;
  
  CREATE TABLE diamonds
  USING csv
  OPTIONS (path "/databricks-datasets/Rdatasets/data-001/csv/ggplot2/diamonds.csv", header "true", inferSchema "true");
  
  -- COMMAND ----------
  
  SHOW DATABASES;
  
  -- COMMAND ----------
  
  SHOW TABLES;
  