Hello I have quite a few files that I want to combine using Azure Data Factory. I'm currently using Union activity in dataflow to combine a few files at once but I have about a thousand files and was wondering…
I'm working on a function app and trying to use the key vault to store my connection string. In my web MVC application we do not have to put in any C# code into place when we deploy to production.…
We're using snapcraft snaps to publish our software. We have a classic pipeline step for logging into snapcraft, one for releasing the snap and one for logging out. However, we're unable to release the snap because the agent loses the…
I have an Azure Logic App (Consumption). I have Dev version and I would like to deploy it to test and then to production. So far I've been able to: export the template from the portal decompile it with bicep…
How do I sum the count of populated fields. An example of the data. The desired output would be. This is what I have managed so far. select m.project_ref, ( select count(*) from (values (m.[EWI/IWI]), (m.Glazing), (m.Solar), (m.CWI), (m.Boiler), (m.TRV),…
I can get a bearer token using these parameters Get-MsalToken -ClientId '' -TenantId '' -Scopes '' I am trying to convert it to use C# instead of PowerShell: var clientId = "xyz"; var tenantId = "xyz"; // We intend to…
I am using Azure Health Data Services - FHIR service In FHIR Claim resource, we have diagnosis property. Inside the diagnosis property --> diagnosisCodeableConcept --> code. Now I want to create a custom search parameter to retrieve claim resources based…
I am coping data from blob storage to SQL database. In source I have multiple files with different schema so when schema doesn't match to destination table it fails copy data for that file. I want pipeline to be succeeded…
I am invoking IDurableOrchestrationContext.CurrentUtcDateTime in my Azure Durable Function. var nextRun = context.CurrentUtcDateTime.AddMinutes(1); await context.CreateTimer(nextRun, CancellationToken.None); context.ContinueAsNew(context.NewGuid().ToString()); When I look in the logs, I am seeing this message from the task hub (FYI - today's date is 2023-09-27): Function 'RunOrchestrator…
I have a table named Report_Table in Azure SQL. It has more than one hundred columns. I will give an example with 3 columns like: +--------+----------+------+ | job_id | rep_pm | done | +--------+----------+------+ | 46 | a002 | a…