This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Intermittent Dataset Configuration Error in Looker Studio (Redshift Source)

Posted on 04-10-2025 05:07 AM
Jaden2
New Member
Reply posted on --/--/---- --:-- AM

I'm using Looker Studio with an Amazon Redshift data source. Everything is set up correctly, the connection works, credentials are valid, security group rules are configured, and the Redshift cluster is publicly accessible with only Looker's IPs whitelisted.

When I open my dashboard, I sometimes get a “Dataset Configuration Error.” This happens inconsistently, but often enough to disrupt the experience.

Would love to hear from others who’ve faced this with Redshift as a source and what they did to solve the issue.image.jfifimage (1).jfifimage.pngimage (1).pngimage (2).png

 

0 1 51
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
阿泰
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Did you try adding an intermediate transport resource, such as Google Sheets? I think your data flow could be like this:
Amazon Redshift => Google Sheets => Looker Studio.

This approach can help you identify which data has issues in Google Sheets. When you need to update the data, just update the Google Sheet first, then update Looker Studio accordingly.

0 Likes