Backfill May 2025 Data Snapshot
Budget / Salary₹1,500–12,500
TypeFreelance project
LocationRemote
Posted1 hour ago
A scheduled snapshot for May 2025 never ran, so the dataset for that period is blank. The files that feed the snapshot are still available in our cloud storage, and the warehouse we query from is Snowflake.
I need someone to:
• rebuild the missing May 2025 partition in the existing snapshot table,
• follow the same logic and column order used by the other monthly snapshots,
• run basic row-count and checksum comparisons against source files to confirm accuracy, and
• provide the SQL (or Snowflake tasks/procedures) you use so I can re-run it later if needed.
Everything else about the pipeline is unchanged; only this one month is missing. Please let me know how quickly you can turn it around and what access you’ll need.
I need someone to:
• rebuild the missing May 2025 partition in the existing snapshot table,
• follow the same logic and column order used by the other monthly snapshots,
• run basic row-count and checksum comparisons against source files to confirm accuracy, and
• provide the SQL (or Snowflake tasks/procedures) you use so I can re-run it later if needed.
Everything else about the pipeline is unchanged; only this one month is missing. Please let me know how quickly you can turn it around and what access you’ll need.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.