Synonyms and aliases are not allowed. Timestamp data types should be defined explicitly.
If data type has additional parameters (e.g. length), the full form should be used in all cases.
- SnowDDL uses an actual data types obtained from
DESCcommands to compare config with Snowflake metadata. Values should be exactly the same.
- It is much easier to find & replace data types in config when exactly the same syntax is being used in all cases. Especially when you have 1000+ tables to manage.
- TIMESTAMP data types have significant differences and are affected by various ACCOUNT PARAMETERS. It is very important for data engineers to understand it and to pick the correct data type depending on specific use case.