0

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
$$;
  • No - there isn't. What's stopping you (or the person with ORGADMIN rights) following these instructions? – NickW Nov 03 '22 at 11:03

0 Answers0