osmosis-models/models/core/core__fact_blocks.sql
Jessica Huhnke 72747fdd6d
An 1113 core views (#12)
* 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
2022-05-10 14:53:35 -05:00

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') }}