Building back matomo views

Hey there !

At my company, we’re heavily relying on Matomo to discover how users are interacting with our SaaS platform.

As we use a side software for visualization (Metabase), we would like to sync data with an outside database like MySQL or Postgres. However, when doing so, we fell on the fact that the Matomo database scheme is really blurry, with tables like blob_january_2022, whereas we thought from the UI we could have a visit table, a pageviews table etc.

Does somebody know where I could find the SQL requests to build these tables back from the database ?

I think in this case that you should then aggregate yourself the data thanks to some BI software… (and then ignore tables like blob_january_2022)
For the database schema: