Capabilities #
| Capability | Support |
|---|---|
| Reads | Yes |
| Writes | No — read-only adapter |
| DDL (create / drop tables) | No |
| Metadata introspection | Yes |
For writes, see the Trino adapter and Writing. For metadata introspection, see Metadata.
@lakeql/adapter-fabric connects LakeQL to a Microsoft Fabric SQL endpoint. It implements the datasource contract over TDS, via the standalone fabric-client. It provides the T-SQL dialect and authenticates with Azure AD.
Install the adapter:
pnpm add @lakeql/adapter-fabricIf you scaffolded with create-app and selected Fabric, the adapter is already installed.
Register it in your config:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23import { defineConfig } from "@lakeql/config"
import { fabricAdapterDefinition } from "@lakeql/adapter-fabric"
export default defineConfig({
adapters: [fabricAdapterDefinition],
dataSources: {
reporting: {
adapter: "fabric",
connection: {
host: "your-endpoint.datawarehouse.fabric.microsoft.com",
port: 1433,
catalog: "my_warehouse",
auth: {
type: "oauth2",
tenantId: "...",
clientId: "...",
clientSecret: "...",
},
},
},
},
})
This section covers the connection and metadata. The full API reference closes the section. For how a read executes end to end, see data flow.