Page MenuHomePhabricator

Clean up S3 bucket according to eng team's plan
Closed, ResolvedPublic2 Estimated Story Points

Description

Last week in the collab we decided on a path structure for the data reload pipeline in the S3 bucket, s3://wdqs-update-pipeline.

The relevant directories in the bucket that we decided on are:

  • /wikidata-rdf-export to hold the dumps being written by the Airflow DAG (needs to be updated - currently the dumps go to /wikibase-dumps)
  • /temp/ which holds its own subdir /munged-n3 to hold the NT files output by the data processing stage of the pipeline (and might hold other data that only needs to live for the lifetime of the DAG)
  • /qlever-index to hold the final indices (further split out by graph and date/timestamp) and metadata files read by the deployment

To prevent further contamination of the bucket, the data_reload DAG needs to be updated to write dumps to the new path.

AC:

  • Everything else has been deleted from the bucket
  • data_reload DAG has been updated to write the export files to the new directory, /wikidata-rdf-export

Details

Related Changes in GitLab:
TitleReferenceAuthorSource BranchDest Branch
Update the name of the S3 folder to write dumps to: /wikibase-dumps -> /wikidata-rdf-exportrepos/data-engineering/airflow-dags!2399lericksondumpsdirmain
Customize query in GitLab

Event Timeline

lerickson set the point value for this task to 2.

lerickson opened https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/merge_requests/2399

Update the name of the S3 folder to write dumps to: /wikibase-dumps -> /wikidata-rdf-export

lerickson closed https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/merge_requests/2399

Update the name of the S3 folder to write dumps to: /wikibase-dumps -> /wikidata-rdf-export

I've cleaned out the S3 bucket; however, for now, dumps will continue to be written to the old directory, so we'll need to manually move them as they happen. So I'll leave this on hold until https://gitlab.wikimedia.org/repos/data-engineering/airflow-dags/-/merge_requests/2319 is in.

All done, and i've cleaned up /wikibase-dumps/ at last. Marking as resolved.