Requested Features: (Gateway connection status) 1. Gateway Connection Health API - Endpoint: GET /gateways/{gatewayId}/{connection}/health - Returns: Overall gateway connection health status (online/offline/degraded) - Includes: Last heartbeat timestamp, connectivity status 2. Datasource Connection Test API - Endpoint: POST /gateways/{gatewayId}/datasources/{datasourceId}/test - Returns: Connection test result without triggering actual data operations - Includes: Response time, connection success/failure, error details 3. Gateway Metrics API - Endpoint: GET /gateways/{gatewayId}/metrics - Returns: Performance metrics (CPU, memory, active connections, query queue) - Supports: Time-range queries for historical data Use Case: Organizations need to proactively monitor gateway infrastructure for: - Alerting when gateway connection go offline - Detecting SQL Server connection failures before users report issues - Integrating with external monitoring tools (Datadog, Azure Monitor, etc.) - Meeting SLA requirements for data availability Current Limitations: - Existing APIs only show gateway registration status, not real-time connectivity - No way to test datasource connections without triggering data refreshes - No programmatic access to gateway performance metrics Expected Benefit: This would enable enterprise customers to build robust monitoring solutions and ensure high availability of their data infrastructure. --- Please vote if you'd find this valuable for your organization!
... View more