feat: Table Column Defaults

[robbruce]

Add support for column defaults on the snowflake_table resource. Note there are some limitations:

• ALTER TABLE MODIFY COLUMN does not support adding a default; unless a sequence has been used originally as the default and a new sequence is being used
• ALTER TABLE ADD COLUMN only supports setting a column default to a constant value

Test Plan

• acceptance tests
• unit tests
• ran make docs

References

• https://docs.snowflake.com/en/sql-reference/sql/create-table.html#optional-parameters Default section

[alldoami]

/ok-to-test sha=a654ce1

[github-actions]

Integration tests failure for a654ce1

[robbruce]

@alldoami - I've corrected the failed TestSequenceRead unit test; some of the other unit tests I can't run locally just to account level conflicts we already have enabled, e.g. SCIM.

[alldoami]

/ok-to-test sha=85a1a43

[github-actions]

Integration tests failure for 85a1a43

[alldoami]

Looks like there is a panic: runtime error: invalid memory address or nil pointer dereference in the TestAcc_Table test

[robbruce]

@alldoami - sorted. I hadn't correctly accounted for new columns being added without a default value 🤦 . Working now

$ TF_ACC=1 go test -v ./... -run TestAcc_Table
?   	github.com/chanzuckerberg/terraform-provider-snowflake	[no test files]
testing: warning: no tests to run
PASS
ok  	github.com/chanzuckerberg/terraform-provider-snowflake/pkg/datasources	(cached) [no tests to run]
?   	github.com/chanzuckerberg/terraform-provider-snowflake/pkg/db	[no test files]
testing: warning: no tests to run
PASS
ok  	github.com/chanzuckerberg/terraform-provider-snowflake/pkg/provider	(cached) [no tests to run]
=== RUN   TestAcc_Table
=== PAUSE TestAcc_Table
=== RUN   TestAcc_TableDefaults
=== PAUSE TestAcc_TableDefaults
=== CONT  TestAcc_Table
=== CONT  TestAcc_TableDefaults
--- PASS: TestAcc_TableDefaults (11.76s)
--- PASS: TestAcc_Table (59.63s)
PASS
ok  	github.com/chanzuckerberg/terraform-provider-snowflake/pkg/resources	59.982s
testing: warning: no tests to run
PASS
ok  	github.com/chanzuckerberg/terraform-provider-snowflake/pkg/snowflake	(cached) [no tests to run]
?   	github.com/chanzuckerberg/terraform-provider-snowflake/pkg/testhelpers	[no test files]
testing: warning: no tests to run
PASS
ok  	github.com/chanzuckerberg/terraform-provider-snowflake/pkg/validation	(cached) [no tests to run]
?   	github.com/chanzuckerberg/terraform-provider-snowflake/pkg/version	[no test files]

[alldoami]

/ok-to-test sha=0ef8734

[github-actions]

Integration tests failure for 0ef8734

[robbruce]

@alldoami - anything in the logs to suggest what else needs correcting?

[alldoami]

/ok-to-test sha=8fc3a2b

[github-actions]

Integration tests success for 8fc3a2b