Snowflake · SN Doc Reader

Snowflake

concept australia Updated Sep 10, 2026 1 min read snowflake-zcc.md

The Snowflake connector provides read-only access to data and metadata from an external Snowflake account.

A connection admin can set up a connection to Snowflake 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 Snowflake. This allows users to access Snowflake 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.

When you configure the connection with an access token, you can choose whether the connection authenticates using a shared, system-level OAuth entity profile or personal authentication.

Note: With personal authentication, each user's access to Snowflake data is authenticated and audited against their own credentials, not a shared account. This supports stricter access control and clearer audit trails.

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 Snowflake data types and the default matching data types in a data fabric table.

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

Snowflake	Data fabric table
int	Decimal
byteint	Decimal
char	String
character	String
varchar	String
varchar_default	String
string	String
text	String
date	Date
timestamp	Basic Date/Time
timestamp_tz	Date/Time
boolean	True/False
datetime	Date/Time
numeric	Decimal
integer	Decimal
bigint	Decimal
smallint	Decimal
tinyint	Decimal

Related topics

Create a Snowflake connection

68 lines · 2.7 KB Wrap lines

---
title: Snowflake
description: The Snowflake connector provides read-only access to data and metadata from an external Snowflake account.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/integrate-applications/snowflake-zcc.html
release: australia
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]
---

# Snowflake

The Snowflake connector provides read-only access to data and metadata from an external Snowflake account.

A connection admin can set up a connection to Snowflake 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 Snowflake. This allows users to access Snowflake 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/australia/markdown/australia/integrate-applications/managing-data-fabric-tables-zcc.md).

When you configure the connection with an access token, you can choose whether the connection authenticates using a shared, system-level OAuth entity profile or personal authentication.

**Note:** With personal authentication, each user's access to Snowflake data is authenticated and audited against their own credentials, not a shared account. This supports stricter access control and clearer audit trails.

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 Snowflake data types and the default matching data types in a data fabric table.

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

|Snowflake|Data fabric table|
|---------|-----------------|
|int|Decimal|
|byteint|Decimal|
|char|String|
|character|String|
|varchar|String|
|varchar\_default|String|
|string|String|
|text|String|
|date|Date|
|timestamp|Basic Date/Time|
|timestamp\_tz|Date/Time|
|boolean|True/False|
|datetime|Date/Time|
|numeric|Decimal|
|integer|Decimal|
|bigint|Decimal|
|smallint|Decimal|
|tinyint|Decimal|

**Related topics**  


[Create a Snowflake connection](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/create-snowflake-connection-zcc.md)