---

@Loki wrote:

We are using service principal to access data from raw files such as json, CSV .Car Games

I saw a video suggesting that it could be done via unity catalog as well.

Could someone comment on this please ?

---

That's great! Service principals are a secure and recommended way to authenticate and access resources in Azure. With service principals, you can provide access to raw files in Azure storage or any other data source that supports service principal authentication.

To access data from raw files such as JSON or CSV, you can follow these general steps:

Create a service principal: Generate a service principal in Azure Active Directory (AAD) or Azure Active Directory B2C, depending on your requirements.

Assign required permissions: Assign the necessary permissions to the service principal to access the storage account or data source containing the raw files. For Azure storage accounts, you can provide appropriate access permissions (e.g., read, write, or list).

Use authentication credentials: Obtain the necessary authentication credentials for the service principal, such as its client ID, client secret, or certificate.

Implement code or scripts: Use programming languages like Python, Java, or PowerShell to write code or scripts that utilize the service principal's credentials and the appropriate SDKs or APIs to access the raw file data.

Connect to the data source: Use the service principal's credentials to authenticate and establish a connection to the data source or Azure storage account.

Access the raw files: Once the connection is established, you can access the raw files using methods provided by the SDKs or APIs. For example, you can read JSON or CSV files, parse their contents, and perform required operations.