{"id":"snowflake-api","name":"Snowflake SQL API","homepage":"https://docs.snowflake.com/en/developer-guide/sql-api/reference","repo_url":"https://github.com/snowflakedb/snowflake-connector-python","category":"data","subcategories":["analytics","data-warehouse","sql","data-sharing"],"tags":["snowflake","data-warehouse","sql","rest-api","analytics","cloud-data","etl","data-sharing"],"what_it_does":"Snowflake's SQL API and Python connector for executing SQL queries against Snowflake's cloud data platform. Supports synchronous and asynchronous query execution, DDL/DML operations, result set streaming, and Snowpark for Python-native data processing. The SQL API is a REST interface for submitting SQL statements without a JDBC/ODBC driver.","use_cases":["Running analytical SQL queries against enterprise data warehouses from agents","Loading transformed data into Snowflake tables from agent ETL pipelines","Querying shared data from Snowflake Data Marketplace for external datasets","Executing stored procedures and Snowflake tasks from agent workflows","Using Snowpark for Python-native DataFrame operations inside Snowflake","Building agents that monitor data quality via SQL assertions on Snowflake tables"],"not_for":["Low-latency OLTP workloads (Snowflake is optimized for analytics, not row lookups)","Teams not on Snowflake — requires existing Snowflake account","Frequent small queries — Snowflake has per-second minimum query charges and warehouse startup costs","Real-time streaming (use Kafka + Snowpipe for streaming; SQL API is batch-oriented)"],"best_when":"An agent needs to query or manipulate data in an enterprise Snowflake data warehouse — analytics, reporting, ETL, or data quality checks.","avoid_when":"You need low-latency OLTP, high-frequency small queries, or don't already use Snowflake.","alternatives":["bigquery-api","clickhouse-api","singlestore-api"],"af_score":76.4,"security_score":null,"reliability_score":null,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":"current","last_evaluated":"2026-03-01T09:50:06.230106+00:00","performance":{"latency_p50_ms":500,"latency_p99_ms":10000,"uptime_sla_percent":99.9,"rate_limits":"SQL API: 10 concurrent statements per session, no global rate limit but warehouse concurrency limits apply. Connector: connection pooling supported. Result set streaming available for large results.","data_source":"llm_estimated","measured_on":null}}