Lakehouse additional properties

Lakehouse item has the following additional properties:

  • oneLakeTablesPath - The OneLake path to the Lakehouse tables directory. It is of type string.

  • oneLakeFilesPath - The OneLake path to the Lakehouse files directory. It is of type string.

  • sqlEndpointProperties - An object containing the properties for SQL endpoint, described as follows:

    • id - SQL endpoint ID. It is of type string.
    • connectionString - SQL endpoint connection string. It is of type string.
    • provisioningStatus - The SQL endpoint provisioning status. It is an enum string type with the following possible values:
      • InProgress - SQL endpoint provisioning is in progress.
      • Success - SQL endpoint provisioning is successful.
      • Failed - SQL endpoint provisioning has failed.

Response example

{
    "displayName": "Lakehouse item 1",
    "description": "Lakehouse item 1 description",
    "type": "Lakehouse",
    "workspaceId": "f089354e-8366-4e18-aea3-4cb4a3a50b48",
    "id": "41ce06d1-d81b-4ea0-bc6d-2ce3dd2f8e87",
    "properties": {
        "oneLakeTablesPath": "https://onelake.dfs.fabric.microsoft.com/f089354e-8366-4e18-aea3-4cb4a3a50b48/41ce06d1-d81b-4ea0-bc6d-2ce3dd2f8e87/Tables",
        "oneLakeFilesPath": "https://onelake.dfs.fabric.microsoft.com/f089354e-8366-4e18-aea3-4cb4a3a50b48/41ce06d1-d81b-4ea0-bc6d-2ce3dd2f8e87/Files",
        "sqlEndpointProperties": {
            "id": "21ea7a9b-22ec-40b8-a74a-ae21fb14aceb",
            "connectionString": "tnld4ssiai7epb522phtz25h74-syng6oxxqade7nczhhpurlh75a.datawarehouse.pbidedicated.windows.net",
            "provisioningStatus": "Success"
        }
    }
}