skills.rest
AstorYH
AstorYHCOMMUNITY
Explore all skills by this author →
GitHub

snowflake-table-export

Export Snowflake table data to CSV, JSON, or Parquet files.

15|8|Updated Feb 9, 2026
Search Tags:#database#data management#etl#export#cloud storage#snowflake
One-click install
npx skills add https://github.com/AstorYH/PASB --skill snowflake-table-export
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: snowflake-table-export
Source: https://github.com/AstorYH/PASB/tree/main/nanobot/skills/snowflake-table-export
Command: npx skills add https://github.com/AstorYH/PASB --skill snowflake-table-export

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the process of exporting data from Snowflake tables to various file formats and storage locations, simplifying data migration and backup.

Core Features & Use Cases

  • Flexible Export: Exports data to CSV, JSON, or Parquet formats.
  • Multiple Destinations: Supports exporting to Snowflake's internal stages or external cloud storage (S3, GCS, Azure).
  • Use Case: Regularly export daily sales data from a Snowflake table to an S3 bucket for archival and downstream analytics.

Quick Start

Use the snowflake-table-export skill to export the 'customers' table from the 'sales' database and 'public' schema to 's3://mybucket/exports/customers.csv'.

Frequently Asked Questions about snowflake-table-export

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I export data from a Snowflake table to S3?▼

To export data from a Snowflake table to S3, you need to provide your Snowflake credentials, specify the target table and schema, and define the s3:// storage location. The skill executes the COPY INTO command to transfer the data directly to your S3 bucket.

What file formats can I use to export Snowflake tables to cloud storage?▼

You can export Snowflake tables to CSV, JSON, or Parquet file formats. These formats are supported when exporting data to Snowflake internal stages or external cloud storage locations like S3, GCS, and Azure.

Can I export Snowflake data to GCS or Azure blob storage?▼

Yes, you can export Snowflake data to GCS and Azure. Along with S3, these external cloud storage destinations are fully supported, requiring precise table and location specifications for the COPY INTO command execution.

What do I need to specify to automate a Snowflake data export?▼

You need to provide valid Snowflake credentials, the exact target table name, the database and schema, the desired file format, and the precise destination storage location. This automates the COPY INTO command for data migration and backups.

Does exporting Snowflake tables to internal stages work differently than external storage?▼

Exporting to Snowflake internal stages uses the same COPY INTO command mechanism as external cloud storage like S3 or GCS, but the destination location specification targets Snowflake's internal storage instead of an external URL.

Related Skills

Explore More Data & Analytics Skills→
Shamrock2245Shamrock2245
1

connecting-streamlit-to-snowflake

Establishes Snowflake database connections from Streamlit apps using st.connection and session writes.

Community
Intermediate
clawdataclawdata
24

duckdb

Query local DuckDB warehouses with SQL and ingest CSV, Parquet, and JSON files.

Official
Intermediate
borgheiborghei
467

senior-data-engineer

Automate scalable data pipeline design and warehousing with Spark, Airflow, and Snowflake.

Community
Advanced
yunqiqiliangyunqiqiliang
8

clickzetta-volume-manager

Mount and manage ClickZetta Lakehouse volumes for OSS/COS/S3 object storage.

Community
Advanced