配置含R与Snowflake驱动的Docker镜像时遇驱动缺失问题

问题根源 #

你的Docker镜像仅安装了R及相关依赖包，但缺少Snowflake ODBC驱动和unixODBC驱动管理器，导致系统无法定位SnowflakeDSIIDriver。

修复方案（修改Dockerfile） #

需要在Dockerfile中补充以下操作：

• 安装unixODBC驱动管理器（必备依赖）
• 下载并安装Snowflake官方ODBC驱动
• 配置ODBC驱动的系统识别文件

修改后的完整Dockerfile #

ARG AIRFLOW_VERSION=2.3.3
ARG PYTHON_RUNTIME_VERSION=3.8
FROM apache/airflow:${AIRFLOW_VERSION}-python${PYTHON_RUNTIME_VERSION}
SHELL ["/bin/bash", "-o", "pipefail", "-e", "-u", "-x", "-c"]
USER 0

# 安装基础依赖+unixODBC驱动管理器
RUN apt-get update && apt-get install -y --no-install-recommends \
    r-base r-base-core r-base-dev libssl-dev libcurl4-openssl-dev libgdal-dev \
    unixodbc unixodbc-dev wget && \
    rm -rf /var/lib/apt/lists/*

# 下载并安装Snowflake ODBC驱动（适配Debian/Ubuntu）
RUN wget https://sfc-repo.snowflakecomputing.com/odbc/linux/latest/snowflake-odbc-2.25.9.x86_64.deb && \
    dpkg -i snowflake-odbc-2.25.9.x86_64.deb && \
    rm snowflake-odbc-2.25.9.x86_64.deb

# 配置odbcinst.ini，让系统识别Snowflake驱动
RUN echo "[SnowflakeDSIIDriver]" >> /etc/odbcinst.ini && \
    echo "Description=Snowflake ODBC Driver" >> /etc/odbcinst.ini && \
    echo "Driver=/usr/lib64/snowflake/odbc/lib/libSnowflake.so" >> /etc/odbcinst.ini && \
    echo "Setup=/usr/lib64/snowflake/odbc/lib/libSnowflake.so" >> /etc/odbcinst.ini

# 安装R依赖包
RUN R -e "install.packages(c('httr','shiny','jsonlite','data.table','forecast','anomalize','tibbletime','DBI','dplyr','dbplyr','odbc','ggplot2','DT','getip','shinyTime','paws','RODBC'), repos = 'https://cran.rstudio.com/')"

USER airflow

额外注意事项 #

1. 驱动版本适配：如果上述驱动版本不兼容，可替换为Snowflake官方提供的最新deb包链接
2. 连接参数备选：若仍报错，可在dbConnect中直接指定驱动绝对路径，替代Driver = "SnowflakeDSIIDriver"：

   con <- DBI::dbConnect(
     odbc::odbc(),
     Driver = "/usr/lib64/snowflake/odbc/lib/libSnowflake.so",
     Server = "account.snowflakecomputing.com",
     Database = "DEV",
     Schema = "SCHEMA",
     Warehouse = "WH_XS",
     UID = username,
     PWD = password
   )
   

3. 权限规范：最后切回airflow用户，避免后续Airflow运行时出现权限冲突

内容的提问来源于stack exchange，提问作者Karthik