SQL compilation error: Anaconda terms must be accepted by ORGADMIN to use Anaconda 3rd party packages. Please follow the instructions at https://docs.snowflake.com/en/developer-guide/udf/python/udf-python-packages.html#using-third-party-packages-from-anaconda.
Is there any alternative method to use Fuzzywuzzy package in Snowflake Stored Procedure ?
CREATE OR REPLACE PROCEDURE MYPROC()
RETURNS STRING
LANGUAGE PYTHON
RUNTIME_VERSION = '3.8'
PACKAGES = ('snowflake-snowpark-python','fuzzywuzzy')
HANDLER = 'run'
AS
$$
from fuzzywuzzy import fuzz
def run(session):
Str_A = 'ABCD EFD'
Str_B = 'ABC E'
ratio = fuzz.token_set_ratio(Str_A, Str_B)
return ratio
$$;