Skip to main content

Using AtScale with Google Data Studio

The AtScale Data Studio Connector enables seamless access to governed, enterprise-scale semantic models managed in AtScale, directly from Google Data Studio. With this connector, business users and analysts can build dashboards and visualizations on top of trusted data definitions, ensuring consistency and accuracy across every report.

A Data Studio report based on an AtScale model.

What the connector does​

The connector integrates AtScale's semantic layer with Data Studio's visualization and reporting interface, allowing users to:

  • Connect to AtScale data models hosted on-premises or in the cloud.
  • Query live, aggregated data through AtScale's intelligent query acceleration engine.
  • Visualize governed metrics, hierarchies, and dimensions in Data Studio with no manual modeling.
  • Empower self-service analytics while maintaining enterprise-level governance and performance.

How the connector works​

  1. The connector authenticates securely using OAuth 2.0.
  2. Users provide the URL of their AtScale instance (on-premises or cloud).
  3. Once connected, Data Studio fetches metadata (models, measures, and dimensions) from AtScale.
  4. Users can drag and drop metrics into Data Studio to build live, interactive dashboards.

Configure the Identity Broker​

For the connector to authenticate with your AtScale server, you must first configure the OAuth2 callback URL in the Identity Broker:

  1. Log in to Design Center as an admin user.

  2. In the sidebar, click Security. The Identity Broker opens.

  3. In the sidebar, click Clients.

  4. Click Create client. The Create client page opens.

  5. In the General settings step, complete the following fields, then click Next.

    • Client type: Select OpenID Connect.
    • Client ID: Enter looker-studio-connector.
    • Name: Enter looker-studio-connector.

  6. In the Capability config step, complete the following fields, then click Next.

    • Client authentication: Set to On.
    • Authentication flow: Select Standard flow.

  7. In the Login settings step, complete the following fields, then click Save.

    • Valid redirect URIs: Enter https://script.google.com/macros/d/*.
    • Valid post logout redirect URIs: Enter https://script.google.com/macros/d/*.
    • Web origins: Enter https://script.google.com/.

Install the AtScale Connector​

Next, you need to install the connector. You can do this via the Data Studio Connector Gallery:

The Data Studio Connector Gallery, displaying the AtScale Semantic Layer Partner Connector.

Add a data source for the AtScale Connector​

Next, you need to add a data source for the AtScale Connector in Data Studio:

  1. Open Data Studio.
  2. Click Create > Data Source > AtScale Connector.
  3. Enter your AtScale instance URL and credentials.
  4. Select your model and start building reports.
Note

The AtScale Connector supports the use of Viewer's Credentials with AtScale-based data sources. When set, Data Studio forces the report to use the active viewer's personal Google account to fetch data. For more information, refer to the Google Data Studio documentation.

For more details or support, visit atscale.com.

Privacy policy and terms of use​

Your use of the AtScale Data Studio Connector is governed by AtScale's standard policies. Review the following documents for details on data handling, user responsibilities, and acceptable use: