Running DDL Commands

Fire Insights allows you to run DDL commands on Databricks.

With this one can:

  • Create New Databases
  • Create New Tables
  • View the schema of the tables
  • And many more

Go to DATABROWSERS/Databricks DB. Then click on DDL.

Databricks has a good page on Creating New Tables:

https://docs.databricks.com/spark/latest/spark-sql/language-manual/create-table.html

Below are example of running DDL

Creating Table

  • DDL Statement:

    CREATE TABLE `employee` (`id` INT, `name` STRING) USING com.databricks.spark.csv OPTIONS ( `multiLine` 'false', `escape` '"', `header` 'true', `delimiter` ',', path 'dbfs:/FileStore/tables/employee.csv' );

Location of the data could be changed to S3 location.

Databricks

Running SQL

  • Select SQL Statement:

    select count(*) as count  from employee;
Databricks

Sample Data:

  • Select SQL Statement:

    select * from employee;

By default first 100 rows of data is displayed.

Databricks

Drop Table

  • Drop Statement:

    drop table employee;
Databricks