OData query filter for Datatime
Good Day, At Azure Table Storage, if i want to filter by columns less than Now() I tried the below but aint work, using Storage Exporer and Python "ExpiresOn lt datetime'2024-12-08T06:06:00.976Z'" now = datetime.now(timezone.utc) …
How to get Employees Hierarchy
Hi, My requirement is as follows: I would like to obtain Employee Wise Hierarchy (Bottom Employees to Top Employees) using SP. Note (Role): NH is Level-1(Top Level) VH is Level-2 AVP is Level-3 RM is Level-4 DRM is Level-5 BM is Level-6 TH is Level-7…
Access Azure Table Storage from Visual Studio with AzureDefaultCredential
I'm trying to access a table in Azure Table Storage using AzureDefaultCredential. In Visual Studio, I am logged in with my AAD account In Table Storage -> IAM -> Role Assignments, my user has Owner, Contributor, Storage Account Contributor, Storage…
Query on freshly inserted Table Entities on Azure storage do not return all entities
After inserting a 1000 table entities, the first read gives Less entities. I have a very simple program public static async Task RunTest(TableClient client) { List<TableEntity> tableEntities = new…
Unexpected network error in Azure Table Storage when autoscale kicks in for Stream Analytics
Scenario I'm using Azure Stream Analytics (ASA) streaming data from Azure Event Hub to Azure Table Storage. I've enabled autoscale rule in ASA. When autoscale kicks in, I notice that there would be a few network errors observed from Azure…
Copy Activity very slow for Azure data factory
Hi All, we are having issue where copy activity from Azure Table storage to data factory is taking over 50mins on daily basis. it used to take 15-20mins until a week back. What's the source of the slow copy activity? Azure Table storage What's the sink…
How to increase throughput in ADF copy activity From Table Storage to Table Storage
Hello, Short background - I'm using ADF for creation of Table storage Backups for specific Storage Accounts (each account is different pipeline with separate copy activities for each Table), creating new Table storages from old ones using copy…
Feeling Lost with Azure Table Service Properties! Can Anyone Help?
I've been struggling for hours to get the table service properties using Azure SDK, but I keep hitting a wall. I'm starting to feel really frustrated and defeated. I know I'm not alone in this — I just need some guidance to find my way out. Here's my…
PowerShell entity operations on Cosmos Tables
https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-how-to-use-powershell In the Tip at the top of the article it states that the programming language "PowerShell" is not yet supported for Cosmos tables but will be in the…
Identifying unused data in Azure table storage and deleting it
There are 100 TB of data in Azure table storage in a particular storage account, and I need to identify which is in use and which needs to be deleted. Could you perhaps offer a solution to accomplish this?
Not seeing Storage Account Table Create and Delete actions in Activity Log
Hi there, I'm working on a project at my company involving the Table storage resource within a Storage Account. I noticed that I'm not getting the Create/Update and Delete actions logs, of the Table storage I created, at the Activity Log (Monitor…
Remove table borders?
Is there really no way to remove table borders in a modern SharePoint page? That just can't be true . . . . . . can it?
How to get top n entities from azure table storage
I followed the long tail design pattern to sort the entities in descending order as shown in this 85245919390 Its mentioned that we could retrieve top n values using $top query operator 85245919390 Is $top query operator available in python…
How to delete old WADMetrics tables automatically from Tables storage account
WADMetrics.JPG I wanted to delete the Diagnostic logs(WADMetric) tables stored in the Azure table storage account. Please give me the suitable way to delete table automatically because we have hundreds of table entries. If I will processed from manual…
ADF Copy Data Activity converts NULL data value to string '' from Azure Table Storage to CRM
Hi, I am using the Copy data activity in ADF pipeline from Azure Table Storage as source to Dataverse CRM as sink. Some date fields in the source data have values, while others don't. Everything works well when the date fields have values, but I…
Add-AzTableRow throws error: The specified resource does not exist
Hello, I am trying to manage Azure Storage Tables using PowerShell. I have installed the latest version of the Az and AzTable modules to do so. For test purposes, I am currently only trying to add an entity in an existing table, following the…
Federated Identity credentials auth in azure table sdk
Hi I was trying to use FIC creds for table sdk but was getting the following issue: CredentialUnavailableError: ManagedIdentityCredential authentication unavailable, no response from the IMDS endpoint. This is the doc I am following for FIC…
event hub activity log
the action of creating or delete a table in storage account doesn't show log in activity log monitor, what can be the reason?
Add-AzTableRow throws error MethodInvocationException : The specified resource does not exist
Hello, I ran into this error when I try to add new row while using the ConnectedAccount context rather than a key based authentication. MethodInvocationException: Exception calling "Execute" with "1" argument(s): "The…
The best database in Azure to manage real time data operations.
Hello Experts, I have to manage some real time stock updates between more than 2 online portals and we are thinking to go with Azure Services. And also think to store data in Azure Database services. Hence, we are looking for the database that must be…