I have have a Delta Table Path. Based on this, I am trying to create table using

create table if not exists dbo.DimCustomer
(CustomerSK BIGINT GENERATED BY DEFAULT AS IDENTITY,
first_name varchar(128),
last_name varchar(128),
HashKey binary,
DWIsEncryptedFl tinyint,
DWCreateDt timestamp NOT NULL,
DWLastUpdateDt timestamp NOT NULL)
USING DELTA location ‘/mnt/datalake/prepped/dimcustomer.delta/’
TBLPROPERTIES (‘delta.columnMapping.mode’ = ‘name’, ‘delta.minReaderVersion’ = ‘2’, ‘delta.minWriterVersion’ = ‘5’)

This gives AnalysisException: The specified schema does not match the existing schema at dbfs:/mnt/datalake/prepped/dimcustomer.delta

and it suggests to use String for first_name, last_name.
However when I used String to replace, then again it fails with same error, but this time it suggests to use varchar(128)

Unable to fix the issue.
Any help will be hugely appreciated.

Tried to Diagnose Error and the solution provided but didn’t work