Connect to Google Data Studio

Starting in Strategy (November 2026), you can connect to your Google Data Studio data to the Strategy Semantic Service using the Data Studio connector.

Prerequisites

  • You must have the Use Universal Access privilege.

    If a user encounters a Community Connector Error in Data Studio, ensure the user has this privilege.

  • Ensure the Strategy Library you want to access from Data Studio is publicly accessible.

Connect to Google Data Studio

  1. In Strategy Library, click Data in the Navigation pane.

  2. Click Additional Information next to your Mosaic model.

  3. Click the Universal Access tab.

  4. In the Data Studio section, click Copy next to Path.

  5. Click Open in Data Studio.

    The Mosaic connectivity dialog displays in your Data Studio environment.

  6. Paste the path you copied in step 4 into Path.

  7. Enter your Strategy Username and Password.

  8. Click Submit.

  9. In Catalog, choose sql.

  10. In Schema, choose your Strategy project.

  11. In Table or view, choose your Strategy model.

  12. Optionally edit your Row limit.

  13. Click Connect.

  14. Verify all fields and rename the Mosaic connection.

  15. Click Create Report.

  16. Query your data and apply filters, as needed.

  17. To connect to a different Strategy Library environment:

    1. Go to the following URL: https://datastudio.google.com/u/0/datasources

    2. Click More Options and choose Revoke access.

    3. Repeat steps 1 to 16 above.