Some projects/collections 404

[ccerv1]

Which area(s) are affected? (leave empty if unsure)

Frontend

To Reproduce

Examples:

• https://www.opensource.observer/collections/filecoin-builders
• https://www.opensource.observer/projects/pinatacloud

Describe the Bug

Expected Behavior

A project/collection page should load

[ryscheng]

This is actually behaving as intended from the perspective of the frontend --- if you do this SQL query in Clickhouse

SELECT * FROM projects_v1 WHERE project_name = 'pinatacloud';

Yields no results. Are these new to oss-directory? If so, I suspect that we've imported to BigQuery already (which populates Algolia), but we haven't copied the marts to Clickhouse.

[ryscheng]

Gonna try copying projects_v1 and collections_v1 from BQ to Clickhouse here dagster.opensource.observer/runs/4420f2ca-0693-4361-a3fa-22380346be5a

[ryscheng]

We fixed the bq2clickhouse factory yesterday. I think this just involves running those jobs again

[ryscheng-mobile]

We manually copied a bunch of tables last week. Closing this as @ravenac95 is working on getting the end to end pipeline running again