mirror of
https://github.com/FlipsideCrypto/osmosis-models.git
synced 2026-02-06 16:36:55 +00:00
* core views v1 - transactions in the works * transactions - have uncle block issue * updated transactions model and ymls * updates to docs to reflect new column names * update to joins in tx (now correct number of txs) and test * added clustering by block_timestamp::date * changes
13 lines
197 B
SQL
13 lines
197 B
SQL
{{ config(
|
|
materialized = 'view'
|
|
) }}
|
|
|
|
SELECT
|
|
block_id,
|
|
block_timestamp,
|
|
chain_id,
|
|
tx_count,
|
|
proposer_address,
|
|
validator_hash
|
|
FROM
|
|
{{ ref('silver__blocks') }} |