Skip to content
EntryLayer Operational data entry for Snowflake

Virtual Submissions

When a project is connected to a Snowflake source, rows can appear in EntryLayer before a local submission record exists for them. EntryLayer calls these rows virtual submissions.

Use this page when:

  • a source-connected project shows records that have not been edited yet
  • workflow-enabled projects show not_started
  • you need to explain why app audit history starts after materialization
  • a data governance team asks whether source rows are copied immediately
Customer source row
-> visible through Snowflake grants/policies
-> virtual submission in EntryLayer list
-> user action needs local workflow/edit state
-> materialized submission in Hybrid Tables
-> workflow history, field history, access history, audit state

Virtual submissions show up in normal project workflows:

  • in the project submission list
  • in project counts and overview surfaces
  • as openable records in the submission detail experience

In workflow-enabled source-connected projects, untouched virtual rows can appear with the status not_started.

That status means:

  • the row is visible from the Snowflake source
  • no local managed submission exists yet
  • local workflow tracking has not started yet
BehaviorVirtual submissionMaterialized submission
Source of recordCustomer Snowflake source objectEntryLayer app-managed submission state
App-managed audit trailNot full local history yetWorkflow, field, and access history are tracked
Source governanceSnowflake row access and masking policies applyApp project permissions and stored local state apply; source governance can still matter for source-backed context
Storage impactNo full local submission copy up frontStored in Hybrid Tables inside the installed app namespace
Typical statusnot_started for workflow-enabled untouched rowsNormal workflow states after local work begins

Materialization turns a virtual row into a managed EntryLayer submission.

When EntryLayer materializes a row, it:

  1. reads the source values needed for the action through the approved source access path
  2. creates the managed submission record
  3. applies the user’s local edit or workflow-triggering action
  4. begins tracking local audit history, workflow state, and managed field changes

After materialization, later edits work against the managed submission rather than an untouched virtual row.

Virtual submissions are governed by both Snowflake and EntryLayer boundaries:

BoundaryWhat to remember
Object grantsThe app cannot use source objects the customer has not granted.
Row access policiesUsers can see different virtual rows depending on Snowflake policy results.
Masking policiesSource values can remain masked according to the signed-in user’s Snowflake context.
Project permissionsA visible project shell does not automatically mean the user can read records.
Field groupsApp-managed field-group settings can still hide or lock fields in the EntryLayer UI.

If workflow is enabled:

  • virtual source rows can appear as not_started
  • once a row is materialized, the normal submission lifecycle begins
  • persisted workflow states follow the configured workflow model
  • publish and form-design changes affect user-visible behavior only after the draft is published