← Back 🏠 Categories

App: app_mWnh8j

Fetched from /v1/connect/apps/app_mWnh8j  ·  Slug: snowflake

id app_mWnh8j
name_slug snowflake
name Snowflake
auth_type keys
description A data warehouse built for the cloud
img_src https://assets.pipedream.net/s.v0/app_mWnh8j/logo/orig
custom_fields_json [{"name":"account","label":"Account","description":"Retrieve the current account name in Snowflake with this query: `SELECT CURRENT_ACCOUNT_NAME();`\nThis query outputs the [Snowflake account identifier](https://docs.snowflake.com/en/user-guide/admin-account-identifier.html). You may need to include the full identifier and region as a part of this string, e.g. `au12345.us-east-1`.","default":null,"optional":null,"enable_extract":null},{"name":"username","label":"Username","description":null,"default":null,"optional":null,"enable_extract":null},{"name":"database","label":"Database","description":null,"default":null,"optional":false,"enable_extract":null},{"name":"schema","label":"Schema","description":null,"default":null,"optional":false,"enable_extract":null},{"name":"use_pd_sql_proxy","label":"Use a shared static IP","description":"Enable requests from this database connection to originate from a shared static IP that you can add to your database allow-list.\n\n**Add this IP block to your database allow-list: `44.223.89.56/29`**","default":"true","optional":null,"type":"boolean"},{"name":"warehouse","label":"Warehouse","description":null,"default":null,"optional":true,"enable_extract":null},{"name":"role","label":"Role","description":null,"default":null,"optional":true,"enable_extract":null},{"name":"password","label":"Password","description":"Make sure to provide either a Private Key or a Password","default":null,"optional":true,"type":"password"},{"name":"private_key","label":"Private Key","description":"Make sure to provide either a Private Key or a Password","default":null,"optional":true,"enable_extract":true},{"name":"private_key_pass","label":"Private Key Passcode","description":"Specifies the passcode to decrypt the private key file, if the file is encrypted","default":null,"optional":true,"type":"password"}]
categories
[
  "Databases"
]
featured_weight 100000013
connect
{
  "allowed_domains": null,
  "base_proxy_target_url": null,
  "proxy_enabled": false
}
Show raw API payload
{
  "data": {
    "id": "app_mWnh8j",
    "name_slug": "snowflake",
    "name": "Snowflake",
    "auth_type": "keys",
    "description": "A data warehouse built for the cloud",
    "img_src": "https://assets.pipedream.net/s.v0/app_mWnh8j/logo/orig",
    "custom_fields_json": "[{\"name\":\"account\",\"label\":\"Account\",\"description\":\"Retrieve the current account name in Snowflake with this query: `SELECT CURRENT_ACCOUNT_NAME();`\\nThis query outputs the [Snowflake account identifier](https://docs.snowflake.com/en/user-guide/admin-account-identifier.html). You may need to include the full identifier and region as a part of this string, e.g. `au12345.us-east-1`.\",\"default\":null,\"optional\":null,\"enable_extract\":null},{\"name\":\"username\",\"label\":\"Username\",\"description\":null,\"default\":null,\"optional\":null,\"enable_extract\":null},{\"name\":\"database\",\"label\":\"Database\",\"description\":null,\"default\":null,\"optional\":false,\"enable_extract\":null},{\"name\":\"schema\",\"label\":\"Schema\",\"description\":null,\"default\":null,\"optional\":false,\"enable_extract\":null},{\"name\":\"use_pd_sql_proxy\",\"label\":\"Use a shared static IP\",\"description\":\"Enable requests from this database connection to originate from a shared static IP that you can add to your database allow-list.\\n\\n**Add this IP block to your database allow-list: `44.223.89.56/29`**\",\"default\":\"true\",\"optional\":null,\"type\":\"boolean\"},{\"name\":\"warehouse\",\"label\":\"Warehouse\",\"description\":null,\"default\":null,\"optional\":true,\"enable_extract\":null},{\"name\":\"role\",\"label\":\"Role\",\"description\":null,\"default\":null,\"optional\":true,\"enable_extract\":null},{\"name\":\"password\",\"label\":\"Password\",\"description\":\"Make sure to provide either a Private Key or a Password\",\"default\":null,\"optional\":true,\"type\":\"password\"},{\"name\":\"private_key\",\"label\":\"Private Key\",\"description\":\"Make sure to provide either a Private Key or a Password\",\"default\":null,\"optional\":true,\"enable_extract\":true},{\"name\":\"private_key_pass\",\"label\":\"Private Key Passcode\",\"description\":\"Specifies the passcode to decrypt the private key file, if the file is encrypted\",\"default\":null,\"optional\":true,\"type\":\"password\"}]",
    "categories": [
      "Databases"
    ],
    "featured_weight": 100000013,
    "connect": {
      "allowed_domains": null,
      "base_proxy_target_url": null,
      "proxy_enabled": false
    }
  }
}

Tip: Connect tokens are single-use and expire quickly; click “Connect” to generate a fresh one.