CODEWITHSUNDEEP
amazon-web-servicesgoogle-analyticsamazon-redshiftlooker-studio
jfk83
jfk83

Reputation: 810

Can Google Data studio be able to connect to AWS RDS or Redshift currently?

Maybe this really basic question, but I am trying to connect Data studio to AWS MySQL or with Redshift. I have found old posts where people say that is not possible.

But I am not sure if this is currently possible.

Upvotes: 1

Views: 5448

Answers (2)

Juanlu
Juanlu

Reputation: 79

Yes, it's possible to connect Data Studio to Redshift with the Redshift connector (released December 2021). https://support.google.com/datastudio/answer/11377200?hl=en

The Amazon Redshift connector lets you create data sources based on Amazon Redshift. You can then visualize that data in your Data Studio reports and explorations.

You have two connection methods available:

  • Connect with a hostname or IP address
  • Connect with a JDBC URL: jdbc:redshift://<hostname or IP address>[:<port>]/<database>

Note it's a beta feature:

This feature is in beta testing. You can expect this feature to change, and there may be some rough edges.

There are also some limitations:

  • You can query a maximum of 150K rows using this connector.
  • Column headers (field names) must use ASCII characters only. Non-ASCII characters aren't supported.

Upvotes: 1

Minhaz Kazi
Minhaz Kazi

Reputation: 3168

You can connect to MySQL databases with the Data Studio MySQL connector.

You can expose your Redshift data by using JDBC driver or by deploying a REST API. You can then build a Data Studio Community Connector to fetch data from either of these sources.

Upvotes: 1

Related Questions