This guide shows how to connect to bit.io with Google Data Studio by setting up a PostgreSQL Data Source.
First, click the "create" button and select "Data source."
Next, select "PostgreSQL" from the list of Google connectors and click "authorize." You will be prompted for connection details, which you can find in your database's "connect" menu on bit.io. You will also need to provide a
You will need to supply a PostgreSQL SSL server certificate. You can download the certificate here.
Unlike most PostgreSQL clients, Google Data Studio cannot automatically obtain the necessary SSL certificate. It must be downloaded manually. You can download the certificate here. Make sure "Enable SSL" is selected, and then upload the file in the "PostgreSQL SSL Configuration Files" section.
Lastly, click "Authenticate" to connect to your bit.io database with Google Data Studio.
Read Google's Official Documentation for more details on connecting to a PostgreSQL database with Google Data Studio.
Updated 23 days ago