After using snowflake_tag_association to set tag on account, subsequent terraform plan/apply fail with "error listing tag associations". #1910
Labels
bug
Used to mark issues with provider's incorrect behavior
Provider Version
0.64.0
Terraform Version
1.3.9
Describe the bug
The first attempt to set tags on the account using
snowflake_tag_association
succeeds. However, afterwards any attempt to runterraform plan
orapply
fail witherror listing tag associations
, because theGET_TAG
function is invoked using account name (e.gSANDPIT01_AWS_EW1_DEV
instead of account locator (e.g.KP44023
).Example of failing SQL query:
The above query succeeds if
SANDPIT01_AWS_EW1_DEV
is replaced withKP44023
.It is not an option to use account locator in
object_identifier
, since the SQL generated to set the tag explicitly mentions the account:(The Snowflake documentation specifies a syntax without account name for 'ALTER ACCOUNT SET TAG', and even though it works
with account name, the same query fails when replacing account name with account locator.)
Expected behavior
When listing tag associations on the account (during
plan
orapply
), the provider should use a query that correctly retrieves the tag.Code samples and commands
Please add code examples and commands that were run to cause the problem.
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered: