Check if Azure Synapse is Online

azure-synapse-online-status.cs

using Azure.Identity;
using Azure.ResourceManager.Resources;
using MyFunctionProject.Models;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Options;
using System;
using System.Collections.Generic;
using System.Threading;
using System.Threading.Tasks;

namespace MyFunctionProject.Services
{
    public interface IAzureResourceManagementApiService
    {
        Task<bool> IsSynapseOnlineAsync(CancellationToken cancellationToken);
    }

    public class AzureResources : IAzureResourceManagementApiService
    {
        private readonly IOptions<AzureConfig> _azureConfig;
        private readonly ISqlConnectionService _connectionService;
        private readonly ILogger<AzureResources> _logger;

        public AzureResources(IOptions<AzureConfig> azureConfig, ISqlConnectionService connectionService, ILogger<AzureResources> logger)
        {
            _azureConfig = azureConfig;
            _connectionService = connectionService;
            _logger = logger;
        }

        public async Task<bool> IsSynapseOnlineAsync(CancellationToken cancellationToken)
        {
            var resourceClient = new ResourcesManagementClient(_azureConfig.Value.SubscriptionId, new DefaultAzureCredential());
            var resp = await resourceClient.Resources.GetAsync(_azureConfig.Value.ResourceGroup, $"Microsoft.Sql/servers", _connectionService.DatabaseServerName, "databases", _connectionService.DatabaseName, "2020-08-01-preview", cancellationToken);
            var props = (Dictionary<string, object>)resp.Value.Properties;

            if (!props.ContainsKey("status")) 
                throw new Exception($"Querying Azure Resource Management for '{_connectionService.DatabaseServerName}/{_connectionService.DatabaseName}' did not return the expected response. 'status' key not found in resource properties.");

            var status = (string)props["status"];

            switch (status.ToLower())
            {
                case "online": 
                    return true;
                default:
                    {
                        _logger.LogWarning($"Synapse database '{_connectionService.DatabaseServerName}/{_connectionService.DatabaseName}' is not online, it is '{status}'");
                        return false;
                    }
            }
        }
    }
}