Toggl data in Google Dataé Studio through Google BigQuery

Hello,

I’m trying to connect Toggl to Google Data Studio through Google BigQuery.
I followed this tutoriel: https://www.stitchdata.com/blog/tutorial-using-google-data-studio-with-bigquery-and-stitch/

The integration is done: I collect data from Toggl and push them to BigQuery and I can see my tables in Google Data Studio.
The issue is that my tables don’t contain the data I want (user name, client name, task name, tag name…) but only INTEGER and TIMESTAMP data:

Many thanks for you help

Are those the only columns you see in BigQuery? The _sdc columns are ones that Stitch adds — they don’t come from Toggl. Have you set the tables and columns you want to replicate? If you haven’t done so already, check out the documentation at https://www.stitchdata.com/docs/integrations/saas/toggl. If you don’t find an answer there, you can ask about the integration in the Singer Slack workspace; Toggl is a community-supported integration.

Hi @lee_stitch,

Thank you for your answer.
I did everything in the tutorial: integration, tables to replicates… but still empty.

I can’t post on the Slack because I don’t have a @stitchdata.com email: how can I have one?

Many thanks,

Hmm. I thought the Singer Slack was open to everyone. I just sent you an invitation to join.

Hello @lee_stitch,

I found where was the issue.
When I checked the tables, it imports only the Stitch data, not Toggl. I had to click on the table itself and checked the Toggl subtables.

Very small details but huge impact :slight_smile:

Now it works!

1 Like