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

Update BOM Postgres structure with new data columns #165

Open
hepplerj opened this issue Jan 28, 2025 · 1 comment
Open

Update BOM Postgres structure with new data columns #165

hepplerj opened this issue Jan 28, 2025 · 1 comment
Assignees
Labels
type: database Database-related issues

Comments

@hepplerj
Copy link
Member

As part of the reworked data pipeline (#146), the structure for the data has changed. @hepplerj has the schemas worked out already and tested locally, and are available in the initialize_up.sql file. Once the schema is in place, the new insert_update.sql will handle new DataScribe exports for uploading them into Apiary.

@hepplerj hepplerj added the type: database Database-related issues label Jan 28, 2025
@hepplerj hepplerj self-assigned this Jan 28, 2025
@hepplerj
Copy link
Member Author

This Issue is briefly on hold, but will require the following:

  • create a backup of the existing database
  • dump all data from the existing database
  • run initialize_up to create the new tables and structure
  • run insert_update to add the most recent data export

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: database Database-related issues
Projects
None yet
Development

No branches or pull requests

1 participant