automation fails to authenticate with snowflake

[ilanbaruch]

hi all

when trying to run the automation, receiving the following error:

SQLSTATE[08001] [240012] curl_easy_perform() failed: SSL peer certificate or SSH remote key was not OK

any ideas?

[diegozecchini]

Hi!
it seems related to SSL connection with Snowflake.

You may check that the correct SSL certificate is being used for Snowflake, if using a self-signed certificate, you may need to explicitly trust it and verify that Snowflake's certificate hasn't expired.

I would also check if the correct datasource connection details are used. Ensure SSLMode is set correctly. If require or verify-full is enabled, try setting it to allow.