ARG PARENT_IMAGE=086679231553.dkr.ecr.us-east-1.amazonaws.com/docker-parent-images:debian12
FROM ${PARENT_IMAGE} AS parent

ARG SNOWSQL_BOOTSTRAP_VERSION=1.3
ARG SNOWSQL_VERSION=1.3.1

USER root

# Run updates and install packages
RUN apt-get -y update \
    && apt-get -y upgrade \
    && apt-get -y install \
      ca-certificates \
      curl \
      unzip \
    && apt-get -y clean \
    && rm -rf /var/lib/apt/lists/*

ENV BOOTSTRAP_VERSION=${SNOWSQL_BOOTSTRAP_VERSION}
ENV VERSION=${SNOWSQL_VERSION}
ENV SNOWSQL_DEST=/usr/bin
ENV SNOWSQL_LOGIN_SHELL=/root/.bashrc
ENV LC_ALL=C.UTF-8
ENV LANG=C.UTF-8
ENV PYTHONUNBUFFERED=1
ENV PYTHONDONTWRITEBYTECODE=1

# Use snowflake installer
RUN curl -O https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/${SNOWSQL_BOOTSTRAP_VERSION}/linux_x86_64/snowsql-${SNOWSQL_VERSION}-linux_x86_64.bash \
    && bash snowsql-${SNOWSQL_VERSION}-linux_x86_64.bash \
    && snowsql --version \
    && rm snowsql-${SNOWSQL_VERSION}-linux_x86_64.bash

CMD ["snowsql"]