search

MetricsDAO / harmony_dbt

DBT Project for the Harmony Blockchain
12 stars 8 forks source link

Bug with missing token addresses #97

Closed antonyip closed 2 years ago

antonyip commented 2 years ago

Swaps are missing token addresses

select token0_address, count(1)
from MDAO_HARMONY.SWAPS
group by 1
order by 2 desc
Vahid-flipside commented 2 years ago

I looked at your model for the swap table. There must be a problem with the join because the liquidity_pool table already has those token addresses. And their relative pool addresses also exist in the logs table.

antonyip commented 2 years ago

Did a full-refresh on the table, we had changes that was not propagated to the production servers.