search

Snowflake-Labs / terraform-provider-snowflake

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

Support for Unistore Hybrid tables #2322

Open Aishwarya-Kota opened 9 months ago

Aishwarya-Kota commented 9 months ago

Terraform CLI and Provider Versions

Terraform v1.5.4 on darwin_amd64

Use Cases or Problem Statement

As the feature https://www.snowflake.com/en/data-cloud/workloads/unistore/ is available for public review, it would be great to support the hybrid tables in terraform provider. Given the snowflake's scalability, usecases including transactional workloads will benefit out of this.

Proposal

Given the usecases of both OLAP and OLTP in the application, Few options to consider would be to

How much impact is this issue causing?

High

Additional Information

If there are any alternative workarounds to achieve this, that would be great to know.

sfc-gh-asawicki commented 9 months ago

Hey @Aishwarya-Kota. Thank you for creating the issue.

Currently, we do not plan to support the public preview features shortly. Ultimately, we will support them, but our current focus is on the GA ones.

One of the possible workarounds is to use the unsafe_execute resource. It has some limitations, though. Please familiarize yourself with the documentation and limitations (https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/unsafe_execute) before using.

Aishwarya-Kota commented 9 months ago

Thank you @sfc-gh-asawicki ! Will take a look at the TF alternate option. We may at this point use the python script to achieve it. Will look out for feature updates.!