topic Re: Data type length enforcement in Data Engineering

Data type length enforcement

elgeo — Wed, 15 Feb 2023 13:56:42 GMT

Hello. Is there a way to enforce the length of a column in SQL? For example that a column has to be exactly 18 characters? Thank you!

Re: Data type length enforcement

elgeo — Thu, 23 Feb 2023 08:20:13 GMT

Hi @Kaniz Fatma. Thank you for your feedback. However, my question is if we can enforce a column to have exactly a number of characters, not less than a number. For example an iban needs to have exactly 34 chars, not less than 34 not more than 34.

Re: Data type length enforcement

elgeo — Thu, 23 Feb 2023 09:50:43 GMT

Thank you @Kaniz Fatma. This is exactly what I was looking for.

Re: Data type length enforcement

databricks31 — Mon, 04 Mar 2024 07:26:29 GMT

we are facing similar issues while write into adls location delta format, after that we created on top delta location unity catalog tables. below format of data type length should be possible to change spark sql supported ?

Azure SQL Spark SQL supported ?
column1 nvarchar(5) --> column1 <how to set custome datatype length>
startdate datetime2 ----> startdate <how to set custome datatype length>
enddate datetime2(0) ---> enddate <how to set custome datatype length>