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.pem for your Managed Service for TimescaleDB service.
    • Make a note of the Host, Port, Database name, User, and Password fields for the Managed Service for TimescaleDB service.
  1. Log in to Google and open Google Data Studio.
  2. Click the Create + button and choose Data source.
  3. Select PostgreSQL as the Google Connector.
  4. In the Database Authentication tab, type details for the Host Name, Port, Database, Username, and Password fields.
  5. Select Enable SSL and upload your server certificate file, ca.pem.
  6. Click AUTHENTICATE.
  7. Choose the table to be queried, or select CUSTOM QUERY to create an SQL query.
  8. Click CONNECT.

Found an issue on this page?Report an issue or Edit this page in GitHub.