eduard93/snowflake repository overview

# The base IRIS image. Modify the build script argument to use a different version.
ARG IMAGE=intersystemsdc/iris-community
FROM $IMAGE


# Get some dependencies with root power
USER root
RUN apt-get update \
 && DEBIAN_FRONTEND=noninteractive apt-get install -y \
  unixodbc nano

RUN wget https://sfc-repo.snowflakecomputing.com/odbc/linux/3.3.2/snowflake-odbc-3.3.2.x86_64.deb \
    && dpkg -i snowflake-odbc-3.3.2.x86_64.deb


RUN cp /usr/lib/x86_64-linux-gnu/libodbcinst.so.2 /usr/lib/x86_64-linux-gnu/libodbcinst.so.1

# Install apache as the same non-root user who owns the IRIS instance
# and is the default user for this container, so that default user
# can start and stop Apache, modify config files, etc.
USER ${ISC_PACKAGE_MGRUSER}

WORKDIR /home/irisowner/irisbuild


RUN --mount=type=bind,src=.,dst=. \
    cp /home/irisowner/irisbuild/irisodbc.ini $ISC_PACKAGE_INSTALLDIR/mgr/irisodbc.ini && \
    iris start IRIS && \
    iris session IRIS < iris.script && \
    iris stop IRIS quietly

do $system.OBJ.Load("/home/irisowner/irisbuild/ODBC.cls", "ck")
halt

Class Utils.ODBC
{

ClassMethod Test(dsn="Snowflake",usr,pwd)
{
    write "Process id: ",$j,!
    set gc=##class(%SQLGatewayConnection).%New()
    set sc=gc.Connect(dsn,usr,pwd,0) // This line calls C code and hangs
    write "SUCCESS", !
    set ^dbg($j, $i(^dbg($j))) = "Connect"

}

}

[ODBC Data Sources]
Snowflake=Snowflake

[Snowflake]
Driver      = /usr/lib/snowflake/odbc/lib/libSnowflake.so
Description = TEST
server      = !!!.snowflakecomputing.com
database    = !!!
warehouse   = !!!