Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

paraswap: add paraswap_zkevm + v6.1 spell #6100

Closed
wants to merge 3 commits into from

Conversation

mwamedacen
Copy link
Contributor

@mwamedacen mwamedacen commented Jun 6, 2024

This PR is a follow up of previous works (copy pasta). Previous PRs: #5597 and #6002

@dune-eng
Copy link

dune-eng commented Jun 6, 2024

Workflow run id 9400951741 approved.

@dune-eng
Copy link

dune-eng commented Jun 6, 2024

Workflow run id 9400951863 approved.

@dune-eng
Copy link

dune-eng commented Jun 6, 2024

Workflow run id 9400961897 approved.

@dune-eng
Copy link

dune-eng commented Jun 6, 2024

Workflow run id 9400962107 approved.

@dune-eng
Copy link

dune-eng commented Jun 7, 2024

Workflow run id 9412036634 approved.

@dune-eng
Copy link

dune-eng commented Jun 7, 2024

Workflow run id 9412036833 approved.

@dune-eng
Copy link

dune-eng commented Jun 7, 2024

Workflow run id 9414598097 approved.

@dune-eng
Copy link

dune-eng commented Jun 7, 2024

Workflow run id 9414598476 approved.

@dune-eng
Copy link

dune-eng commented Jun 8, 2024

Workflow run id 9427890743 approved.

@dune-eng
Copy link

dune-eng commented Jun 8, 2024

Workflow run id 9427890791 approved.

@dune-eng
Copy link

dune-eng commented Jun 8, 2024

Workflow run id 9428665135 approved.

@dune-eng
Copy link

dune-eng commented Jun 8, 2024

Workflow run id 9428665218 approved.

@mwamedacen mwamedacen changed the title paraswap: add paraswap_zkevm model along with v6.1 paraswap: add paraswap_zkevm + v6.1 spells Jun 9, 2024
@mwamedacen mwamedacen changed the title paraswap: add paraswap_zkevm + v6.1 spells paraswap: add paraswap_zkevm + v6.1 spell Jun 9, 2024
@Hosuke Hosuke self-assigned this Jun 9, 2024
@Hosuke Hosuke added in review Assignee is currently reviewing the PR dbt: dex covers the DEX dbt subproject labels Jun 9, 2024
@dune-eng
Copy link

Workflow run id 9442458777 approved.

@dune-eng
Copy link

Workflow run id 9442458858 approved.

@dune-eng
Copy link

Workflow run id 9442460616 approved.

@dune-eng
Copy link

Workflow run id 9442460771 approved.

@mwamedacen
Copy link
Contributor Author

mwamedacen commented Jun 10, 2024

thanks for the suggestions, applied @Hosuke both. Worth noting that those improvements are not normalised across all the spells (not only ParaSwap ones)

@mwamedacen mwamedacen requested a review from Hosuke June 10, 2024 04:26
Copy link
Collaborator

@Hosuke Hosuke left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

These improvements are new standards that we are striving to implement in our development process. We will do our best to cover these in all new spells. Thank you for your understanding and support!

AND tx.block_time >= TIMESTAMP '{{project_start_date}}'
{% endif %}
{% if is_incremental() %}
AND tx.block_time >= date_trunc('day', now() - interval '7' day)
Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Suggested change
AND tx.block_time >= date_trunc('day', now() - interval '7' day)
AND {{ incremental_predicate('tx.block_time') }}

AND p2.minute >= TIMESTAMP '{{project_start_date}}'
{% endif %}
{% if is_incremental() %}
AND p2.minute >= date_trunc('day', now() - interval '7' day)
Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Suggested change
AND p2.minute >= date_trunc('day', now() - interval '7' day)
AND {{ incremental_predicate('p2.minute') }}

AND p1.minute >= TIMESTAMP '{{project_start_date}}'
{% endif %}
{% if is_incremental() %}
AND p1.minute >= date_trunc('day', now() - interval '7' day)
Copy link
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Suggested change
AND p1.minute >= date_trunc('day', now() - interval '7' day)
AND {{ incremental_predicate('p1.minute') }}

@jeff-dude
Copy link
Member

i've been letting this one sit, as it appears suggestion still remain. please do make the changes and look to finalize

@Hosuke Hosuke added the WIP work in progress label Jul 8, 2024
@jeff-dude
Copy link
Member

closing due to inactivity. feel free to reopen and describe what needs to happen next, if necessary. thank you.

@jeff-dude jeff-dude closed this Aug 2, 2024
@github-actions github-actions bot locked and limited conversation to collaborators Aug 2, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
dbt: dex covers the DEX dbt subproject in review Assignee is currently reviewing the PR WIP work in progress
Projects
None yet
Development

Successfully merging this pull request may close these issues.

4 participants