Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SNOW-1348103: Allow importing user defined functions (UDF) #1079

Closed
rubemz opened this issue Jun 27, 2022 · 2 comments
Closed

SNOW-1348103: Allow importing user defined functions (UDF) #1079

rubemz opened this issue Jun 27, 2022 · 2 comments
Labels
category:resource feature-request Used to mark issues with provider's missing functionalities resource:function Issue connected to the snowflake_function resource

Comments

@rubemz
Copy link

rubemz commented Jun 27, 2022

Is your feature request related to a problem? Please describe.

There is already support for snowflake user defined functions, but there isn't a way to properly import them. See that the import section is not even available on the documentation page

Additional context

Even though it is not documented, there is a way to import UDFs running (very similar how the external function import works)

terraform import snowflake_function.example 'dbName|schemaName|functionName|varchar-varchar-varchar'

However, after importing the function snowflake is forcing me to recreate the function, because it does not properly recognize the db name, comment field, etc so my guess is that the import is not fully implemented and that's why it is not documented yet.

Importing UDF would be very helpful to manage existing functions.

@rubemz rubemz added the feature-request Used to mark issues with provider's missing functionalities label Jun 27, 2022
@sfc-gh-jcieslak sfc-gh-jcieslak added category:resource resource:function Issue connected to the snowflake_function resource labels May 20, 2024
@sfc-gh-asawicki
Copy link
Collaborator

Hey @rubemz.

In v0.100.0, we have introduced new function resources. They allow importing. Please consult the docs (e.g. https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/function_sql#import).

@sfc-gh-dszmolka sfc-gh-dszmolka changed the title Allow importing user defined functions (UDF) SNOW-1348103: Allow importing user defined functions (UDF) Dec 28, 2024
@sfc-gh-dszmolka
Copy link
Collaborator

closing this out as it has been implemented already. Do let us know if you still see issues even after using v0.100.0 / v1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
category:resource feature-request Used to mark issues with provider's missing functionalities resource:function Issue connected to the snowflake_function resource
Projects
None yet
Development

No branches or pull requests

4 participants