> ## Documentation Index
> Fetch the complete documentation index at: https://nango-wari-migrated-bigcommerce-docs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake (JWT)

## Overview

<CardGroup cols={3}>
  <Card title="Pre-built tooling" icon="screwdriver-wrench" href="#pre-built-tooling" />

  <Card title="Pre-built integrations" icon="square-check" href="#pre-built-integrations" />

  <Card title="Access requirements" icon="triangle-exclamation" href="#access-requirements" />

  <Card title="Setup guide" icon="rocket" href="#setup-guide" />

  <Card title="Useful links" icon="circle-info" href="#useful-links" />

  <Card title="API gotchas" icon="biohazard" href="#api-gotchas" />
</CardGroup>

## Pre-built tooling

<AccordionGroup>
  <Accordion title="✅ Authorization">
    | Tools                         | Status |
    | ----------------------------- | ------ |
    | Pre-built authorization (JWT) | ✅      |
    | Pre-built authorization UI    | ✅      |
    | Custom authorization UI       | ✅      |
    | End-user authorization guide  | ✅      |
    | Expired credentials detection | ✅      |
  </Accordion>

  <Accordion title="✅ Read & write data">
    | Tools                                     | Status                         |
    | ----------------------------------------- | ------------------------------ |
    | Pre-built integrations                    | ✅                              |
    | API unification                           | ✅                              |
    | 2-way sync                                | ✅                              |
    | Webhooks from Nango on data modifications | ✅                              |
    | Real-time webhooks from 3rd-party API     | 🚫 (time to contribute: \<48h) |
    | Proxy requests                            | ✅                              |
  </Accordion>

  <Accordion title="✅ Observability & data quality">
    | Tools                   | Status |
    | ----------------------- | ------ |
    | HTTP request logging    | ✅      |
    | End-to-end type safety  | ✅      |
    | Data runtime validation | ✅      |
    | OpenTelemetry export    | ✅      |
    | Slack alerts on errors  | ✅      |
    | Integration status API  | ✅      |
  </Accordion>

  <Accordion title="✅ Customization">
    | Tools                              | Status                         |
    | ---------------------------------- | ------------------------------ |
    | Create or customize use-cases      | ✅                              |
    | Pre-configured pagination          | 🚫 (time to contribute: \<48h) |
    | Pre-configured rate-limit handling | 🚫 (time to contribute: \<48h) |
    | Per-customer configurations        | ✅                              |
  </Accordion>
</AccordionGroup>

### Others

| Function name          | Description                                                                   | Type                                           | Source code                                                                                                                        |
| ---------------------- | ----------------------------------------------------------------------------- | ---------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------- |
| `cancel-statement`     | Cancel a running Snowflake SQL statement.                                     | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/cancel-statement.ts)     |
| `execute-statement`    | Submit a SQL statement to Snowflake.                                          | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/execute-statement.ts)    |
| `get-statement-result` | Fetch a Snowflake SQL statement result partition.                             | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/get-statement-result.ts) |
| `get-statement-status` | Get Snowflake SQL statement execution status and inline results.              | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/get-statement-status.ts) |
| `list-columns`         | List columns in a Snowflake table with data types, nullability, and defaults. | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-columns.ts)         |
| `list-databases`       | List Snowflake databases.                                                     | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-databases.ts)       |
| `list-roles`           | List Snowflake roles with hierarchy and assignment counts.                    | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-roles.ts)           |
| `list-schemas`         | List schemas in a Snowflake database                                          | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-schemas.ts)         |
| `list-stages`          | List Snowflake stages in a database.                                          | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-stages.ts)          |
| `list-streams`         | List Snowflake streams (change data capture) in a database.                   | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-streams.ts)         |
| `list-tables`          | List tables in a Snowflake schema                                             | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-tables.ts)          |
| `list-tasks`           | List Snowflake tasks in a database                                            | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-tasks.ts)           |
| `list-users`           | List Snowflake users with login, email, role, and auth details.               | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-users.ts)           |
| `list-views`           | List views in a Snowflake schema.                                             | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-views.ts)           |
| `list-warehouses`      | List Snowflake warehouses with size, state, and resource usage.               | [Action](/guides/functions/action-functions)   | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/actions/list-warehouses.ts)      |
| `columns`              | Sync Snowflake column metadata across all tables in configured schemas.       | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/syncs/columns.ts)                |
| `databases`            | Sync Snowflake database metadata                                              | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/syncs/databases.ts)              |
| `query-results`        | Sync rows from a customer-configured SELECT query.                            | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/syncs/query-results.ts)          |
| `roles`                | Sync Snowflake role metadata and hierarchy.                                   | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/syncs/roles.ts)                  |
| `schemas`              | Sync Snowflake schema metadata                                                | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/syncs/schemas.ts)                |
| `tables`               | Sync Snowflake table metadata.                                                | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/syncs/tables.ts)                 |
| `users`                | Sync Snowflake user roster with login, auth, and role details                 | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/syncs/users.ts)                  |
| `views`                | Sync Snowflake view metadata.                                                 | [Sync](/guides/functions/syncs/sync-functions) | [🔗 Github](https://github.com/NangoHQ/integration-templates/blob/main/integrations/snowflake-jwt/syncs/views.ts)                  |

## Access requirements

| Pre-Requisites    | Status | Comment |
| ----------------- | ------ | ------- |
| Paid dev account  | ❓      |         |
| Paid test account | ❓      |         |
| Partnership       | ❓      |         |
| App review        | ❓      |         |
| Security audit    | ❓      |         |

## Setup guide

*No setup guide yet.*

<Tip>Need help getting started? Get help in the [community](https://nango.dev/slack).</Tip>

<Note>Contribute improvements to the setup guide by [editing this page](https://github.com/nangohq/nango/tree/master/docs/integrations/all/snowflake-jwt.mdx)</Note>

## Useful links

* [How to set up key pair authentication within your snowflake account](https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/authentication#label-sfrest-api-setup-authenticating-key-pair)
* [Key Pair Authentication docs](https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/authentication#using-key-pair-authentication)
* [Account Url configuration](https://docs.snowflake.com/en/user-guide/organizations-connect#label-connecting-via-url)
* [API Docs](https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/reference)

<Note>Contribute useful links by [editing this page](https://github.com/nangohq/nango/tree/master/docs/integrations/all/snowflake-jwt.mdx)</Note>

## API gotchas

*None yet, add yours!*

<Note>Contribute API gotchas by [editing this page](https://github.com/nangohq/nango/tree/master/docs/integrations/all/snowflake-jwt.mdx)</Note>

<Card title="Connect to Snowflake (JWT)" icon="link" href="/integrations/all/snowflake-jwt/connect" horizontal>
  Guide to connect to Snowflake (JWT) using Nango Connect.
</Card>