When generating a SAS token, specifying the path causes an authorization failure.
I use following code to generate SAS token, when path is null or empty string, it's working. String sasToken = new DataLakeSasImplUtil(signatureValues, container, path, true) .generateUserDelegationSas(userDelegationKey, accountName,…
How to Use System-Assigned Managed Identity for Secure Access to Blob Storage in Synapse Notebook?
Hello Community, I'm currently working on a project in Azure Synapse Analytics and would like to enhance the security of my data access. My Python code in the Synapse notebook currently accesses Blob Storage using a connection string, but I want to…
Workspace request validation failed
Can anyone solve this issue…
Invalid api-version exception when submitting job to Data Lake Analytics using Azure Python SDK
I got below exception when I tried to submit a job to Azure Data Lake Analytics using Azure Python SDK. CloudError: Azure Error: InvalidArgument Message: Job type 'USql' is not supported by api-version '2017-09-01-preview'. First I have installed the…
After using api to purge data from workspace the status stays on pending and logs are not removed.
After using api to purge data from workspace the status stays on pending and logs are not removed. While using the status endpoint the status keeps returning as 'pending'. The purge request is visible in activity logs of the workspace but just shows…
Why is the activity log stored in the adls gen2 container not a valid json
Why is the activity log stored in the adls gen2 container not a valid json? It's line by line, and the outer layer is missing '[]' and comma separation
How does Azure integrate with IoT devices for real-time data processing?
I’m interested in understanding how Azure integrates with IoT devices to enable real-time data processing. What services and tools does Azure offer to process, store, and analyze IoT data streams efficiently? Any examples of how businesses are using…
I got this error when debug my copy data on azure df 7cf2da46-b65b-4098-b8ec-d9c7858c190e
after connecting my Azure data factory to MsSqL, I tried to copy my data into azure data factory and I got this error 7cf2da46-b65b-4098-b8ec-d9c7858c190e
can we add multiple containers in Microsoft Fabric Data Lake house?
I want to add one more container in Microsoft fabric lake house, as per my knowledge we can add only one container but i am curious to know can we add multiple containers in Microsoft fabric lake house
How to optimize real-time Power BI dashboard through Azure
Hi, I have a Power BI dashboard that displays real-time API traffic data which is working well so far. The Concern is, as the data is stored in an SQL database and connected to BI directly and as database grows, the querying and display times are getting…
How to send the history of 3 months of files from one directory to another according to the date in its name
Hello, I'm having problems because I want to move the history of some files stored in a data lake according to the date in its name, but in the end what I manage to do is only move either one specific day or all of them. example: I have files October -…
hii want to run stored procedure in synapse but ima getting an error ,can anyone help me
query: USE gold_db GO CREATE OR ALTER PROC CreateSQLServerlessView_gold @ViewName nvarchar(100) AS BEGIN DECLARE @statement VARCHAR(MAX) SET @statement = N'CREATE OR ALTER VIEW '+@ViewName+' AS SELECT * FROM OPENROWSET(BULK…
Azure Data Lake Gen2 Disaster Recovery/Storage account failover Capabilities?
I am trying to wrap my brain around Azure Data Lake Gen 2 DR/Storage account failover capabilities and I feel as though I am getting conflicting information. On the Microsoft Documentation -…
remove chars from integer columns in databricks delta
Hi Expert, how to remove chars from column in databricks delta when datatype is not null col1 1 2 3 er ge e
Load files in appending in databricks
Hi Expert, I have 2 files in blob storage . file1.csv, file2.csv how will i load it in a view using appending order using *.csv extension using temp view file_list = dbutils.fs.ls("/mnt/mount/test/file")
jdfc url of blob storage
Hi , i wanted to push the files to blob storgate using portman ... how to connect using jdbc connection i tried below but unable to push it.. can i get jdbc file for…
Datalake account_partitioned table row count is verly low
We have azure datalake with builtin pool In that we have builtin account_Partitioned table which use to have similar no or rows as per non partitioned table but now from today only showing 10% of total rows We are in UK West region and something…
Correction on Microsoft PL-300 Practice Assessment Questions
This is to bring to the notice of the Admin in charge of Practice Test Questions under Pl-300 Power Bi Exam. There is a confusion in one of the questions and answers. Please find attached snap shot and correct the answers Thank you
Data lake zones and containers, what is the best practices of file name
Hi All, follow up Best practices from cloud Adoption framework, can somebody tell standers for file Name Data LakeLayersContainer numberContainer nameFile Name Standard1Raw1Landing?1Raw2Conformance?2Enriched1Standardized?2Curated2Data…
Can we pass partition key as a parameter in a generic/dynamic azure dataflow.
Operation on target Load Entity failed: Operation on target Load Entity failed: {"StatusCode":"DFExecutorUserError","Message":"Job failed due to reason: com.microsoft.dataflow.Issues: DF-TX-114 - Key partitioning does…