How to send Data generated on PSQL server to Azure Dashboard?

newposter 1 Reputation point
2021-07-06T01:36:24.877+00:00

I am creating a metrics in PSQL server, now I have some data (a table), and I would like to send that data to azure dashboard.

Can anyone assist me with your insights into this issue, by providing any documentation or information on how can I achieve this?

Azure Database for PostgreSQL
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2021-07-06T21:30:57.587+00:00

    @newposter Welcome to Microsoft Q&A and thank you for posting your question.

    You can use Azure Monitor Logs Analytics to create a custom dashboard for Azure Database for PostgreSQL. You can create a dashboard and monitor your Azure Database for Postgres. Please find more details and step by step in this blog. Create a Monitoring Dashboard for Azure Database for PostgreSQL.

    Regards,
    Oury


  2. Oury Ba-MSFT 16,076 Reputation points Microsoft Employee
    2021-07-17T00:27:36.74+00:00

    Hi @newposter

    Steps explaining how this can be achieved.

    1. Navigate to Metrics of the Coordinator Node and Select the Metric required.

    115460-image.png

    1. On the Right hand side, you have an option to Pin to Dashboard. Select another Dashboard and create a new dashboard.

    115544-image.png

    115571-image.png

    1. Once you create a new Dashboard, search for shared dashboards in Azure Portal. You will find the Dashboard you just created.
      115508-image.png
    2. Click on Go to Dashboard and you will be able to see the metric that you just pinned.

    115545-image.png
    115572-image.png

    1. Similarly, you can add other nodes but from the second Node of the cluster, you have to select as “Pin to current Dashboard” and select the existing you created.

    115539-image.png

    115540-image.png

    1. The newly added Metric will be pinned beside the previous metric chart on the dashboard.

    115529-image.png

    1. Similarly, we add as many metrics required and also make changes on the UI and set filters.
      115496-image.png

    Hope that helps

    Regards
    Oury