Databricks - CSV File - Create table and Query a CSV File
%sql
CREATE DATABASE IF NOT EXISTS Databricks;
USE Databricks;
CREATE TABLE IF NOT EXISTS AirlineFlight
USING CSV
OPTIONS (
header="true",
delimiter=",",
inferSchema="true",
path="dbfs:/mnt/training/asa/flights/small.csv"
);
CACHE TABLE AirlineFlight;
SELECT * FROM AirlineFlight;
SELECT COUNT(*) FROM AirlineFlight;
