[Feature]: Create External Table for GCP

[reason1241]

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?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @reason1241. Thanks for reaching out to us.

This parameter is already ready in our SDK (

terraform-provider-snowflake/pkg/sdk/external_tables.go

Line 100 in 9c4a117

GoogleCloudStorageIntegration *string `ddl:"parameter,single_quotes" sql:"INTEGRATION"`

), 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.