1,403 questions with Azure Data Lake Storage tags

Sort by: Updated
1 answer One of the answers was accepted by the question author.

How can I find help validating a certificate?

Indeed, I am a student in cloud computing in Morocco and I do not have enough means to obtain the AZ 900 certification and my family also does not have enough financial means. Could someone help me validate this certificate please?

Azure SQL Database
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,581 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,510 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
asked 2024-05-30T15:54:26.2366667+00:00
HAMIDOU YOUSSOUF 20 Reputation points
accepted 2024-05-31T14:55:42.77+00:00
HAMIDOU YOUSSOUF 20 Reputation points
0 answers

Possible bug or issue in Synapse dedicated SQL pool when exporting parquet files

I'm not sure if this is really a bug, but its definitly a frustration for me at least ;-). When trying to write data from Synapse dedicated SQL pools to data lake storage as parquet files (using a CETAS statement) it produces files with non-standard…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,581 questions
asked 2023-04-06T14:05:05.62+00:00
demolition porg 11 Reputation points
commented 2024-05-30T14:07:55.3666667+00:00
Martin B 21 Reputation points
1 answer

Delete the file from SharePoint location

Hi All, I am trying to copy the files from Share Point to ADLS and referring to the below URL pipeline to achieve the copy functionality. https://www.syntera.ch/blog/2022/10/10/copy-files-from-sharepoint-to-blob-storage-using-azure-data-factory/ I need…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,037 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
asked 2024-05-22T10:16:27.3866667+00:00
ADF_Coder 0 Reputation points
commented 2024-05-30T06:38:40.1+00:00
ADF_Coder 0 Reputation points
1 answer

How to sync Azure data lake storage with sharepoint drive?

We have copied files from sharepoint site multiple drives having nested folders in Azure data lake storage container maintaining same folder structure. Now I want to create a pipeline in Azure data factory to delete file from ADLS container which is not…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,088 questions
asked 2024-05-12T15:00:05.1166667+00:00
Rayne 20 Reputation points
commented 2024-05-30T05:58:53.8666667+00:00
Haoyan Xue_MSFT 21,491 Reputation points Microsoft Vendor
0 answers

Changing Synapse Notebook variable values during deployment in Azure DevOps

How can I change the variable values in a Synapse Notebook, such as storage account name, container name, and file location, during deployment from dev to prod in Azure DevOps? The notebook is already being used by other notebooks in my dev environment.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,845 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,564 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,581 questions
asked 2024-05-29T04:11:27.8566667+00:00
ADITYA SINGH 0 Reputation points
commented 2024-05-29T09:07:42.47+00:00
Harishga 5,270 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to use a user-delegation SAS token to load parquet table from ADLS gen2?

Now I have a parquet table stored in ADLS gen2: adlss://mycontainer@mystorage.dfs.core.windows.net/folder1/table1. This is a read-only table and I want to restrict my service principal to only have read access to this table only. So I use ACL to grant…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,845 questions
asked 2024-05-24T07:28:30.62+00:00
Shunlei Tang 40 Reputation points Microsoft Employee
commented 2024-05-28T12:55:46.9466667+00:00
Amrinder Singh 3,795 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Aritechture best practices to store data from websraping and use it in analytics

I am scrapping data from websites and I want to export what I scrapped as csv files then store them in Azure Data Lake, then apply an ETL and the final data output will be used for Power BI reports and for machine learning do I need to use Azure synapse?…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,673 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,581 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
asked 2024-05-28T08:27:28.46+00:00
WeirdMan 220 Reputation points
accepted 2024-05-28T08:35:56.1466667+00:00
WeirdMan 220 Reputation points
1 answer

How Can I read csv files which are in nested folders and copy them preserving the hierarchy?

I have csv.gz files which are partitioned this way /2024/01/01/xyz/x.csv /2024/01/01/yza/y.csv /2024/01/01/zab/z.csv and there are files for several years and i want to copy all those files using adf while maintaining the folder structure and hierarchy…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
asked 2024-05-24T16:33:37.1766667+00:00
Jay Remally 0 Reputation points
commented 2024-05-27T06:17:56.7533333+00:00
Harishga 5,270 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

VPN and networking config for secure upload to ADLS Gen2 storage account?

I'm looking into network architectures and security for implementing secure access from user laptops into Azure to upload files to ADLS Gen2 data lake blob containers. We have no on-prem network or AD - just individual user laptops. We do have MS Entra…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
asked 2024-05-09T14:59:36.4666667+00:00
Peter Daniels 20 Reputation points
accepted 2024-05-23T12:32:13.1733333+00:00
Peter Daniels 20 Reputation points
1 answer One of the answers was accepted by the question author.

How can i create a linked service in ADF for Sharepoint online?

