[Feature]: Create new resource to create SNOWFLAKE.ML.CLASSIFICATION models

[danu165]

Use Cases or Problem Statement

We need the ability to create/update/drop classification models through terraform as we will only allow classification models to be created through terraform.

A simple example of a create statement looks like this:

CREATE OR REPLACE SNOWFLAKE.ML.CLASSIFICATION model(
    INPUT_DATA => SYSTEM$REFERENCE('view', 'binary_classification_view'),
    TARGET_COLNAME => 'label'
);

Docs on CREATE CLASSIFICATION: https://docs.snowflake.com/sql-reference/classes/classification/commands/create-classification
Docs on ALTER CLASSIFICATION: https://docs.snowflake.com/sql-reference/classes/classification/commands/alter-classification
Docs on DROP CLASSIFICATION: https://docs.snowflake.com/sql-reference/classes/classification/commands/drop-classification
Docs on SHOW CLASSIFICATION: https://docs.snowflake.com/sql-reference/classes/classification/commands/show-classification

Category

category:resource

Object type(s)

No response

Proposal

Create a new resource, perhaps named snowflake_ml_classification that implements the CREATE/ALTER/SHOW/DROP statements as documented in the use cases section.

How much impact is this issue causing?

Low

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jmichalak]

Hey @danu165. Thanks for reaching out to us.

SNOWFLAKE.ML.CLASSIFICATION is still in preview, so it is not part of the V1 scope. For now, you can use https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/unsafe_execute, which can run any SQL statement. We will also welcome a contribution (check https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/CONTRIBUTING.md).

cc: @sfc-gh-sthyagaraj

[danu165]

Hi @sfc-gh-jmichalak, I see that CLASSIFICATION is now GA: https://docs.snowflake.com/en/release-notes/2024/other/2024-11-12-ml-functions-classification-ga

We do not have an option to use unsafe_execute due to its risks. Will this be considered for V1 scope now? Same question applies for #2895

[sfc-gh-asawicki]

Hey @danu165.

Unsafe execute will be a part of V1: https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/ROADMAP.md#which-resources-will-be-declared-stable.

[danu165]

@sfc-gh-asawicki what about this classification resource and granting classification roles? Unsafe_execute is unlikely to be approved in our org. Even if it was, there would eventually be a lot of upheaval to migrate from unsafe_execute to the dedicated classification resources which would create a poor user experience on our side.

[sfc-gh-asawicki]

Currently, this is the only option to manage them through Terraform using our provider. ALternatively, we are open for contributions (following the guidelines).