Snowflake (JWT)
Overview
Pre-built tooling
✅ Authorization
| Tools | Status |
|---|---|
| Pre-built authorization (JWT) | ✅ |
| Pre-built authorization UI | ✅ |
| Custom authorization UI | ✅ |
| End-user authorization guide | ✅ |
| Expired credentials detection | ✅ |
✅ Read & write data
| Tools | Status |
|---|---|
| Pre-built integrations | ✅ |
| API unification | ✅ |
| 2-way sync | ✅ |
| Webhooks from Tenklo on data modifications | ✅ |
| Real-time webhooks from 3rd-party API | 🚫 (time to contribute: <48h) |
| Proxy requests | ✅ |
✅ 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 | ✅ |
✅ 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 | ✅ |
Others
| Function name | Description | Type | Source code |
|---|---|---|---|
cancel-statement | Cancel a running Snowflake SQL statement. | Action | 🔗 Github |
execute-statement | Submit a SQL statement to Snowflake. | Action | 🔗 Github |
get-statement-result | Fetch a Snowflake SQL statement result partition. | Action | 🔗 Github |
get-statement-status | Get Snowflake SQL statement execution status and inline results. | Action | 🔗 Github |
list-columns | List columns in a Snowflake table with data types, nullability, and defaults. | Action | 🔗 Github |
list-databases | List Snowflake databases. | Action | 🔗 Github |
list-roles | List Snowflake roles with hierarchy and assignment counts. | Action | 🔗 Github |
list-schemas | List schemas in a Snowflake database | Action | 🔗 Github |
list-stages | List Snowflake stages in a database. | Action | 🔗 Github |
list-streams | List Snowflake streams (change data capture) in a database. | Action | 🔗 Github |
list-tables | List tables in a Snowflake schema | Action | 🔗 Github |
list-tasks | List Snowflake tasks in a database | Action | 🔗 Github |
list-users | List Snowflake users with login, email, role, and auth details. | Action | 🔗 Github |
list-views | List views in a Snowflake schema. | Action | 🔗 Github |
list-warehouses | List Snowflake warehouses with size, state, and resource usage. | Action | 🔗 Github |
columns | Sync Snowflake column metadata across all tables in configured schemas. | Sync | 🔗 Github |
databases | Sync Snowflake database metadata | Sync | 🔗 Github |
query-results | Sync rows from a customer-configured SELECT query. | Sync | 🔗 Github |
roles | Sync Snowflake role metadata and hierarchy. | Sync | 🔗 Github |
schemas | Sync Snowflake schema metadata | Sync | 🔗 Github |
tables | Sync Snowflake table metadata. | Sync | 🔗 Github |
users | Sync Snowflake user roster with login, auth, and role details | Sync | 🔗 Github |
views | Sync Snowflake view metadata. | Sync | 🔗 Github |
Access requirements
| Pre-Requisites | Status | Comment |
|---|---|---|
| Paid dev account | ❓ | |
| Paid test account | ❓ | |
| Partnership | ❓ | |
| App review | ❓ | |
| Security audit | ❓ |
Setup guide
No setup guide yet.
Need help getting started? Get help in the community.
Contribute improvements to the setup guide by editing this page
Useful links
- How to set up key pair authentication within your snowflake account
- Key Pair Authentication docs
- Account Url configuration
- API Docs
Contribute useful links by editing this page
API gotchas
None yet, add yours!
Contribute API gotchas by editing this page
Connect to Snowflake (JWT)
Guide to connect to Snowflake (JWT) using Tenklo Connect.