terraform-provider-snowflake icon indicating copy to clipboard operation
terraform-provider-snowflake copied to clipboard
verified publisher icon Snowflake-Labs

Map Snowflake alias data types to actual data types

Open doino-gretchenliev opened this issue 3 years ago • 1 comments

Provider Version

0.34.0

Terraform Version

0.14.2

Describe the bug

When you create a table with columns using alias data types like SMALLINT, Snowflake replaces those aliases with the actual data type used. In this case NUMBER(38,0). That causes changes to the table each time you apply. It would be nice if those TF recognize the usage of an alias.

doino-gretchenliev avatar May 30 '22 16:05 doino-gretchenliev

@doino-gretchenliev, this can be considered a duplicate of #494. The main discussion there is related to differences like TIMESTAMP_NTZ -> TIMESTAMP_NTZ(9), so I think it would be valuable for you to mention alias data types too.

adamantike avatar Jun 03 '22 01:06 adamantike

Duplicate of https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/494

sfc-gh-ngaberel avatar Jun 22 '23 00:06 sfc-gh-ngaberel