I do something similar, building a lightweight search index over very large relational datasets.

So the tables are much simpler to manage, much more portable, so I can serve search off scalable hardware without disturbing the underlying source of truth.

The downside is queries are more complex and slower.