You can create reports or perform some analysis on data you have in Managed Service for TimescaleDB using Google Data Studio. You can use Data Studio to integrate other data sources, such as YouTube Analytics, MySQL, BigQuery, AdWords, and others.
- You should also have a Google account.
- In the service overview page of the Managed Service for TimescaleDB service:
- Download the CA certificate named
ca.pemfor your Managed Service for TimescaleDB service. - Make a note of the
Host,Port,Database name,User, andPasswordfields for the Managed Service for TimescaleDB service.
- Download the CA certificate named
- Log in to Google and open Google Data Studio.
- Click the
Create +button and chooseData source. - Select
PostgreSQLas the Google Connector. - In the
Database Authenticationtab, type details for theHost Name,Port,Database,Username, andPasswordfields. - Select
Enable SSLand upload your server certificate file,ca.pem. - Click
AUTHENTICATE. - Choose the table to be queried, or select
CUSTOM QUERYto create an SQL query. - Click
CONNECT.
Found an issue on this page?
Report an issue!