I want to extract files from sharepoint to ADL by only using ADF. I followed few steps Step1: Azure Active Directory -> Registered new app -> created new secret key I have the Tenant ID, ClientID(App ID), Secret Key Step2: Sharepoint online ->…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,088 questions
asked 2024-04-27T21:58:38.2233333+00:00
Siddartha Reddy Jammula 20 Reputation points
commented 2024-05-22T05:08:28.6733333+00:00
Nehruji R 3,891 Reputation points Microsoft Vendor
0 answers

How can I get all files inside a drive irrespective of folder structure in ADF?

I want to copy files files from sharepoint drive which has lots of nested folders. Maximum hierarchy of folders is for 12 levels. Currently I'm using below endpoint in ADF's Web activity as it was mentioned in some of the articles that it provides every…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
asked 2024-05-14T00:43:50.9066667+00:00
Mansi Yadav 40 Reputation points
edited a comment 2024-05-20T09:47:49.2033333+00:00
phemanth 7,670 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Having problem with Azure sandbox storage account

Hi, I am having issue to access to storage account in Azure sandbox environment. I have login to Azure sandbox environment, but not able to access to Azure storage account even though my subscription is selected as sandbox. Capture.PNG

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
666 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,845 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,510 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,233 questions
asked 2024-05-11T05:36:05.7433333+00:00
Weiy 20 Reputation points
edited a comment 2024-05-18T13:41:51.58+00:00
Weiy 20 Reputation points
1 answer

Unable to copy share point files through ADF

I am facing issue now! I followed all the steps https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory and tried to read pdf files from sharepoint through ADF. source: Sharepoint(PDF files)(I selected…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,088 questions
asked 2024-05-11T12:02:41.84+00:00
Siddartha Reddy Jammula 20 Reputation points
commented 2024-05-17T08:37:19.2666667+00:00
Haoyan Xue_MSFT 21,491 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Special character handling for file processing

Hello, I have some CSV files as feeds into datalake storage, this file will contain data /records with some special characters eg '/' We need to process the file from one container to another and we will need to remove some of the these special…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,037 questions
asked 2024-05-15T02:02:23.0533333+00:00
Sourav 80 Reputation points
accepted 2024-05-16T07:24:24.5+00:00
Sourav 80 Reputation points
1 answer

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 -…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
Azure Data Lake Analytics
asked 2024-05-14T22:35:22.23+00:00
ALER 0 Reputation points
answered 2024-05-15T09:53:51.7833333+00:00
phemanth 7,670 Reputation points Microsoft Vendor
1 answer

How to mount dataset or datalake with read/write permission in Notebook of Azure Machine Learning Studio?

I've successfully mounted a dataset with read permission to notebook of my machine learning studio account. But when I try to write back to the datalake/dataset, it throughs "[Errno 30] Read-only file system". How can I mount the dataset with…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,673 questions
asked 2023-03-15T22:26:15.2333333+00:00
Milad Resketi 10 Reputation points
answered 2024-05-15T09:41:00.78+00:00
OPERTI Felipe 0 Reputation points
1 answer One of the answers was accepted by the question author.

Data Mesh architecture implementation on Azure data lake

Hi friends, Data mesh architecture is a decentralized approach that organizes data based on business domains (e.g., marketing, sales, HR), I have the following questions Is it required to build a separate data lake for each department? When data…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
asked 2024-05-07T09:29:55.1333333+00:00
Anshal 2,006 Reputation points
accepted 2024-05-13T13:59:26.5033333+00:00
Anshal 2,006 Reputation points
1 answer

Why Data asset is not supported when try to create a AutoML job?

Hi, I successuffly created a data asset (folder_URI type) with uploaded imges in an Azure Blob storage (registered storage source), but when I try to create a job in Azure AutoML the Data asset shows (not supported). Any idea what is the issue? Thanks

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,673 questions
asked 2023-01-12T23:11:21.94+00:00
Gonzalez Barba, Jorge 0 Reputation points
commented 2024-05-13T13:22:14.1466667+00:00
Brian Van Steen 20 Reputation points
2 answers

While fetching data from cosmos db conatiner and persisting the json file in ADLS Gen 2 through Synapse Pipeline, some objects in my json file are appearing as blank string causing data loss. This is happening in PROD only not in UAT and DEV.

Hi, The issue i am facing is with the Synapse Analytics Service - Pipeline. I have created a dataflow which is pulling data from cosmos db container in json format and storing that json file in ADLS Gen 2. When I check the json file in ADLS I see that…

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,581 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,510 questions
asked 2024-04-05T13:17:47.2733333+00:00
Vity Pandita 0 Reputation points
commented 2024-05-13T10:35:01.35+00:00
ShaikMaheer-MSFT 38,316 Reputation points Microsoft Employee
1 answer

Cannot read excel file which is in using adls using load_workbook of openpyxl in databricks

Cannot read excel file which is in using load_workbook of openpyxl but can read if copied to dbfs

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,403 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,564 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,037 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,962 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,675 questions
asked 2024-05-10T10:34:09.57+00:00
Alpha 20 Reputation points
commented 2024-05-13T10:00:28.6666667+00:00
phemanth 7,670 Reputation points Microsoft Vendor