SnowExporter

Exporting data from Snowflake to CSV is a common task for data professionals who need to work with Snowflake data in spreadsheets or other tools. What if you needed to do an export: - on a set schedule - saved in a remote location - with custom filename **What is SnowExporter?** As you know [Snowflake](https://snowflake.com) provides a robust solution for storing, managing, and analyzing large datasets in the cloud. But what if you needed to have the analyzed data exported out of Snowflake? <br/><br/>SnowExporter is a custom Snowflake app, that allows end-users to securely export data from Snowflake to external destinations by using the apps intuitive graphics interface. But it isn’t just a regular app. It is an Native app. Why should this matter to you and your company? **Why NativeApp?** Snowflake Native apps allow users to take advantage of innovative, powerful apps WITHOUT having to worry about whether their sensitive data is being adequately protected on their provider’s platform. This is because Snowflake Native Apps are applications that run **WITHIN** the customer’s own Snowflake account, so there is no need to move or share their data with the app provider, which can help improve data security and governance. Customers can also retain control over what the app can do in their accounts by granting granular permissions. **Why SnowExporter?** SnowExporter is a Snowflake Native App that turns any SELECT query into a delivered result. Pick a destination, set a schedule, hit go. Delivery destinations: - 📧 Email — render results in the message body or send a pre-signed download link - 💬 Slack — post results to a channel as a monospace table, with optional file attachment - 👥 Microsoft Teams — post results to a channel via Teams MessageCards, with a clickable Download button - ☁️ External cloud — write CSV or JSON files to AWS S3, GCP GCS, or Azure Blob Storage - ❄️ Internal Snowflake stage — for downstream pipelines or audit retention <p><br/></p> Scheduling that just works Cron-based schedules in your chosen IANA timezone - Minute, hourly, daily, weekly, and monthly presets - Pause / resume / delete with a click — schedules survive app upgrades 🤖 AI-assisted scheduling (new in v1.3) Type *"Email me the top 10 customers by revenue every Monday at 9 AM Eastern"* - Snowflake Cortex extracts the SQL query, the cron schedule, the timezone, the delivery channel, and the recipients — all in one shot - Review the suggestion in the wizard and click Schedule - Requires Cortex enabled on your account; degrades gracefully when not available<br/> Built for teams - Per-destination access policy — control which roles can use which destinations - Per-user role provisioning helper for the one-role-per-user pattern - Activity dashboard and full audit log on every delivery - Business contact + description fields on every destination so admins know who owns what Snowflake-native, your data stays in your account - Built on the Snowflake Native App framework — no data egress, no external services - Email via Snowflake's notification integration, Slack/Teams via webhook notification integrations - Cortex runs server-side in Snowflake — your data never leaves your account Pricing - 30-day Pro trial on first install — no credit card - Free plan after trial: up to 10 ad-hoc exports per month, 1 active schedule, 1 destination, email-body delivery only Pro: unlimited exports, schedules, destinations; all delivery modes including AI assist; full audit-log history <p><br/></p> <p><br/></p>

原始信息汇总

数据集概述：SnowExporter

SnowExporter 是一个 Snowflake Native App，旨在帮助用户将 Snowflake 中的查询结果安全、定时地导出到多种外部目标（如电子邮件、Slack、Microsoft Teams、云存储等）。

核心功能

• 导出目标：
  • 电子邮件：在邮件正文中呈现结果或发送预签名下载链接。
  • Slack：将结果作为等宽表格发布到频道，支持附件。
  • Microsoft Teams：通过 MessageCards 发布结果，支持可点击的下载按钮。
  • 外部云存储：将 CSV 或 JSON 文件写入 AWS S3、GCP GCS 或 Azure Blob Storage。
  • 内部 Snowflake Stage：供下游管道或审计保留使用。
• 调度功能：
  • 支持基于 Cron 的日程安排，可选择IANA时区。
  • 提供分钟级、小时级、日级、周级和月级的预设调度选项。
  • 支持暂停、恢复或删除调度，且调度在应用升级后仍然有效。
  • AI辅助调度（v1.3新增）：用户可通过自然语言描述（如“每周一早上9点发送邮件报告”），由 Snowflake Cortex 自动解析并生成 SQL 查询、Cron 表达式、时区、传递渠道和收件人。
• 团队支持：
  • 提供按目标的访问策略控制，限制特定角色可使用哪些目标。
  • 支持按用户角色配置，提供活动仪表板和完整的审计日志。
  • 每个目标可添加业务联系人和描述字段，便于管理员管理。

安全与合规

• 原生App架构：在客户自己的 Snowflake 账户内运行，无需将数据移出或共享给提供商，提升数据安全性和治理能力。
• 权限控制：客户可通过基于角色的访问控制（RBAC）授予细粒度权限。
• 安全审查：已通过 Snowflake 安全审查。

定价模式

• Free：初始安装提供30天Pro试用；试用后免费计划支持每月最多10次临时导出、1个活动调度、1个目标，仅限邮件正文传递。
• Pro：无限制的导出、调度、目标；支持所有传递模式（包括AI辅助）及完整审计日志历史。

适用场景

• 分析师：需要将日常/周报定时发送给利益相关者，无需手动运行查询。
• 运维团队：当KPI变化时，需要实时导出数据到聊天频道。
• 工程团队：需要按计划将文件放到云存储以供下游管道使用。
• 任何需要从 SQL → 电子表格 → 邮件流程中解放出来的用户。

其他信息

• 提供商：SnowExporter.com LLC（美国华盛顿州注册公司）。
• 联系方式：
  • 销售：[e-mail]
  • 支持：[e-mail]
• 类别：受众细分、数据工程。
• 交付方式：Native App。
• 法律条款：标准协议。