Skip to content
EntryLayer Operational data entry for Snowflake

Cortex & AI Boundary

EntryLayer uses Snowflake Cortex for supported AI-assisted work such as form generation and rule assistance. The goal is to help admins build EntryLayer projects faster without changing the customer data boundary.

Use this page when:

  • enabling Cortex-backed features during Native App setup
  • asking Cortex to administer EntryLayer through the SQL API
  • connecting an MCP-compatible client to EntryLayer’s Snowflake-managed MCP server
  • reviewing Marketplace/security posture for AI usage
  • writing prompts for form design or rule generation
SurfacePurposeData boundary
Project/form generationBuild an initial form layout from source metadata.Uses source metadata, not source row samples.
Rule generationPropose form rules from user instructions and field metadata.Uses caller prompt plus field titles/types.
SQL API skill workflowHelps Cortex discover safe commands and contracts.Uses HELP() and AGENT_MANIFEST() metadata.
Snowflake-managed MCP serverLets compatible clients invoke curated EntryLayer tools.Delegates to app-owned SQL API procedures.
Allowed contextDo not include
Source object names when needed for setupSource row values
Column names and data typesSubmission values
Field titles and field typesPII, PHI, secrets, credentials
User-provided layout instructionsPasswords, tokens, connection strings
Business rules written at a policy levelProvider-owned external API instructions

If a prompt needs an example, use synthetic values instead of copied customer data.

For Cortex-assisted SQL administration:

CALL ENTRYLAYER.API.HELP();
CALL ENTRYLAYER.API.HELP('CONTRACTS');
CALL ENTRYLAYER.API.HELP('SECURITY');
CALL ENTRYLAYER.API.AGENT_MANIFEST();

AGENT_MANIFEST() tells agents which commands are read-only, idempotent, draft-mutating, publish-sensitive, source-metadata-only, or Cortex-invoking.

The key AI-related SQL API rules are:

  • PREVIEW_SOURCE_LAYOUT is deterministic and does not invoke Cortex.
  • GENERATE_FORM_RULE invokes Cortex but returns a proposed rule; review before saving it.
  • Source discovery procedures are metadata-only.
  • Draft edits require PUBLISH_PROJECT_DRAFT before users see changes.
  • Submission mutation should be used only where explicitly documented.

EntryLayer’s current package uses Snowflake Cortex for supported AI features. It does not require a provider-owned external LLM endpoint, external access integration, API key, or network rule for normal AI-assisted product use.

The optional API.ENTRYLAYER_MCP server is Snowflake-managed. It does not create a custom SPCS MCP endpoint or provider-owned egress path. MCP tools invoke the same app-owned SQL API procedures that are documented for SQL clients.

The installed application needs the Snowflake Cortex database role setup described in the Native App installation flow. See Native App Security Model for the privilege summary.