The following macros are intended to be used to create and maintain various models. These macros can be accessed via version >=v1.0.0 of the fsc-evm package. Please see the fsc-evm installation instructions in the README for more details on how to access and utilize this macro effectively.

These macros are required to properly implement the data requests to the nodes, as they prevent re-requesting data that is already "complete" in the Streamline pipeline.

---

streamline_core_complete

Usage

This macro constructs a SQL query to select block numbers and generate surrogate keys based on the specified model, in order to verify blocks requests that are "complete". It handles both incremental and full refresh scenarios, referencing the Bronze Streamline views. The query also includes timestamps for insertion and modification, along with an invocation ID for tracking.

fsc_evm.streamline_core_complete

Parameters

Note: Parameters with default values must be ordered after non-default parameters.

Parameter	Type	Default	Description
model	String	-	Defines the specific model to process. Possible values include: 'blocks', 'transactions', 'receipts', 'traces', 'confirmed_blocks'

Example:

{{ fsc_evm.streamline_core_complete(
    model='blocks'
) }}