mirror of
https://github.com/FlipsideCrypto/optimism-models.git
synced 2026-02-06 20:56:44 +00:00
c8c78bf62d
* changed unique keys on logs and traces and added new test to logs * added dbt-env to gitignore for SSO functionality
14 lines
228 B
SQL
14 lines
228 B
SQL
{% test tx_block_count(
|
|
model,
|
|
column_name
|
|
) %}
|
|
|
|
SELECT
|
|
{{ column_name }},
|
|
COUNT(DISTINCT block_number) AS num_blocks
|
|
FROM
|
|
{{ model }}
|
|
GROUP BY {{ column_name }}
|
|
HAVING num_blocks > 1
|
|
|
|
{% endtest %} |