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.
