search

duneanalytics / spellbook

SQL views for Dune
Other
1.11k stars 1.02k forks source link

bebop ethereum: remove troubled model #6257

Closed jeff-dude closed 1 week ago

jeff-dude commented 1 week ago

fyi @B1boid it appears this is not fixed. there must be an issue with the unique keys and merge statement. or there are truly duplicates.

select
  block_date,
  blockchain,
  project,
  version,
  tx_hash,
  evt_index,
  trace_address,
  count(1)
from
  dex_aggregator.trades
group by
  block_date,
  blockchain,
  project,
  version,
  tx_hash,
  evt_index,
  trace_address
having
  count(1) > 1