gpt4 book ai didi

Does Azure Synapse Analytics Database designer do not support Delta format(Azure Synapse Analytics数据库设计器是否不支持Delta格式)

转载 作者:bug小助手 更新时间:2023-10-28 13:33:21 26 4
gpt4 key购买 nike



According to Doc

根据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?

这是否意味着,目前数据库设计器不支持Delta格式来可视化地创建Lake数据库表?


更多回答
优秀答案推荐


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

根据Documentaion,您不能直接使用Delta格式创建Lake数据库表。


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

从上面可以看到,只有带分隔符和拼图的格式可用于可视化地创建Lake数据库表。



  • The current version of Delta Lake included with Azure Synapse has language support for Scala, PySpark, and .NET and is compatible with Linux Foundation Delta Lake.


Know more about Delta Lake &Key features

了解更多关于Delta Lake和主要特征的信息


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

我已经复制创建湖数据库使用Spark SQL in Synapse笔记本电脑。


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

步骤1:使用下面的创建数据库lakedata ase0202创建Lake数据库


Step 2: create table using from storage account

步骤2:使用来自存储帐户创建表


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

Step 3: Describe database

步骤3:描述数据库


DESCRIBE  DATABASE lakedatabase02

enter image description here


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

使用Synapse笔记本中的Spark SQL语言,您可以创建Delta格式的Lake数据库表。


更多回答

26 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com