Skip to main content

Using the AtScale Looker Studio Connector

Note

The following is a preview of the AtScale Looker Studio Connector. This functionality will become available in a future release.

The AtScale Looker Studio Connector enables seamless access to governed, enterprise-scale semantic models managed in AtScale, directly from Looker 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 Looker Studio report based on an AtScale model.

What the connector does​

The connector integrates AtScale's semantic layer with Looker 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 Looker 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, Looker Studio fetches metadata (models, measures, and dimensions) from AtScale.
  4. Users can drag and drop metrics into Looker 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/.

Add a data source for the AtScale Connector​

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

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

For more details or support, visit atscale.com.

Privacy policy and terms of use​

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