search

blockchain-etl / ethereum-etl-airflow

Airflow DAGs for exporting, loading, and parsing the Ethereum blockchain data. How to get any Ethereum smart contract into BigQuery https://towardsdatascience.com/how-to-get-any-ethereum-smart-contract-into-bigquery-in-8-mins-bab5db1fdeee
MIT License
402 stars 190 forks source link

Hotfix for failing load_traces task due to value not fitting in the NUMERIC data type #757

Closed medvedev1088 closed 2 months ago

medvedev1088 commented 2 months ago

What?

Hotfix for failing load_traces task due to value not fitting in the NUMERIC data type

How?

Change the datatype STRING when loading, use SAFE_CAST() when merging

Example tx with large value: https://etherscan.io/tx/0x00ed8efcf66cc13022770c253de4f15edbf53a07471e3ce49913fae12098d6aa

More transactions with large value:

select *
from bigquery-public-data.crypto_ethereum.traces
where date(block_timestamp) = '2024-07-03'
and value is null