Support for object cloning

[radhe-kishan]

Terraform CLI and Provider Versions

Terraform v1.6.1 Snowflake 0.75.0

Use Cases or Problem Statement

We are building our pipelines with Coalesce app, it has a nice separation of developer workspace and integration(testing, production) environment. We are thinking to provide developer with a dedicated schema to work on a particular feature. This will avoid unintentional changes to testing or production environment and give a lot of flexibility to the developer.

Proposal

Can we get support for cloning schema in snowflake_schema resource? Cloning a schema is expensive task(at least time wise) and there will be many cases where we wouldn't want to clone everything. If we can even get a clone feature for schema objects that should also help to a great extent.

How much impact is this issue causing?

Medium

Additional Information

In the absence of this feature developer will either be using the integration/prod environment or they have to manually pull the required objects in their schema.

[sfc-gh-jmichalak]

Hey @radhe-kishan 👋

We won't support object cloning for any object for V1. Currently, you can either use https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/unsafe_execute or clone manually and import with terraform.

[sfc-gh-asawicki]

V1 approach for cloning: https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/v1-preparations/CHANGES_BEFORE_V1.md#object-cloning.