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
deep-jade•2y ago
Hey 👋🏻
I'm taking a look at this!
deep-jade•2y ago
1. Create a Data Source
deep-jade•2y ago
2. Filter for PostgreSQL
deep-jade•2y 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
deep-jade•2y ago
4. Enable SSL
deep-jade•2y 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...
deep-jade•2y ago
6. Upload the downloaded file using the upload button.
deep-jade•2y ago
7. Once authenticated you'd see the tables from your Neon database that you'd want to use as the source.
adverse-sapphire•2y ago
Oh, did they fix this again? Looker studio has flipped between working and broken in the past 😓
deep-jade•2y 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?