Requirement

In our previous post, we have learned about Delta Lake and Delta Table in Databricks. In this post, we are going to create a Delta table with the schema.

Solution

For creating a Delta table, below is the template:

 CREATE TABLE <table_name> (
<column name> <data type>,
<column name> <data type>,
..)
USING DELTA;

Here, USING DELTA command will create the table as a Delta Table. It will have the underline data in the parquet format.

With the same template, let’s create a table for the below sample data:

Sample Data

 CREATE TABLE employee_delta (
      empno INT,
      ename STRING,
      designation STRING,
      manager INT,
      hire_date DATE,
      sal BIGINT,
      deptno INT,
      location STRING
) USING DELTA;

Wrapping Up

In this post, we have learned how to create a delta table with the defined schema. Once the table gets created, you can perform insert, update using merge, delete data from the table. We will see all this exercise in coming posts.

Sharing is caring!

Subscribe to our newsletter

Name*

Email*