MCP Tool Reference Medium Risk

create_or_alter_object

Create or alter a Snowflake object

Part of the Snowflake MCP server. Enforce policies on this tool with Intercept, the open-source MCP proxy.

snowflake-labs-mcp Write

WHEN AI AGENTS USE THIS TOOL

AI agents use create_or_alter_object to create or modify resources in Snowflake. Write operations carry medium risk because an autonomous agent could trigger bulk unintended modifications. Rate limits prevent a single agent session from making hundreds of changes in rapid succession. Argument validation ensures the agent passes expected values.

WHY ENFORCE A POLICY ON CREATE_OR_ALTER_OBJECT

Without a policy, an AI agent could call create_or_alter_object repeatedly, creating or modifying resources faster than any human could review. Intercept's rate limiting ensures write operations happen at a controlled pace, and argument validation catches malformed or unexpected inputs before they reach Snowflake.

RECOMMENDED POLICY

Write tools can modify data. A rate limit prevents runaway bulk operations from AI agents.

snowflake.yaml 
tools:
  create_or_alter_object:
    rules:
      - action: allow
        rate_limit:
          max: 30
          window: 60

See the full Snowflake policy for all 10 tools.

DETAILS

Tool Name

create_or_alter_object

Category

Write

MCP Server

Snowflake MCP Server

Risk Level

Medium

MORE SNOWFLAKE TOOLS

create_object Write
Create a new Snowflake object
describe_object Read
Describe the structure of a Snowflake object
list_objects Read
List Snowflake objects such as databases, schemas, tables
list_semantic_views Read
List and query Snowflake Semantic Views
query_cortex_search Read
Query a Cortex Search Service for semantic search
query_cortex_analyst Read
Query Cortex Analyst for natural language to SQL conversion
query_cortex_agent Read
Query a Cortex Agent Service for agentic orchestration
drop_object Destructive
Drop a Snowflake object

View all 10 tools →

SIMILAR WRITE TOOLS ON OTHER SERVERS

create_table Airtable
Create a new table with fields
update_table Airtable
Update a table's name or description
create_field Airtable
Add a new field to a table
update_field Airtable
Modify an existing field
create_record Airtable
Add a new record
update_record Airtable
Modify an existing record

RELATED READING

FREQUENTLY ASKED QUESTIONS

What does the create_or_alter_object tool do?

Create or alter a Snowflake object. It is categorised as a Write tool in the Snowflake MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on create_or_alter_object?

Add a rule in your Intercept YAML policy under the tools section for create_or_alter_object. You can allow, deny, rate-limit, or validate arguments. Then run Intercept as a proxy in front of the Snowflake MCP server.

What risk level is create_or_alter_object?

create_or_alter_object is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit create_or_alter_object?

Yes. Add a rate_limit block to the create_or_alter_object rule in your Intercept policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block create_or_alter_object completely?

Set action: deny in the Intercept policy for create_or_alter_object. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides create_or_alter_object?

create_or_alter_object is provided by the Snowflake MCP server (snowflake-labs-mcp). Intercept sits as a proxy in front of this server to enforce policies before tool calls reach the server.

ENFORCE POLICIES ON SNOWFLAKE

Open source. One binary. Zero dependencies.

VIEW ON GITHUB Full Snowflake policy →