Skip to main content
Running into issues? Here’s how to troubleshoot common problems and get Flipspace back on track.

​
Context Window Drift

​
The Problem

Long conversations lose memory of earlier messages. Chat may forget details, contradict itself, or lose track of your original goal.

​
Solutions

Periodically ask:
"Summarize what we've found so far in 5 bullet points"
Copy the summary, then start a fresh chat with that context.
Don’t try to tackle multiple unrelated analyses in one conversation. Split them into separate chats.
If Chat seems confused, restate your goal:
"To recap: we're analyzing Arbitrum DEX volumes over Q1 2024, focusing on the top 5 protocols.
So far we've looked at Uniswap and Curve. Now let's examine SushiSwap."

​
Query Errors

​
The Problem

Queries fail to execute or time out.

​
Common Causes

  • Too much data: Query spans too many rows or too long a time period
  • Complex joins: Multiple table joins slow down execution
  • Incorrect table names: Typo or outdated table reference

​
Solutions

Instead of:
"Show me all Uniswap swaps ever"
Try:
"Show me Uniswap swaps over the past 30 days"
Instead of:
"Show me all DEX activity"
Try:
"Show me DEX activity on Arbitrum for USDC and ETH"
Flipside’s ez_* tables are optimized and faster than raw fact tables.
"Use the ethereum.defi.ez_dex_swaps table instead of fact_event_logs"
For complex analyses, break into sequential queries:
"First, show me total DEX volumes.
Then, break down by protocol.
Finally, add time series data."

​
Incorrect or Unexpected Results

​
The Problem

The numbers don’t match your expectations or known benchmarks.

​
Common Causes

  • Token vs USD amounts: Confusing raw token balances with USD values
  • Duplicate counting: Rows are joined incorrectly
  • Wrong filters: Date ranges, chains, or protocols don’t match your intent
  • Data gaps: Some chains or protocols may have incomplete historical data

​
Solutions

"Are these values in USD or in token units?"
"Convert all amounts to USD using hourly prices"
Expand the Flipside Data box and check:
  • Filters (WHERE clauses)
  • Joins (JOIN conditions)
  • Aggregations (SUM, COUNT, AVG)
If something looks wrong, point it out.
Compare to known benchmarks:
  • Does this TVL match DeFiLlama?
  • Are these volumes consistent with protocol dashboards?

​
Data Freshness Issues

​
The Problem

Data seems outdated or doesn’t include the latest activity.

​
Solutions

Ask:
"When was the ethereum.defi.ez_dex_swaps table last updated?"
For truly current data: text "Use live query to get the latest pool state"
Avoid queries that end “today”—use yesterday or earlier.

​
Pro Tips for Avoiding Issues

Begin with a basic query, verify it’s correct, then add layers:
  1. “Show me Uniswap volumes” (verify this works)
  2. “Break it down by pool” (add complexity)
  3. “Add time series” (add more complexity)
  • Specify chains: “on Arbitrum” - Specify time periods: “from 2024-01-01 to 2024-03-31” - Specify tokens: “USDC (0xA0b86991…)” - Specify what you want: “in USD, not token units”

​
Still Stuck?

If you’ve tried these solutions and still can’t resolve the issue:
  1. Simplify your question: Break it into smaller parts
  2. Start a new chat: Context drift may be causing confusion
  3. Try a different approach: Ask the same question in a different way
  4. Contact support: Reach out to Flipside support with details about the issue

​
Next Steps

Effective Prompting

Craft better prompts to avoid issues

Automations

Use Automations for reliable analyses

Data Explorer

Browse available tables

Contact Support

Get help from the Flipside team