Looker Studio, previously Google Data Studio, is a free tool that transforms data into interactive, customizable dashboards and reports, with a range of visualization options and no need for programming. It connects to a variety of data sources, including databases, Google products, flat files, and social media platforms, and offers features for sharing, collaboration, and access control, making data storytelling accessible to individuals, teams, and organizations.
With this destination, Dataddo stores the flow's data and Looker Studio pulls it in for reporting.
Authorize Connection to Looker Studio
Authorize the connection so Dataddo can expose the data to Looker Studio:
| Field | Description |
|---|---|
| A name for this authorizer in Dataddo | A label so you can recognize the connection later. |
| Dataddo token | Select the dataddo token to be used for this authorizer. This token will be used when querying Dataddo API. |
Dataddo validates the connection when you save it.
Create a Looker Studio Destination
Go to Destinations, click Create Destination, and select Looker Studio. Give the destination a name, choose the authorizer, and click Save.
Connect Looker Studio to Dataddo
Dataddo keeps the flow's data ready for Looker Studio to read. In Looker Studio, add a new data source that points to the Dataddo destination you created, using the credentials from the authorizer above. Looker Studio then loads the data and refreshes it on its own schedule.
How to Create a Flow to Looker Studio
- Go to Flows and click Create Flow.
- Add one or more sources.
- Add Looker Studio as the destination and pick the authorizer.
- Set the schedule and click Save.
- Open Looker Studio and connect to the data as described above.
Troubleshooting
Looker Studio shows no data
The flow has not run yet, or Looker Studio points at the wrong connection. Run the flow once, then confirm the connection details in Looker Studio match the authorizer.
Cannot connect from Looker Studio
Reauthorize the connection in Dataddo and re-enter the credentials in Looker Studio.