GeezerVison

️✅ There are no secrets present in this pull request anymore.

If these secrets were true positive and are still valid, we highly recommend you to revoke them.
While these secrets were previously flagged, we no longer have a reference to the
specific commits where they were detected. Once a secret has been leaked into a git
repository, you should consider it compromised, even if it was deleted immediately.
Find here more information about risks.

^{_{🦉 GitGuardian detects secrets in your source code to help developers and security teams secure the modern development process. You are seeing this because you or someone else with access to this repository has authorized GitGuardian to scan your pull request.}}

The latest updates on your projects. Learn more about Vercel for GitHub.

Project	Deployment	Actions	Updated (UTC)
docs	Ready	Preview	Aug 8, 2026 11:28pm

@greptile

PR Summary

Medium Risk
New integration executes parameterized SQL and DML against customer Snowflake accounts using PAT credentials; mistakes or injection bugs could affect production data, though the change is additive and the PR describes extensive SQL/transport hardening and tests.

Overview
Adds a Snowflake integration authenticated with a programmatic access token (PAT), registered in the block registry, integration catalog, and docs navigation.

The new block exposes 21 operations across SQL execution (including async runs, statement polling/cancel, and partitioned results), structured row insert/update/upsert/delete, stage-based COPY loads, warehouse list/get/resume/suspend, task definition and run history, schema introspection, and stored procedure calls. Operation-specific sub-blocks cover bindings, match columns, COPY options, task history filters, and shared execution settings (role, warehouse, timeouts, row limits).

Docs include a generated snowflake.mdx reference for every action’s inputs/outputs. SnowflakeIcon is updated to Snowflake’s branded SVG in both docs and app icon sets, with snowflake mapped in icon registries.

^{Reviewed by Cursor Bugbot for commit 36b3aa3. Configure here.}

@cursor review

GitGuardian finding 35885962 was a false positive on the built-in JavaScript URL credential property, not a hardcoded secret. The host validator now uses an equivalent canonical-URL comparison, and the single commit was rewritten so the flagged token is absent from PR history.

@greptile

@cursor review

Greptile Summary

The PR adds a PAT-authenticated Snowflake integration with SQL execution, structured data operations, warehouse and task management, schema introspection, and stored-procedure support.

• Adds 21 Snowflake tools and a workflow block with generated registry, metadata, output, catalog, and documentation updates.
• Centralizes Snowflake SQL API response transformation, bounded payload handling, identifier validation, bindings, partition metadata, and DML statistics.
• Adds focused SQL-builder and transport tests, including asynchronous HTTP 202 statement-handle preservation.

Confidence Score: 5/5

The PR appears safe to merge.

No blocking failure remains.

sequenceDiagram
  participant Workflow
  participant Tool as Snowflake Tool
  participant Transport as Shared Tool Transport
  participant API as Snowflake SQL API
  Workflow->>Tool: Execute configured operation
  Tool->>Transport: Build bounded authenticated request
  Transport->>API: Submit SQL API request
  alt Completed response
    API-->>Transport: 2xx result
    Transport->>Tool: Transform response
    Tool-->>Workflow: Result partition and DML statistics
  else Asynchronous response
    API-->>Transport: HTTP 202 with statement handle
    Transport->>Tool: Transform pending response
    Tool-->>Workflow: RUNNING and statement handle
    Workflow->>Tool: Get Statement
    Tool->>API: Poll handle and partition
    API-->>Workflow: Completed result
  end

_{Reviews (9): Last reviewed commit: "fix(snowflake): emit task history time b..." | Re-trigger Greptile}

@greptile

@cursor review

@greptile

@cursor review

@greptile

Files Created / Modified: (All Standard)

apps/
├── docs/
│ ├── components/
│ │ └── ui/
│ │ └── icon-mapping.ts
│ └── content/
│ └── docs/
│ └── en/
│ └── integrations/
│ ├── meta.json
│ └── snowflake.mdx
│
└── sim/
├── blocks/
│ ├── blocks/
│ │ └── snowflake.ts
│ └── registry-maps.ts
│
├── lib/
│ └── integrations/
│ ├── icon-mapping.ts
│ └── integrations.json
│
└── tools/
├── generated/
│ ├── tool-ids.ts
│ ├── tool-metadata.ts
│ └── tool-outputs.ts
│
├── snowflake/
│ ├── index.ts
│ ├── types.ts
│ ├── utils.ts
│ ├── utils.test.ts
│ ├── sql.ts
│ ├── sql.test.ts
│ ├── execute_sql.ts
│ ├── get_statement.ts
│ ├── cancel_statement.ts
│ ├── insert_rows.ts
│ ├── update_rows.ts
│ ├── upsert_rows.ts
│ ├── delete_rows.ts
│ ├── load_data.ts
│ ├── list_warehouses.ts
│ ├── get_warehouse.ts
│ ├── resume_warehouse.ts
│ ├── suspend_warehouse.ts
│ ├── list_tasks.ts
│ ├── get_task.ts
│ ├── run_task.ts
│ ├── list_task_runs.ts
│ ├── get_task_run.ts
│ ├── cancel_task_run.ts
│ ├── get_task_run_output.ts
│ ├── introspect_schema.ts
│ └── call_procedure.ts
│
└── registry.ts

@cursor review

Snowflake integration diff against staging

38 files changed: 29 created, 9 modified, 0 deleted

[A] Created
[M] Modified

apps/
├── docs/
│ ├── components/ui/
│ │ └── icon-mapping.ts [M]
│ └── content/docs/en/integrations/
│ ├── meta.json [M]
│ └── snowflake.mdx [A]
└── sim/
├── blocks/
│ ├── blocks/
│ │ └── snowflake.ts [A]
│ └── registry-maps.ts [M]
├── lib/integrations/
│ ├── icon-mapping.ts [M]
│ └── integrations.json [M]
└── tools/
├── generated/
│ ├── tool-ids.ts [M]
│ ├── tool-metadata.ts [M]
│ └── tool-outputs.ts [M]
├── snowflake/
│ ├── call_procedure.ts [A]
│ ├── cancel_statement.ts [A]
│ ├── cancel_task_run.ts [A]
│ ├── delete_rows.ts [A]
│ ├── execute_sql.ts [A]
│ ├── get_statement.ts [A]
│ ├── get_task.ts [A]
│ ├── get_task_run.ts [A]
│ ├── get_task_run_output.ts [A]
│ ├── get_warehouse.ts [A]
│ ├── index.ts [A]
│ ├── insert_rows.ts [A]
│ ├── introspect_schema.ts [A]
│ ├── list_task_runs.ts [A]
│ ├── list_tasks.ts [A]
│ ├── list_warehouses.ts [A]
│ ├── load_data.ts [A]
│ ├── resume_warehouse.ts [A]
│ ├── run_task.ts [A]
│ ├── sql.test.ts [A]
│ ├── sql.ts [A]
│ ├── suspend_warehouse.ts [A]
│ ├── types.ts [A]
│ ├── update_rows.ts [A]
│ ├── upsert_rows.ts [A]
│ ├── utils.test.ts [A]
│ └── utils.ts [A]
└── registry.ts [M]

@greptile

@cursor review

@greptile

@cursor review

@greptile

@cursor review