Dune → Allium Query Conversion Skill

Convert Dune Analytics (Trino) SQL queries to Allium (Snowflake) SQL. SQL dialect conversions apply to all chains. Comprehensive Solana and EVM chain mappings included.

Prerequisites

• Allium API key in ~/.allium/credentials:

  API_KEY=allium_...
  QUERY_ID=...
  

  Get your key at https://app.allium.so/settings/api-keys. If QUERY_ID is missing, the allium_query.py script creates one automatically.
• (Optional) DUNE_API_KEY in project .env file for automated result fetching via dune_query.py. Alternatively, run the original query in the Dune app and export results manually.

Conversion Workflow

Step 1: Accept Dune SQL

Get the Dune query via one of: