Conversion of SQL Server DDL to databricks ddl

JRDWaghmare — Mon, 02 Sep 2024 11:12:27 GMT

Hello All,

I want some tool which can be used in Databricks to convert my SQL Server DDL to my databricks DDL ,

For example,

I have one DDL in SQL Server as below,

CREATE TABLE [schema1].[table_1]

(

[BranchKey] [int] NOT NULL,

[Branch Code1] [int] NULL,

[Zone] [varchar](255) NULL,

[Region] [varchar](255) NULL,

[Br_Open_Date] [datetime] NULL,

[ZO_Banca_Manager_ECN] [int] NULL,

[ZO_Banca_Manager_Name] [varchar](255) NULL

)

WITH

(

DISTRIBUTION = ROUND_ROBIN,

CLUSTERED COLUMNSTORE INDEX

)

Now I don't want to write any code manually to change compatible datatypes to covert above sql server ddl to databricks

Please help me to find some tool which allows me to convert this without any manual efforts.

Re: Conversion of SQL Server DDL to databricks ddl

daniel_sahal — Mon, 02 Sep 2024 11:31:13 GMT

ReMorph transpiler could might be handy here.