Tables - List Tables
참고
This API is in preview.
Returns a list of lakehouse Tables.
This API supports pagination. A maximum of 100 records can be returned per request. With the URI provided in the response, you can get the next page of records.
Lakehouse.Read.All or Lakehouse.ReadWrite.All
This API supports the Microsoft identities listed in this section.
| Identity | Support |
|---|---|
| User | Yes |
| Service principal and Managed identities | Yes |
GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/lakehouses/{lakehouseId}/tablesGET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/lakehouses/{lakehouseId}/tables?maxResults={maxResults}&continuationToken={continuationToken}| Name | In | Required | Type | Description |
|---|---|---|---|---|
|
lakehouse
|
path | True |
string (uuid) |
The lakehouse ID. |
|
workspace
|
path | True |
string (uuid) |
The workspace ID. |
|
continuation
|
query |
string |
Token to retrieve the next page of results, if available. |
|
|
max
|
query |
integer (int32) minimum: 1maximum: 100 |
The maximum number of results per page to return. |
| Name | Type | Description |
|---|---|---|
| 200 OK |
Request completed successfully. |
|
| Other Status Codes |
Common error codes:
|
Sample request
GET https://api.fabric.microsoft.com/v1/workspaces/f089354e-8366-4e18-aea3-4cb4a3a50b48/lakehouses/41ce06d1-d81b-4ea0-bc6d-2ce3dd2f8e87/tables?maxResults=10&continuationToken=
Sample response
{
"continuationToken": "+RID:~HTsuAOseYicH-GcAAAAAAA==#RT:1#TRC:1#ISV:2#IEO:65567#QCF:8#FPC:AgKfAZ8BnwEEAAe8eoA=",
"continuationUri": "https://api.fabric.microsoft.com/v1/workspaces/f089354e-8366-4e18-aea3-4cb4a3a50b48/lakehouses/41ce06d1-d81b-4ea0-bc6d-2ce3dd2f8e87/tables?continuationToken=%2BRID%3A~HTsuAOseYicH-GcAAAAAAA%3D%3D%23RT%3A1%23TRC%3A1%23ISV%3A2%23IEO%3A65567%23QCF%3A8%23FPC%3AAgKfAZ8BnwEEAAe8eoA%3D",
"data": [
{
"type": "Managed",
"name": "Table1",
"location": "abfss://f089354e-8366-4e18-aea3-4cb4a3a50b48@onelake.dfs.fabric.microsoft.com/41ce06d1-d81b-4ea0-bc6d-2ce3dd2f8e87/Tables/Table1",
"format": "Delta"
}
]
}| Name | Description |
|---|---|
|
Error |
The error related resource details object. |
|
Error |
The error response. |
|
Error |
The error response details. |
| Table |
Table information. |
| Tables |
A paginated list of tables. |
|
Table |
The table type. Additional |
The error related resource details object.
| Name | Type | Description |
|---|---|---|
| resourceId |
string |
The resource ID that's involved in the error. |
| resourceType |
string |
The type of the resource that's involved in the error. |
The error response.
| Name | Type | Description |
|---|---|---|
| errorCode |
string |
A specific identifier that provides information about an error condition, allowing for standardized communication between our service and its users. |
| message |
string |
A human readable representation of the error. |
| moreDetails |
List of additional error details. |
|
| relatedResource |
The error related resource details. |
|
| requestId |
string |
ID of the request associated with the error. |
The error response details.
| Name | Type | Description |
|---|---|---|
| errorCode |
string |
A specific identifier that provides information about an error condition, allowing for standardized communication between our service and its users. |
| message |
string |
A human readable representation of the error. |
| relatedResource |
The error related resource details. |
Table information.
| Name | Type | Description |
|---|---|---|
| format |
string |
Table format. |
| location |
string |
Table location. |
| name |
string |
Table name. |
| type |
Table type. |
A paginated list of tables.
| Name | Type | Description |
|---|---|---|
| continuationToken |
string |
Token to get the next page of results. |
| continuationUri |
string |
The URI of the next chunk in the result set. |
| data |
Table[] |
List of tables. |
The table type. Additional TableType types may be added over time.
| Value | Description |
|---|---|
| External |
External table. |
| Managed |
Managed table. |