Forum Widgets
Latest Discussions
Announcing an Azure Data and Analytics AMA on October 13!
We are very excited to announce an Azure Data and Analytics AMA on October 13! This is the first in a series of AMAs around Azure, all held here in the Tech Community in this discussion space, coinciding with the Microsoft Azure Hack for Social Justice event Upcoming dates/events are below: October 20 - Azure AI & Cognitive Services October 29 - Azure Serverless & Azure Function November 5 - App Services & Standard Web Apps The AMA will take place on Tuesday, October 13, 2020 from 9:00 a.m. to 10:00 a.m. PT in the Azure AMA space. Add the event to your calendar and view in your time zone here. An AMA is a live online event similar to a “YamJam” on Yammer or an “Ask Me Anything” on Reddit. This AMA gives you the opportunity to connect with cloud solution architects who will be on hand to answer your questions and listen to feedback.Welcome to the Azure Data and Analytics AMA!
Welcome to the Azure Data and Analytics Ask Microsoft Anything (AMA)! This live hour gives you the opportunity to ask questions and provide feedback. Please introduce yourself by replying to this thread. Post your questions in a new thread within the Azure AMA space, by clicking on, "Start a New Conversation" at the top of the page.
Should I ingest AADNonInteractiveUserSignInLogs from Entra ID to a LAW
As the title says, I am interested in expert opinions on whether I should include the AADNonInteractiveUserSignInLogs from Entra ID in a LAW, as this table dwarfs the SignInLogs in terms of the amount of data (by a factor of 8x) and therefore creates higher costs. Secondly, I am curious if there are ways to reduce the amount of non-interactive SignInLogs that are generated in the first place.HDInsight Learn Content
Folks, Please find the consolidated list of learn content available for HDInsight. Contains product vision and strategy , service specific learning paths , videos and labs. Feedback on content is most welcome. Happy Learning !! HDInsight distribution announcement: Microsoft OSS Repo Announcement Learn Content: HDInsight MS Learning Path : https://docs.microsoft.com/en-us/learn/paths/build-oss-analytical-solutions-az-hdinsight/ HDInsight MS Build 2020 Presentation: https://mybuild.microsoft.com/sessions/82c174de-44b2-49ab-93a1-14b7e5c0ec22?source=sessions Virtual Instructor Led Trainings : https://partner.microsoft.com/en-us/training/assets/collection/running-open-source-big-data-frameworks-on-azure-hdinsight#/ HDInsight Blog: Analytics on Azure - Microsoft Tech Community HDInsight Quick Start templates: Azure Quickstart Templates (microsoft.com) HDInsight documentation : https://azure.microsoft.com/en-us/services/hdinsight/ - ArnabAnnouncing an Azure HDInsight AMA on January 28!
We are very excited to announce an Azure HDInsight AMA! The AMA will take place on Thursday, January 28, 2021 from 10:00 a.m. to 11:00 a.m. PT in the Azure AMA space. Add the event to your calendar and view in your time zone here. An AMA is a live online event similar to a “YamJam” on Yammer or an “Ask Me Anything” on Reddit. This AMA gives you the opportunity to connect with Microsoft product experts who will be on hand to answer your questions and listen to feedback.
Azure Log Analytics query editor copy paste formatting
When pasting certain integers into the Azure Log Analytics query editor (eg. 1594312), they are automatically formatted as todatetime('1594312'). This is quite inconvenient as we often paste reference numbers into specific queries. Does anyone know why this is and how to prevent it?
Using SSRS with Azure SQL
I have several hundred SSRS reports that have a parameterized connection string allowing the server and database to be selected by passing parameters. I moved the 300 or so databases that use these reports to AZURE SQL in an elastic pool. What does Microsoft offer to host my RDL files in Azure? Does the fee I pay for the Azure Databases cover a license to run SSRS like having the deployment onsite does?
Cost-effective alternatives to control table for processed files in Azure Synapse
Hello, good morning.In Azure Synapse Analytics, I want to have a control table for the files that have already been processed by the bronze or silver layers. For this, I wanted to create a dedicated pool, but I see that at the minimum performance level it charges 1.51 USD per hour (as I show in the image), so I wanted to know what other more economical alternatives I have, since I will need to do inserts and updates to this control table and with a serverless option this is not possible.
Unable to retrieve query data using Log Analytics API
I have been trying to access Azure KQL data with the help of Log Analytics REST API, the connection is successful showing a 200 response but I am only getting the table headers and not getting any data in the table. Does anyone know how to resolve this? Code snippet: import requests import urllib3 from azure.identity import DefaultAzureCredential from datetime import datetime, timedelta, timezone import certifi import os os.environ["REQUESTS_CA_BUNDLE"] = certifi.where() verify_cert = certifi.where() credential = DefaultAzureCredential() # Set the start and end time for the query end_time = datetime.now(timezone.utc) start_time = end_time - timedelta(hours=6) # Set the query string query = ''' KubePodInventory | take 5 ''' # Set the workspace ID workspace_id = "XXXXXXXXXXXXXXXXXXXXXXXX" # Set the API endpoint api_endpoint = f"https://api.loganalytics.io/v1/workspaces/{workspace_id}/query" # Set the request payload payload = { "query": query, "timespan": f"{start_time.isoformat()}Z/{end_time.isoformat()}Z" } # Set the request headers headers = { "Content-Type": "application/json" } # Disable SSL certificate verification urllib3.disable_warnings(urllib3.exceptions.InsecureRequestWarning) # Authenticate the request using the Azure credential access_token = credential.get_token("https://api.loganalytics.io/.default").token headers["Authorization"] = f"Bearer {access_token}" # Send the POST request response = requests.post(api_endpoint, json=payload, headers=headers, verify=False) # Check the response status if response.status_code == 200: data = response.json() tables = data.get('tables', []) if tables: table = tables[0] # Assuming there is only one table returned columns = table.get('columns', []) rows = table.get('rows', []) if columns and rows: for row in rows: for i, column in enumerate(columns:( column_name = column['name'] column_type = column['type'] row_value = row[i] print(f"Column name: {column_name}, Data type: {column_type}, Value: {row_value}") else: print("Empty table or no data in table") else: print("No tables found in the response") else: print(f"Request failed with status code: {response.status_code}") print(f"Error message: {response.text}")
