Microsoft OneLake

concept brazil Updated Sep 10, 2026 1 min read microsoft-onelake-zcc.md

The Microsoft OneLake connector provides read-only access to data and metadata in Microsoft OneLake.

A connection admin can set up a connection to Microsoft OneLake in the Zero Copy Connector Hub and grant data stewards access to this connection. Data stewards can then use the established connection to create a data fabric table and map data from Microsoft OneLake. This allows users to access Microsoft OneLake data through the table list view or by using GlideRecord scripts. For details on creating data fabric tables and mapping data, see Managing data fabric tables.

Important: The Microsoft OneLake primary connector is in preview. A primary connector in preview is developed and supported by ServiceNow, but is still being enhanced to include all planned functionality. While in preview, a connector may have limitations in platform support or available features.

A primary connector in preview is fully functional for its documented scope and receives the same ServiceNow support as other primary connectors. For details on specific functionality limitations, see Workflow Data Fabric - Primary Connectors Limitations [KBB0010487].

The connector has been enhanced to improve the performance of the following Glide queries and list view operations. These improvements allow the majority of queries to be executed at the data source.

Sort
Limit
Filter
GroupBy
avg()
count()
max()
min()
sum()
References

Supported data types

The following table lists supported Microsoft OneLake data types and the default matching data types in a data fabric table.

Important: Microsoft OneLake data types not included in the table aren't supported for data mapping in Zero Copy Connector Hub.

Microsoft OneLake	Data fabric table
boolean	True/False
int	Integer
long	Long
float	Floating Point Number
double	Decimal
decimal(p,s)	Decimal/Currency
string	String
date	Date
timestamp	Date/Time
timestamptz	Date/Time
uuid	GUID

Related topics

Create a Microsoft OneLake connection

61 lines · 2.9 KB Wrap lines

---
title: Microsoft OneLake
description: The Microsoft OneLake connector provides read-only access to data and metadata in Microsoft OneLake.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/integrate-applications/microsoft-onelake-zcc.html
release: brazil
topic_type: concept
last_updated: "2026-09-10"
reading_time_minutes: 1
breadcrumb: [Primary connectors, Manage zero copy connections, Zero Copy Connectors, Workflow Data Fabric]
---

# Microsoft OneLake

The Microsoft OneLake connector provides read-only access to data and metadata in Microsoft OneLake.

A connection admin can set up a connection to Microsoft OneLake in the Zero Copy Connector Hub and grant data stewards access to this connection. Data stewards can then use the established connection to create a data fabric table and map data from Microsoft OneLake. This allows users to access Microsoft OneLake data through the table list view or by using GlideRecord scripts. For details on creating data fabric tables and mapping data, see [Managing data fabric tables](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/integrate-applications/managing-data-fabric-tables-zcc.md).

**Important:** The Microsoft OneLake primary connector is in preview. A primary connector in preview is developed and supported by ServiceNow, but is still being enhanced to include all planned functionality. While in preview, a connector may have limitations in platform support or available features.

A primary connector in preview is fully functional for its documented scope and receives the same ServiceNow support as other primary connectors. For details on specific functionality limitations, see [Workflow Data Fabric - Primary Connectors Limitations \[KBB0010487\]](https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KBB0010487).

The connector has been enhanced to improve the performance of the following Glide queries and list view operations. These improvements allow the majority of queries to be executed at the data source.

-   Sort
-   Limit
-   Filter
-   GroupBy
-   avg\(\)
-   count\(\)
-   max\(\)
-   min\(\)
-   sum\(\)
-   References

## Supported data types

The following table lists supported Microsoft OneLake data types and the default matching data types in a data fabric table.

**Important:** Microsoft OneLake data types not included in the table aren't supported for data mapping in Zero Copy Connector Hub.

|Microsoft OneLake|Data fabric table|
|-----------------|-----------------|
|boolean|True/False|
|int|Integer|
|long|Long|
|float|Floating Point Number|
|double|Decimal|
|decimal\(p,s\)|Decimal/Currency|
|string|String|
|date|Date|
|timestamp|Date/Time|
|timestamptz|Date/Time|
|uuid|GUID|

**Related topics**  


[Create a Microsoft OneLake connection](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/integrate-applications/create-microsoft-onelake-connection.md)