README.md

dune2snowflake

A Python script to load data from Dune query to Postgresql/Snowflake

How to use

• 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