Airflow - sas viya - SSL verification error

[Narendra_P]

Hi Team,

I am encountering below SSL verification error while attempting to trigger a sas viya(task 1_code1.sas) job from apache airflow using python script.

ERROR - Failed to execute job 134 for task 1_code1.sas (SASStudioOperator error: HTTPSConnectionPool(host='sas-viya.gcp.xxx.xxx.ca', port=443): Max retries exceeded with url: //SASLogon/oauth/token (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1131)'))); 3467

i have tried adding the following code to disable SSL verification in the python script. However, the problem persists.

import requests

# URL of the host for which SSL verification needs to be disabled
host_url = "https://sas-viya.gcp.xxx.xxx.ca"

# Disable SSL verification
response = requests.get(host_url, verify=False)

and i have tried adding {"verify": "/path/to/ca.crt"} in the connection's extra field, to use the specified CA certificate for SSL verification. However, the problem persists.

Could you please suggest on this issue?

[gwootton · Accepted solution]

According to the SAS airflow doc you need to specify the SSL CA or turn off certificate validation using the ssl_certificate_verification setting rather than "verify":
https://github.com/sassoftware/sas-airflow-provider?tab=readme-ov-file#create-a-connection-to-sas