Writing output of Azure Synapse SQL to Azure blob
I have a Azure Synapse SQL workspace. I want it to: (a) read the data from Azure blob storage, (b) run the SQL query, and (c) write the output back to Azure blob. I got (a) and (b) above working…
How can I manually fail an Azure Function?
Description: I have an Azure Function on a timer trigger that performs multiple steps. Each step has its own try/catch block to swallow any exceptions and log them. These steps are not dependent on each other, therefore I do not…
Azure – Application Insights REST API doesn't return rows
I use this endpoint to query data from my App insight The problem is, it always returns empty rows i.e. "rows": []. { "tables": [ { "name": "PrimaryResult", "columns": [ { "name": "timestamp", "type": "datetime" }, { "name": "message", "type":…
Azure Communication Services – How do I authenticate against Azure IAM
I'm using Azure Communication Services for SMS and emails. It works just fine if I use it with an endpoint and an access key or with the connection string itself. However, that's not a good practice and I would like…
How do I push CSV file from blob storage to Azure Cosmos DB for Apache Cassandra?
I am not able to push my csv file which is in blob storage to Azure Cosmos DB for Apache Cassandra I haven't tried anything yet, I am not able to find any proper material
Azure – How get access token for another resource using Microsoft OAuth
The user logs in with https://login.live.com/oauth20_authorize.srf Parameters: client_id=<CLIENT_ID> response_type=code scope=XboxLive.signin offline_access redirect_uri=<REDIRECT_URL> And gets an authorization_code M.R3_BAY.5530f5eb... When using: https://login.live.com/oauth20_token.srf grant_type=authorization_code client_id=<CLIENT_ID> scope=Xboxlive.signin Xboxlive.offline_access code=M.R3_BAY.5530f5eb... redirect_uri=https://localhost/oauth_success client_secret=<CLIENT_SECRET> Getting access_token and refresh_token. I want to use one of these tokens to…
Azure: CLI OData filter string matching
How to filter results using the OData filter on matching substrings? $ az ad app list --help ... Arguments: --filter : OData filter, e.g. --filter "displayname eq 'test' and servicePrincipalType eq 'Application'". As per this documentation, I should be doable…
How to use Azure Key Vault from Localhost using VS2022
I have configured Managed Identities for my Web App in App Services and registered this Web App using Azure App Registrations. For development purposes, I want to be able to run this app locally and use the Key Vault secrets.…
Need to find peak usage of each API call from Azure App Insights
Need to find each API Max hour usage in a given day in Azure App insight using query. For example API A has total hit between 1 PM to 2PM is 10, 2 PM to 3 PM is 20 and…
Azure bicep and parameter
Is there a way to add a resourceid as a parameter ? param ftports array = [ { name: 'test' value_id:resourceId('Microsoft.Network/virtualNetworks/subnets', myVNet_name, 'mySubnet') } ] can't get rid of the error "This symbol cannot be referenced here. Only other parameters…