AEP Snowflake Batch Destination — Table Structure and Deprecation Documentation

Official Adobe Experience League documentation for the Snowflake Batch connection destination in Adobe Experience Platform. Page last updated May 28, 2026.

New Table Structure (Post-March 2026)

The updated format uses one row per audience membership per profile, with dedicated columns per attribute:

• TS: Row update timestamp
• MERGE_POLICY_ID: Associated merge policy identifier
• AUDIENCE_ID / AUDIENCE_NAME: Audience identifiers
• AUDIENCE_ORIGIN: Source of the audience
• AUDIENCE_STATUS: Membership status (active / realized)
• Mapping attributes: one column per attribute selected during the activation workflow

Legacy Table Structure — Deprecated End of June 2026

The previous format represented each audience as a separate column using the pattern ups_<audience-id> with values like active. This structure is deprecated at the end of June 2026.

Transition Period and V2 Naming Convention

Connections created after the March 2026 Experience Platform release display both table structures during transition. The newer-format tables are prefixed with V2_ (e.g., V2_<table-name>). Existing connections retain the previous structure until the June 2026 deadline.

Other Key Facts

• 7-day TTL: Exported data automatically expires after seven days.
• Batch frequency: 24-hour refresh cycles.
• Incompatibility: Accounts behind firewalls or using Azure Private Link are not supported.

KG Relevance

• Grounds TC-123: body addition to AEP→Snowflake Batch activation operational-task node(s) documenting the June 2026 column-per-audience deprecation and migration to column-per-attribute format.
• Complements source.experienceleague-adobe-com.en-docs-experience-platform-destinations-guardrails-2026 (activation-layer limits) and source.helpx-adobe-com.legal-product-descriptions-aep-activation-2026 (export quota constraints).