Hi @ChristineP ,
We’ve recently created a guide on how to easily connect Matomo to Google Data Studio without needing direct database access. You can find the setup guide here: https://matomo.org/faq/new-to-piwik/how-to-import-matomo-data-in-to-google-data-studio/
Hope this helps! Please feel free to contact us with any feedback or suggestions you might have concerning this.