Snowflake-Labs / terraform-provider-snowflake

Terraform provider for managing Snowflake accounts
https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest
MIT License
552 stars 420 forks source link

[General Usage]: Unable to fetch data source through snowflake_system_get_privatelink_config. #3099

Closed ravisingh27 closed 2 months ago

ravisingh27 commented 2 months ago

Terraform CLI Version

1.7.5

Terraform Provider Version

0.89.0

Terraform Configuration

we are unable to fetch the data through terraform data source, for this account - NV34080.

data.snowflake_system_get_privatelink_config.snowflake_private_link.aws_vpce_id

Category

category:data_source

Object type(s)

No response

Expected Behavior

We should be getting the service_name through this data source.

Actual Behavior

it gives us service name is empty

Steps to Reproduce

create a endpoint attach the service_name through - terraform data source data.snowflake_system_get_privatelink_config.snowflake_private_link.aws_vpce_id

How much impact is this issue causing?

Low

Logs

No response

Additional Information

No response

sfc-gh-jmichalak commented 2 months ago

Hi @ravisingh27 👋 This is probably a duplicate of https://github.com/Snowflake-Labs/terraform-provider-snowflake/issues/1630. As a workaround, please set QUOTED_IDENTIFIERS_IGNORE_CASE = FALSE, as mentioned in the comments. Note that this parameter affects all other objects in Snowflake.

The answer by @sfc-gh-asawicki is still valid:

Reworking the SYSTEM$ function datasources was not our priority for V1, but we were thinking about introducing the generic datasource as a replacement. In the meantime, we will accept contributions following our guidelines.

ravisingh27 commented 2 months ago

@sfc-gh-jmichalak Thanks. It worked