sfc-gh-asawicki
commented
1 week ago Hey @reason1241. Thanks for reaching out to us.
This parameter is already ready in our SDK (https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/9c4a1172da745af8f5059291e58b7cf8c8ec60c5/pkg/sdk/external_tables.go#L100), however, it is yet not exposed on the resource side. We will address this resource redesign as part of https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/ROADMAP.md#preparing-the-rest-of-the-fundamental-ga-objects-for-the-provider-v1.
In the meantime, you can use (with caution) https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/unsafe_execute capable of running any SQL statement.
Use Cases or Problem Statement
There is an official article("https://docs.snowflake.com/en/sql-reference/sql/create-external-table") for integrating snowflake external tables with GCS. It states the "INTEGRATION" parameter is necessary for integrating GCS.
However, the current "snowflake_external_table" resource doesn't support the "integration" parameter. https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/external_table
Therefore, it should be implemented to integrate snowflake external tables with GCS automatically.
Category
category:resource
Object type(s)
external table
Proposal
The parameter needs to be implemented.
How much impact is this issue causing?
High
Additional Information
None
Would you like to implement a fix?