azureazure-synapsedata-lakedata-lakehouse

Does Azure Synapse Analytics Database designer do not support Delta format

According to Doc

Currently, Delta format support for lake databases is not supported in Synapse Studio.

Does it means, at present database designer do not support the Delta format to visually create the lake database tables?

Solution

  • As per the Documentaion you cannot create lake database tables using the DELTA Format directly. enter image description here

    As you can see from the above only Delimited & Parquet formats are available to visually create lake database tables.

    Know more about Delta Lake &Key features

    I have reproduced to create Lake database using the Spark SQL In synapse notebook.

    Step 1: Create Lake database using the below CREATE DATABASE lakedatabase0202 enter image description here enter image description here

    Step 2: create table using from storage account

    USE lakedatabase02;
CREATE  TABLE employee
USING delta
LOCATION  'abfss://<container>@<storageaccount>.dfs.core.windows.net/path/to/deltafiles';

    Step 3: Describe database

    DESCRIBE  DATABASE lakedatabase02

    enter image description here

    Using Spark SQL langauge in synapse notebooks you can create lake database tables with DELTA format.