The meshlet creates columns with data types with the full length to prevent any data integrity issues. That is, a VARCHAR data type (what is generally created for a string field) is created as VARCHAR without a specified column length as you would in other databases. This is the equivalent of creating it as the maximum VARCHAR(16777216) since there is no performance impact whether you use the full length declaration of a column data type or a smaller size. As well, this means that when column lengths are extended in ServiceNow, this does not need to be changed in Snowflake. |