Overview
Snowflake Proxy
Proxy
The proxy is an haproxy instance that will route traffic to snowflake
| Variable | Description |
|---|---|
SNOWFLAKE_ACCOUNTID |
The account id of the snowflake account |
SNOWFLAKE_REGION |
The region of the snowflake account |
Test Client
The test client is a simple golang script that will connect to the proxy and run a query. It configures the connection to use the local proxy. It prints each row
| Flag | Env Variable | Description |
|---|---|---|
snowflake_accountid |
SNOWFLAKE_ACCOUNTID |
The account id of the snowflake account |
snowflake_region |
SNOWFLAKE_REGION |
The region of the snowflake account |
snowflake_user |
SNOWFLAKE_USER |
The user to connect as |
snowflake_password |
SNOWFLAKE_PASSWORD |
The password to connect with |
proxy_host |
127.0.0.1 |
The host of the proxy |
proxy_port |
8080 |
The port of the proxy |
Running
To run this we need to build the docker image and then run it.
docker build -t snowflake-proxy .
Now that it is built we will need to run it
docker run -it -p 8080:8080 -e SNOWFLAKE_ACCOUNTID=12345 -e SNOWFLAKE_REGION=us-east-1 snowflake-proxy
Replace the account id and region with your own. You can also change the port if you want to run it on a different port.
Now that the proxy is running we can run the test client. Replace the user and password with your own.
go run main.go -snowflake_accountid 12345 -snowflake_region us-east-1 -snowflake_user test -snowflake_password test -proxy_host 127.0.0.1 -proxy_port 8080
This should print something like the following if it connected properly
[INFO] 2023/09/28 21:46:27 main.go:45: ONE
[INFO] 2023/09/28 21:46:27 main.go:46: ---
[INFO] 2023/09/28 21:46:27 main.go:54: 1
That is it! You are now connected to snowflake through the proxy.