# How to Set up an Azure One Lake Database for Integrating with Daton

## Prerequisites

To integrate One Lake, you need a Microsoft Fabric and Daton account.

## Authentication Steps

### Task 1: Register an Application

1. Log in to the [Azure portal](https://portal.azure.com/).
2. In the search bar, look for **App registrations**

   <figure><img src="https://t3369097.p.clickup-attachments.com/t3369097/d888b2a1-e71b-433e-90af-0f284bcf880e/image.png" alt=""><figcaption></figcaption></figure>
3. Go to **App registrations** and click **New registration**.

   <figure><img src="https://t3369097.p.clickup-attachments.com/t3369097/48ee2715-7660-4d6e-a011-80b30cc6d3eb/image.png" alt=""><figcaption></figcaption></figure>
4. Enter the following specifications for your application in the **Register an application** section and click **Register**.

   1. Name
   2. Select **Accounts in this organizational directory only** under **Supported account types**

   <figure><img src="/files/V9mzUsnWVjzKBYL6be63" alt=""><figcaption></figcaption></figure>
5. Make a note of the **Application (client) ID** and **Directory (tenant) ID** that will appear once your application is registered. You will need them to configure Azure One Lake on Daton.

   <figure><img src="https://t3369097.p.clickup-attachments.com/t3369097/f81ef610-4516-4f39-99b6-66e5d0891a24/Screenshot%202023-11-08%20at%205.40.15%E2%80%AFPM.png" alt=""><figcaption></figcaption></figure>

### Task 2: Create your Client Secret

1. Select the application you registered in the above Task.
2. On the navigation menu, click **Certificates & secrets** and then click **New Client Secret.**

   <figure><img src="https://t3369097.p.clickup-attachments.com/t3369097/4195955a-9814-4043-a530-a54cb498f893/Screenshot%202023-11-10%20at%2012.03.14%E2%80%AFAM.png" alt=""><figcaption></figcaption></figure>
3. In the Add a client secret pane, enter a **Description** for the client secret, set the expiry time to 730 days, and click **Add**.

   <figure><img src="https://fivetran.com/static-assets-docs/_next/static/media/secret-description.24cd5adf.png" alt=""><figcaption></figcaption></figure>
4. Copy the client secret that you just created. You will need it while integrating your db into Daton.

   <figure><img src="https://t3369097.p.clickup-attachments.com/t3369097/d3a1b129-a5ed-484a-99e7-3c7ddff9ca29/Screenshot%202023-11-10%20at%2012.08.54%E2%80%AFAM.png" alt=""><figcaption></figcaption></figure>

### Task 3: Create workspace

1. Log in to your [Microsoft Fabric account](https://app.fabric.microsoft.com/home).
2. Click **Synapse Data Engineering**.

   <figure><img src="/files/icVdlEMq4CxnePEanNLt" alt=""><figcaption></figcaption></figure>
3. Navigate through **Workspaces** and then click **New Workspace**.

   <figure><img src="/files/DEHj1pJCkmF0PNlsmZdy" alt="" width="375"><figcaption></figcaption></figure>
4. Enter a **Name** for your workspace and click **Apply**.

   <figure><img src="/files/iq1EfIf1OoXGnPisYbDf" alt="" width="375"><figcaption></figcaption></figure>

### Task 4: Add service principal to the workspace

1. Select the workspace you created in [Task 3](#task-3-create-workspace) and then click **Manage Access**.

   <figure><img src="/files/MSRo56yxoW1LWTaItaln" alt="" width="563"><figcaption></figcaption></figure>
2. Click **Add people or groups** and specify the name of the service principal you created in [Task 1](#task-1-register-an-application).

<figure><img src="/files/NlumG2xNwDcM3QrmXmQb" alt="" width="375"><figcaption></figcaption></figure>

3. In the drop-down menu, select **Contributor** and click **Add**.

### Task 5: Create Lakehouse

1. On the navigation menu, click **Create**.
2. In the Data Engineering section, locate and click **Lakehouse**.

   <figure><img src="/files/VHta82IZOyC873lb87nV" alt=""><figcaption></figcaption></figure>
3. Provide a unique name for your lakehouse and click **Create** to initiate the creation process.

   <figure><img src="/files/iENgfdRH7iXue3bpzoJz" alt="" width="375"><figcaption></figcaption></figure>

Following these steps will set up your Lakehouse in Azure One Lake, allowing you to manage and integrate your data effectively in Daton.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/destinations/azure-one-lake/how-to-set-up-an-azure-one-lake-database-for-integrating-with-daton.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
