I've open sourced two GitHub repos:
1. Forge-Core. This is the secret sauce. Automatically parse ANY json structure inside your own data warehouse by mapping your schema and building dbt models on the fly. Easy to set up and use. https://github.com/foxtrotcommunications/foxtrotcommunicatio...
2. Avalon-Public. Following the forge parse, use these dbt models to correctly and efficiently build your needed omop models. https://github.com/foxtrotcommunications/foxtrotcommunicatio...