Snowflake Data Engineering
Unified workflow for building and managing data pipelines using SQL execution, tasks, streams, pipes, stages, and functions. Used by Data Engineers to orchestrate ETL/ELT workflows and continuous data ingestion.
What You Can Do
MCP Tools
submit-sql
Submit a SQL statement for execution
get-statement-status
Get status of a submitted statement
cancel-statement
Cancel a running statement
list-tasks
List scheduled tasks
create-task
Create a scheduled task
execute-task
Execute a task immediately
resume-task
Resume a suspended task
suspend-task
Suspend a running task
list-streams
List change data capture streams
create-stream
Create a CDC stream
list-pipes
List data ingestion pipes
create-pipe
Create a pipe for continuous ingestion
refresh-pipe
Refresh a pipe
list-stages
List data loading stages
create-stage
Create a stage
list-stage-files
List files in a stage
list-functions
List functions
create-function
Create a function
execute-function
Execute a function
list-procedures
List stored procedures
create-procedure
Create a stored procedure
call-procedure
Call a stored procedure
list-udfs
List user defined functions
get-query-result
Get a query result