Hello everyone!

This is my first post, I hope I will be able to make it useful to others as well.

I am trying to setup a connection to the cloud analytical DB Snowflake (https://www.snowflake.com/en/) from a Phoenix app using Snowflex (https://github.com/pepsico-ecommerce/snowflex).

I followed the readme on the Snowflex page, but when I run my server locally I keep getting the following error:

[warning] Unable to connect to snowflake: '[Snowflake][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[SERVER]} SQLSTATE IS: 08001 Connection to database failed.'

I am using:

MacOS 12.6 (Apple Silicon M1)

Erlang version 25.1.1, installed with asdf to have ODBC

Elixir version 1.14.2, installed with asdf

Unixodbc 2.3.12 (installed through Homebrew following the Snowflex readme).

This is how my config file looks like for development, with placeholder secrets. I just need to test pushing some data from local for the time being.

config :snowflex, driver: "/opt/snowflake/snowflakeodbc/lib/libSnowflake.dylib"

config :my_app, SnowflakeConnection,
  connection: [
      server: "snowflake-server-address",
      role: "DEV",
      warehouse: "name-of-warehouse",
      uid: "user",
      pwd: "pwd"
  ]

I have looked extensively, but did not find any similar error for a Phoenix app and I don’t know what to do to fix it.