Microsoft Fabric Lakehouse Table v2
Provides integration with Microsoft Fabric, an analytics platform combining workspaces, data engineering and Lakehouse storage.
Use the Node to load Lakehouse files into tables, list tables and inspect long-running operations.
Revision History
0.0.0.4 - Initial release.
Connection
| Property | Type | Description |
|---|---|---|
Tenant ID |
String | Microsoft Entra directory (tenant) identifier. |
Client ID |
String | Application (client) identifier from Microsoft Entra. |
Client Secret |
Masked | Application secret used for client-credentials authentication. |
Setup Notes
This Node runs on Cloud Runtimes.
Register a Microsoft Entra application and enter Tenant ID, Client ID and Client Secret. Grant the application access to the target Fabric workspace and permissions for its operations. Connection Test acquires a Fabric REST token. OneLake uploads request a separate Storage token when used.
Methods
Load Table
Starts the preview Microsoft Fabric Lakehouse Load Table operation.
| Parameter | Type | Description |
|---|---|---|
Connection |
Connection | Microsoft Fabric application Connection. |
Workspace ID |
String | Workspace GUID containing the Lakehouse. |
Lakehouse ID |
String | Lakehouse item GUID containing the target table. |
Table Name |
String | Target Delta table name accepted by Fabric. |
Relative Path |
String | Source path beginning with Files/ inside the Lakehouse. |
Path Type |
Enum | Whether Relative Path identifies one File or a Folder. |
Mode |
Enum | Whether Fabric appends to or overwrites the table. |
File Format |
Enum | CSV or Parquet source format. |
Recursive |
Boolean | Whether folder loading searches nested folders. |
CSV Delimiter |
String | Optional delimiter used only for CSV input; comma is the default. |
| Return | Type | Description |
|---|---|---|
Response |
Object | Accepted operation details and mutation metadata. Use Get Operation Status to inspect completion. |
List Tables
Lists tables from the preview Microsoft Fabric Lakehouse API.
| Parameter | Type | Description |
|---|---|---|
Connection |
Connection | Microsoft Fabric application Connection. |
Workspace ID |
String | Workspace GUID containing the Lakehouse. |
Lakehouse ID |
String | Lakehouse item GUID whose tables will be listed. |
| Return | Type | Description |
|---|---|---|
Response |
Array | Provider table rows without mutation metadata. |
Get Operation Status
Gets the current state of a Microsoft Fabric long-running operation.
| Parameter | Type | Description |
|---|---|---|
Connection |
Connection | Microsoft Fabric application Connection. |
Operation ID |
String | Operation GUID returned by a Fabric long-running operation. |
| Return | Type | Description |
|---|---|---|
Response |
Array | Provider long-running operation status without mutation metadata. |
Usage Notes
- Load Table returns after Fabric accepts the operation. Use Get Operation Status before depending on completed processing.
- Relative Path must begin with Files/ inside the selected Lakehouse. Select the correct File or Folder path type and CSV or Parquet format.
- Load Table returns
Flowgear.IsSuccess,Flowgear.StatusMessageandFlowgear.Request. Reads preserve provider rows without mutation metadata. - The Lakehouse Load and List APIs are Preview and their provider contracts may change.