Rocker Docker includes odbc

Dockerfile

FROM rocker/verse:3.6.0
# install some packages needed for odbc and MS repo
RUN apt-get update && apt-get install -y \
    curl  \
    apt-utils \
    apt-transport-https \
    debconf-utils \
    build-essential \
    && rm -rf /var/lib/apt/lists/*

# adding custom MS repository
RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - 
RUN curl https://packages.microsoft.com/config/debian/9/prod.list > /etc/apt/sources.list.d/mssql-release.list

# install SQL Server drivers
# install SQL Server tools
RUN apt-get update && ACCEPT_EULA=Y apt-get -y install msodbcsql17 mssql-tools
RUN echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
RUN /bin/bash -c "source ~/.bashrc"

# install r packages
RUN install2.r --error \
    httr \
    recipes \
    rsample \
    parsnip \
    feather \ 
    data.table \
    janitor \
    forecast \
    prophet \
#    Rcpp \ # should be included with tidyverse
    fs \
    rsample \
    skimr \
    log4r \
    vroom \
    corrr \
    odbc \
    tsibble \
    DBI 

@ggpinto thanks for the update