azure

what is the meaning of WITH (jsonContent varchar(MAX)) AS [result] in this code on azure synapse analytics

I am not able to undertsand why we are writing with (doc nvarchar(max)) as rows JSON FILE {"date_rep":"2020-07-24","day":24,"month":7,"year":2020,"cases":3,"deaths":0,"geo_id":"AF"} {"date_rep":"2020-07-25","day":25,"month":7,"year":2020,"cases":7,"deaths":0,"geo_id":"AF"} {"date_rep":"2020-07-26","day":26,"month":7,"year":2020,"cases":4,"deaths":0,"geo_id":"AF"} {"date_rep":"2020-07-27","day":27,"month":7,"year":2020,"cases":8,"deaths":0,"geo_id":"AF"} My Code to open this JSON file start from here. select JSON_VALUE(doc, '$.date_rep') AS date_reported, JSON_VALUE(doc, '$.countries_and_territories') AS country,…

VIEW QUESTION

Use $filter query parameter on /groups/{id}/members with Graph API for Azure B2C Tenant

Performing the following HTTP request to the Microsoft Graph API: GET https://graph.microsoft.com/v1.0/groups/{id}/members?$count=true&$filter=startswith(displayName, 'a') ConsistencyLevel: eventual Results in the following response when querying users for an Azure B2C tenant: { "error": { "code":"Request_UnsupportedQuery", "message":"The specified filter to the reference property query…

VIEW QUESTION

Block port 80 access in Azure Front door

I created a Standard tier Front Door with the necessary Azure WAF with default configurations. If I do this: Test-NetConnection -ComputerName "<frontdoorurl>-dev-xxxxxx.z01.azurefd.net" -Port 80 ComputerName : <frontdoorurl>-dev-xxxxxx.z01.azurefd.net RemoteAddress : xxxx:xxx:xx:x::xx RemotePort : 80 InterfaceAlias : Ethernet 7 SourceAddress : xxxx:xxxx:xx:xxx:xxxx:xxxx:xxx:xxxx…

VIEW QUESTION
Back To Top
Search