Snowflake foreign data wrapper is not getting integrated

Following error I keep getting - I have made sure that all the steps are followed correctly and also taken help from AI assistant.
Chart

Export

Source

Primary database

Role
postgres

Run
ERROR: HV000: guest fdw error: Request error: error sending request for url (https://al10589-esentire_dl_sf.snowflakecomputing.com/api/v2/statements?async=false): error trying to connect: error:16000069:STORE routines:ossl_store_get0_loader_int:unregistered scheme:crypto/store/store_register.c:237:scheme=file, error:80000002:system library:file_open:reason(2):providers/implementations/storemgmt/file_store.c:267:calling stat(/nix/store/0kfbzhd8qdsxsd4qf9dkpcd3f916krvr-openssl-3.0.13/etc/ssl/certs), error:0A000086:SSL routines:tls_post_process_server_certificate:certificate verify failed:ssl/statem/statem_clnt.c:1889: (hostname mismatch)
Chart

Export

Source

Primary database

Role
postgres

Run
ERROR: HV000: guest fdw error: Request error: error sending request for url (https://al10589-esentire_dl_sf.snowflakecomputing.com/api/v2/statements?async=false): error trying to connect: error:16000069:STORE routines:ossl_store_get0_loader_int:unregistered scheme:crypto/store/store_register.c:237:scheme=file, error:80000002:system library:file_open:reason(2):providers/implementations/storemgmt/file_store.c:267:calling stat(/nix/store/0kfbzhd8qdsxsd4qf9dkpcd3f916krvr-openssl-3.0.13/etc/ssl/certs), error:0A000086:SSL routines:tls_post_process_server_certificate:certificate verify failed:ssl/statem/statem_clnt.c:1889: (hostname mismatch)
1 Reply
HardikPatelN
HardikPatelNOP2w ago
#help-and-questions I have been trying to connect snowflake for last two days and unable to do it. Please help.

Did you find this page helpful?