Commit Graph

128 Commits

Author SHA1 Message Date
shah
67d08aae1a add udf_api_batched tests 2025-05-21 22:32:53 -07:00
shah
dda9867037 fix pointer to livequery_dev 2025-05-21 20:15:40 -07:00
shah
784c5c991a add update inner macros to account for max_batch_rows 2025-05-21 20:06:05 -07:00
shah
263fb09f5d add udf_api_batched to live 2025-05-21 20:05:23 -07:00
shah
c6525fb6ad update dev endpoint | add udf_api_batched to _live 2025-05-21 20:04:57 -07:00
shah
d42b520543 add makefile & max_batch_rows to dbt vars 2025-05-21 19:57:12 -07:00
shah
f94fb7fda9 add udf_api_batched 2025-05-21 14:45:37 -07:00
Jensen Yap
da46dc4a8e
Add additional UDF tests for live API endpoints in live.yml (#121)
- Introduced multiple test cases for GET and POST methods, including batch JSON-RPC requests for Solana and Ethereum.
- Ensured assertions validate response status codes and data structure integrity.
- Enhanced coverage for API interactions to improve reliability and robustness of the deployment core.
2025-04-29 10:42:24 +09:00
Shah Newaz Khan
2651a45b7e
Stream 1175/reinstate deploy core (#120)
* add deploy/core & updated test_udf

* namespace scope macros

* remove package namespace

* add render.sql

* namespace scole apply_grants_by_schema

* add depnends_on clause for deploy/martketplace models
2025-04-16 09:18:28 -07:00
Jensen Yap
9f98d2b9b2
update helius rpc url to mainnet (#118) 2025-03-13 09:29:31 +09:00
Jensen Yap
2c5d0cca67
Fix: failing tests in livequery marketplace (#117)
* fix tests
2025-03-12 15:35:15 +09:00
Shah Newaz Khan
04bc1253f7
remove models/live__allow_list (#115)
* remove models/live__allow_list

* add livequery-base

* remove live__verified_api_endpoints.csv

* Re-trigger deployment checks
2025-03-10 10:12:00 -07:00
Jensen Yap
d01e8d47f8 revert changes in join logic 2025-03-05 15:42:00 -08:00
Jensen Yap
97a2811e8c fix bug in duplicate rows 2025-03-05 15:42:00 -08:00
Jensen Yap
90198898d0 add batch trace, eth balance & token balance 2025-03-05 15:42:00 -08:00
Jensen Yap
bc7b78e592 fix missing alias 2025-03-05 15:42:00 -08:00
Jensen Yap
10414a122e add batch call to debug trace call 2025-03-05 15:42:00 -08:00
Julius Remigio
fc4a6752c1 refactor evm_live_views.sql to improve batch processing and remove unused sql_live_rpc_batch_call macro 2025-03-05 15:42:00 -08:00
Julius Remigio
1eecc8f048 refactor evm_live_view_bronze_blocks macro to include blockchain and network parameters; add sql_live_rpc_batch_call helper macro for batch JSON RPC calls 2025-03-05 15:42:00 -08:00
Julius Remigio
2bdf24eaf3 update evm_live_view_target_blocks macro to accept batch_size parameter 2025-03-05 15:42:00 -08:00
Jensen Yap
606ec83c25 add batch calls in bronze blocks and logs 2025-03-05 15:42:00 -08:00
shah
c8dce1d376 fix typo in readme.md 2025-03-05 15:42:00 -08:00
Julius Remigio
6a9f4c343a Fix typo in README.md and update macro in evm_live_views.sql to fix to_latest 2025-03-05 15:42:00 -08:00
Jensen Yap
673a55c1b7 revert requirements 2025-03-05 15:42:00 -08:00
Jensen Yap
5d6db27740 [STREAM-1070] add fact decode traces livequery 2025-03-05 15:42:00 -08:00
Jensen Yap
318fd70418 [STREAM-1069] Add fact eth balance livequery 2025-03-05 15:42:00 -08:00
Jensen Yap
d5f6103f4d [STREAM-1068] update logic on balance 2025-03-05 15:42:00 -08:00
Jensen Yap
01bd6dd51e [STREAM-1068] Add fact token balances 2025-03-05 15:42:00 -08:00
Jensen Yap
29be791268 remove wave apps folder 2025-03-05 15:42:00 -08:00
Jensen Yap
476eee68ec [STREAM-1065] Add ez decoded event logs 2025-03-05 15:42:00 -08:00
Jensen Yap
5525d9f6c1 rename fact logs to fact event logs 2025-03-05 15:42:00 -08:00
shah
1e8cf27f67 STREAM-1051 Refactor ez_native_transfers to use reusable CTE macros 2025-03-05 15:42:00 -08:00
shah
4066365114 STREAM-1062 Refactor fact_traces UDTF SQL | Add evm_live_view_bronze_traces CTE macro 2025-03-05 15:42:00 -08:00
shah
76661504d2 STREAM-1049 Pin view columns for mapping_tables 2025-03-05 15:42:00 -08:00
Jensen Yap
1a40d0705f remove ez_token_transfers_id from signature 2025-03-05 15:42:00 -08:00
shah
4a5e83e913 STREAM-1053 Fix refactored reusable CTE column references 2025-03-05 15:42:00 -08:00
shah
3594bdbda6 STREAM-1053 Refactor fact_transactions to use reusable LiveView CTE's 2025-03-05 15:42:00 -08:00
Jensen Yap
1da9b610fb remove contract_name 2025-03-05 15:42:00 -08:00
Jensen Yap
39c656ca77 fix cols 2025-03-05 15:42:00 -08:00
Jensen Yap
6d1407bdff add discrepent columns between gold and livequery 2025-03-05 15:42:00 -08:00
shah
1fc41519ef STREAM-1049 Added secrets interpolation to fact_traces, fact_transactions & ez_native_transfers 2025-03-05 15:42:00 -08:00
shah
3d563d8710 STREAM-1049 Add secrets interpoation for fact_logs & fact_decoded_event_logs 2025-03-05 15:42:00 -08:00
shah
80590d8f9d STREAM-1049 Secrets interpolate fact_blocks macros 2025-03-05 15:42:00 -08:00
shah
0bc02b03a5 STREAM-1053 Add fact_transactions UDTF 2025-03-05 15:42:00 -08:00
shah
14cdcb769f STREAM-1062 fix tf_fact_traces signature to match return column aliases 2025-03-05 15:42:00 -08:00
shah
5e26c60d25 STREAM-1062 add fact_traces UDTF 2025-03-05 15:42:00 -08:00
shah
e72eec1eae STREAM-1051 Rename UDTF args 2025-03-05 15:42:00 -08:00
shah
213acecd40 STREAM-1051 add ez_native_transfers sql 2025-03-05 15:42:00 -08:00
Jensen Yap
a844411ef2 [STREAM-1061] Add EVM Decoded Logs udtf 2025-03-05 15:42:00 -08:00
Jensen Yap
99412f94c6 [STREAM-1055] add demo plotcard app to show latest block number with the udtf 2025-03-05 15:42:00 -08:00