Nexus Mutual - products & covers

[tomfutago]

Contribution type

Please check the type of contribution this pull request is for:

• New spell(s)
• Adding to existing spell lineage
• Bug fix

---

For new spell(s)

If you are building new spell(s), please provide the following information:

• Spell name(s):
  • nexusmutual_ethereum_products_v1
  • nexusmutual_ethereum_product_types_v2
  • nexusmutual_ethereum_products_v2
  • nexusmutual_ethereum_covers_v1
  • nexusmutual_ethereum_covers_v2
• Description: base spells retrieving products offered by Nexus Mutual & covers bought to date
• Who are the new spell(s) for? internal team and/or general community
• How will the new spell(s) be used downstream? improvements to existing dashboards
• Implementation details: all new spells are materialised as views (except for one static table) and might need revisiting down the line to convert to incremental loads
• Test instructions: no specific instructions here apart from CI taking care of implemented basic tests like columns nullability and uniqueness

---

[dune-eng]

Workflow run id 9469396960 approved.

[dune-eng]

Workflow run id 9469397197 approved.

[dune-eng]

Workflow run id 9480071166 approved.

[dune-eng]

Workflow run id 9480070941 approved.

[dune-eng]

Workflow run id 9481038231 approved.

[dune-eng]

Workflow run id 9481038268 approved.

[dune-eng]

Workflow run id 9481438020 approved.

[dune-eng]

Workflow run id 9481438194 approved.

[dune-eng]

Workflow run id 9485706866 approved.

[dune-eng]

Workflow run id 9485707296 approved.

[dune-eng]

Workflow run id 9486157499 approved.

[dune-eng]

Workflow run id 9486157349 approved.

[dune-eng]

Workflow run id 9496771482 approved.

[dune-eng]

Workflow run id 9496771742 approved.

[dune-eng]

Workflow run id 9503305454 approved.

[dune-eng]

Workflow run id 9503305738 approved.

[jeff-dude]

another consideration, but not a must:
if you expect to deploy on other chains, maybe it makes sense to reorg directory to models/nexusmutual/<use case>/<blockchain>/ so it's easier to stick to one area when navigating directories, rather than seeing multiple use cases with a chain directory. hopefully that makes sense 😅

[dune-eng]

Workflow run id 9561854472 approved.

[dune-eng]

Workflow run id 9561854575 approved.

[tomfutago]

another consideration, but not a must: if you expect to deploy on other chains, maybe it makes sense to reorg directory to models/nexusmutual/<use case>/<blockchain>/ so it's easier to stick to one area when navigating directories, rather than seeing multiple use cases with a chain directory. hopefully that makes sense 😅

I like the idea with dir reorg, but there are no plans to deploy on other chains, so if it's only ethereum it probably makes more sense to keep all folders where they are. btw, more of them are coming soon..

[tomfutago]

CI is not too happy last few days (on any PR not just this one), keeps blowing up on "Error listing tables for catalog hive msg..

[jeff-dude]

CI is not too happy last few days (on any PR not just this one), keeps blowing up on "Error listing tables for catalog hive msg..

yeah, i'll have to investigate this one. the dbt run sends a bunch of queries to the db to "list" schemas for some reason prior to actually running anything. it appears to be getting stuck here

[jeff-dude]

code looks good, i'll keep trying CI. reruns have helped other PRs. we are working with our platform team on how to fix

[jeff-dude]

code looks good, i'll keep trying CI. reruns have helped other PRs. we are working with our platform team on how to fix

ugh. keeps happening. is this in a rush? can it wait until we find the resolution?

[tomfutago]

code looks good, i'll keep trying CI. reruns have helped other PRs. we are working with our platform team on how to fix

ugh. keeps happening. is this in a rush? can it wait until we find the resolution?

not a massive rush, happy to wait

[jeff-dude]

finally!