Connecting to a Snowflake database - Problem with the SSL CA cert

Posit Professional & Hosted Products shinyapps.io
,
1

The issue is that I cannot connect to a Snowflake database while running the app in shinyapps io. The issue that I saw in the shinyapps io logs is as follows:

REST request for URL https://xxx.snowflakecomputing.com:443/session/v1/login-request?requestId=e997ba78-dc79-4b90-b264-88b15804509b&request_guid=84d25f29-65a8-47bc-b6f4-fb9e9e477782&databaseName=database_name failed: CURLerror (curl_easy_perform() failed) - code=77 msg='Problem with the SSL CA cert (path? access rights?)' osCode=2 osMsg='No such file or directory'.

The code:

ui <- fluidPage(
  tableOutput("df")
)

server <- function(input, output) {
  snowcon <- dbConnect(odbc::odbc(), .connection_string = 
                  'Driver=/opt/rstudio-drivers/snowflake/bin/lib/libsnowflakeodbc_sb64.so;
                   Server=xxx.snowflakecomputing.com;
                   Database=database_name;
                   UID=user;
                   PWD=pass;
                   Integrated Security=NTLM')
  
  sql <- 'select count(*) from "aaa"."bbb"'
  df <- dbGetQuery(snowcon,sql)
  output$df <- renderTable({
    df
  })
}

shinyApp(ui = ui, server = server)

I also verified that there is a Snowflake driver installed on shinyapps io by using this code:

ui <- fluidPage( verbatimTextOutput("txtdrv"))

server <- function(input, output) {
  output$txtdrv <- renderPrint({
    odbcListDrivers()
  })
}

shinyApp(ui = ui, server = server)

This returns:

# 83          Snowflake         Driver
# 84          Snowflake RStudioVersion
# 85          Snowflake        Version
# 86          Snowflake      Installer

# 83     /opt/rstudio-drivers/snowflake/bin/lib/libsnowflakeodbc_sb64.so
# 84                                                               1.7.0
# 85                                                          1.4.1.1010
# 86                                                 RStudio Pro Drivers

What is exactly the SSL CA cert problem and how can I solve it?

Thank you in advance for help!