A Python script to load data from Dune query to Postgresql/Snowflake
- Install docker and docker compose
- Run the docker command below with variables updated
docker run \
--name dune2snow \
--network steakhouse \
--detach \
-e CONNECTION_STRING=postgresql://postgres:passwsord@postgres:5432/db \
-e SCHEMA=<DB Schema> \
-e DUNE_API_KEY=<API Key> \
-e TABLE_NAME=<Table name to load the data> \
-e DUNE_QUERY_ID=<Dune Query ID> \
-e SMTP_PASSWORD=<SMTP Password to send notifications> \
-e SMTP_SENDER="<sender email>" \
-e UPTIME_URL="<Uptime-kuma URL>" \
bloodyburger/dune2snow:latest