Step 1: Navigate to Looker Studio:
Step :2 Create a new report and connect to data.
Make sure you choose the PostgreSQL connector.
Step 3: Create a SQL user
Go to Data Lake --> "Manage Database Settings"
2. Click on "+ Add SQL User".
Your username and password will appear below.
Step 4: Add the credentials
Host Name: identity-store-01-do-user-2735892-0.g.db.ondigitalocean.com
Port: 25060
User: Type in the username generated in Step 3.
Password: Type in the Password generated in Step 3.
Default Database: <the name of the database you want to connect>
Enable SSL: Checked
Download the following Certificate: ca-certificate.pem
Upload the Certificate: Click on the upload button and import the certificate you just downloaded.
Step 5: Authenticate and choose the table
After you've clicked on authenticate you will see the available tables. Select the table you want to add and click on the "Add" button.
You're all set!