metabase-flightsql-driver: Command for Claude Code

End-to-End Test for Metabase Arrow Flight SQL Driver

Run a complete end-to-end test of the driver by starting all services fresh and validating functionality.

Pre-requisites

• Podman must be installed and running
• Python 3 must be available

Test Steps

1. Clean up existing environment

cd $PROJECT_ROOT
podman compose down -v
rm -f .env

This stops all containers, removes volumes, and deletes any stale .env file for a fresh start.

Important: The .env file contains API keys from previous runs. If not deleted, the setup script will try to use the old (now invalid) key and fail with 401 errors.

2. Start all services

podman compose up -d

This starts:

• builder: Compiles the driver JAR using Leiningen
• postgres: Metabase application database
• spiced: Spice.ai Flight SQL server (port 50051)
• gizmosql: GizmoSQL Flight SQL server (port 31337)
• metabase: Metabase BI tool (port 3000)

3. Wait for Metabase to be ready

for i in {1..60}; do
  if podman exec metabase curl -s -f "http://localhost:3000/api/health" >/dev/null 2>&1; then
    echo "Metabase is ready!"
    break
  fi
  echo "Waiting... attempt $i"
  sleep 5
done

4. Run the setup script

python scripts/metabase_setup.py

This script:

• Performs initial Metabase setup (creates admin user)
• Creates API key and saves to .env
• Creates GizmoSQL and Spice database connections
• Syncs database schemas
• Creates a comprehensive test dashboard with 32 cards and 5 field filters

5. Validate the dashboard

Open in browser: http://localhost:3000/dashboard/2

Or test via API (read API key from .env and use it directly):

# Read the API key from .env file
API_KEY=$(grep METABASE_API_KEY .env | cut -d'=' -f2)

# Validate dashboard exists with expected cards and parameters
podman exec metabase curl -s -H "x-api-key: $API_KEY" \
  "http://localhost:3000/api/dashboard/2" | python -c "
import sys,json
d=json.load(sys.stdin)
print(f'Dashboard: {d.get(\"name\")}')
print(f'Cards: {len(d.get(\"dashcards\",[]))}')
print(f'Parameters: {len(d.get(\"parameters\",[]))}')
"