Skip to content

Instantly share code, notes, and snippets.

@charles-tan

charles-tan/ds_blockchain_csas_1.sql

Created February 21, 2024 17:46
Show Gist options
  • Save charles-tan/746ee763348bc1410c3737d17859e74e to your computer and use it in GitHub Desktop.
Save charles-tan/746ee763348bc1410c3737d17859e74e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ds_blockchain_csas_1.sql
CREATE STREAM eth_txns_filtered AS
SELECT
"txn_hash",
"block_ts",
"blockNumber",
"maxPriorityFeePerGas",
"gas"
FROM eth_txns WITH ('source.deserialization.error.handling'='IGNORE')
WHERE "maxPriorityFeePerGas" > 100 AND "maxPriorityFeePerGas" < "maxFeePerGas";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment