I’m using the below code to connect to Snowflake via SAS Fusion without error. However, there’s a function on the database that is needed but SAS is producing an error. When connecting to Snowflake via the web, this function works. Are there any suggestions? Function: OCDP_SECURITY.DPAAS_DETOKEN_NAME(FIRST_NAME) AS FIRST_NAME Error: ERROR: CLI prepare error: SQL compilation error: Unknown user-defined function OCDP_SECURITY.DPAAS_DETOKEN_NAME SQL statement: SELECT OCDP_SECURITY.DPAAS_DETOKEN_NAME(FIRST_NAME) AS FIRST_NAME FROM OCDP_PRD_CDCM_DB.CDCM.PATIENT. %LET SERVER= xxxx.com; %LET UID= xxxxx; %LET PRIV_KEY_FILE_UNENCR= /hpsasocd/idpwd/&sysuserid./rsa_key.prv; LIBNAME SNOW_PT ODBC COMPLETE=" DRIVER={/usr/lib64/snowflake/odbc/lib/libSnowflake.so}; AUTHENTICATOR= SNOWFLAKE_JWT; SERVER= &SERVER; UID= &UID; PRIV_KEY_FILE= &PRIV_KEY_FILE_UNENCR; PRIV_KEY_FILE_PWD=; Warehouse= OCDP_PRD_QUERY_WH; Role=AR_PRD_ROLE; "; PROC SQL; CONNECT USING SNOW_PT AS SF; CREATE TABLE TEST_PASSTHRU AS SELECT * FROM CONNECTION TO SF (SELECT * FROM OCDP_PRD_CDCM_DB.CDCM.TENANT ); QUIT;
... View more