You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 8
Next »
- Familiarize yourself with the Metadb documentation
- The Metadb documentation from Index Data is revised continuously with the latest information on using Metadb
- See https://metadb.dev/doc/
- For the conversion process, the important section of the documentation to focus on is 4.1.4 Migration from LDP
- Convert LDP table references to their Metadb equivalents
- use the Migration from LDP table conversion chart supplied in the Metadb
- https://metadb.dev/doc/#_migrating_from_ldp
- table names in metadb are case sensitive
- many tables names that use singular instead of plural form now
- for dashboards, if table names have changed it doesn't make a difference, but field names do need to be changed back to LDP names
- Update Derived Table references
- update your derived table references from LDP's folio_reporting schema to Metadb's folio_derived schema
- Update Data Fields that have Changed in Metadb
- See LDP to Metadb field name changes
- Please add notes to this page if you find additional field name changes we should know about - thanks!
- Test Your Query
- Once you appear to have a working Metadb version of your query, it is important to test it
- Do the LDP and Metadb versions of your query produce the same results? (assuming you have production data going to both LDP and Metadb)
- Ask someone else on the reporting team to test your query
- Document and Publish Your Query
- With the move to Metadb, we are taking the opportunity to make our naming conventions and query documentation better and more consistent
- LDP to Metadb Query Naming Convention
- Leave CR numbers in place, even if query is archived, to avoid confusion
- To revise a CR or AHR query for LDP to Metadb format, use same CR or AHR number, but precede with M to maintain a connection between the 2 queries for testing purposes. For example, CR100 becomes MCR100, AHR120 becomes MAHR120
- For new Metadb queries, we start in the 400 range, so MCR400 is the first metadb-only query
- Post the Metadb version of your LDP Query on the cul-folio-analytics GitHub repository
- log into GitHub and navigate to new metadb section at https://github.com/cul-it/cul-folio-analytics/tree/main/metadb
- make sure you know the name of this query
- create a new directory for the query and publish it at the same time as you create the new file in the metadb section of the repository, e.g.,
- click to create a new file and type in "MCR120/daily_appr_inv_control.sql" to create the directory and name the file in one step
- paste the text for your revised query into the new file and commit the file to publish it