Connect to Data Studio / Looker Studio
I'm trying to connect a neon database to looker studio and I keep getting an error, even after following the guide here: https://community.neon.tech/t/connect-to-data-studio-looker-studio/299
Neon
Connect to Data Studio / Looker Studio
Hi! 👋 👋 I migrate from heroku recently on my project with hasura, but now I don’t have metrics about my SaaS, is possible to connect to Data Studio? Some idea how? Regards.
10 Replies
wise-white•16mo ago
Hey 👋🏻
I'm taking a look at this!
wise-white•16mo ago
1. Create a Data Source
wise-white•16mo ago
2. Filter for PostgreSQL
wise-white•16mo ago
3. Enter your neon things
make sure to not have the
/neondb?sslmdrequire in the host URL
so an example of the hostname would be:
ep-muddy-hat-a58q355j-pooler.us-east-2.aws.neon.tech
wise-white•16mo ago
4. Enable SSL
wise-white•16mo ago
5. Download the
pem file under Active named ISRG Root X1.
https://letsencrypt.org/certificates/#root-certificatesChains of Trust
Note: This section describes Let’s Encrypt’s hierarchy as of June 6, 2024. For the hierarchy in use prior to June 6, see below.
This page describes all of the current and relevant historical Certification Authorities operated by Let’s Encrypt. Note that a CA is most correctly thought of as a key and a name: any given CA may be represented by mu...
wise-white•16mo ago
6. Upload the downloaded file using the upload button.
wise-white•16mo ago
7. Once authenticated you'd see the tables from your Neon database that you'd want to use as the source.
correct-apricot•16mo ago
Oh, did they fix this again? Looker studio has flipped between working and broken in the past 😓
wise-white•16mo ago
ah yeah this seems to be working fine with Neon as I tested this right now, anything in particular I can test to confirm?