Support for Unistore Hybrid tables

[Aishwarya-Kota]

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

• Add a parameter to the table provider to make it HYBRID
• Add a separate resource to support the HYBRID tables

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]

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]

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.!

[robinreeves]

This feature is now GA. Is it on the roadmap?

Lack of Terraform support is preventing my company from using this feature, which we could really use. If this feature isn't added soon, we will be forced to use a traditional RDBMS and forgo using Snowflake as a row-store in the future as we can't delay initiatives requiring it.

[sfc-gh-asawicki]

Hey @robinreeves! Can you please contact your account manager on the Snowflake side and ask them to contact me and @sfc-gh-sthyagaraj?

[ajosh2]

@sfc-gh-asawicki , Several companies are trying to use Hybrid table and deploy them though Terraform, but lack of support of this feature in terraform-provider is a blocker. how can it be prioritized on road map?

[robinreeves]

@ajosh2 Our Snowflake rep has indicated it won't be prioritized. Use an RDBMs instead.

[sfc-gh-asawicki]

Hey @ajosh2. As I stated in my previous comment, you can reach out to your account manager and ask to contact me and @sfc-gh-sthyagaraj.