Sharing pre-aggregated data with Paramark

Last updated: August 12, 2026

This article explains how to share pre-aggregated marketing and KPI data with Paramark when your team prefers to own the aggregation pipeline instead of sharing many raw source tables.

This approach is a good fit when:

  • your data team wants to compile the modeling inputs into one or more curated tables before sharing them with Paramark

  • you want Paramark to consume a stable, business-ready schema instead of a dozen or more raw warehouse tables

  • you need an immediate historical backfill in flat files while the long-term warehouse share is still being prepared


Recommended long-term setup: Databricks Delta Sharing

If your data lives in Databricks, the cleanest long-term setup is to share one or more unified tables with Paramark through Databricks-to-Databricks Delta Sharing.

In this model, your team owns the transformation logic and shares the final output table(s) that Paramark should read. This is often simpler than exposing many raw source tables because it gives both teams a single agreed-upon schema and reduces ongoing back-and-forth.

At a minimum, align with your Paramark onboarding lead on:

  • which table or tables will be shared

  • the grain of each table (for example: one row per day and state, or one row per day, state, and channel)

  • which fields represent your target metric, spend, impressions, campaign, geography, and date

  • refresh cadence

  • how campaign or channel rollups should be interpreted

For Databricks sharing setup, follow the warehouse-sharing process in our existing guidance:

  • provide Paramark with your cloud provider and region

  • receive Paramark's sharing identifier

  • create the Databricks share

  • add Paramark as a recipient

Once access is granted, Paramark will validate the shared tables and confirm that the data is queryable.


Immediate workaround: historical flat files

If the Databricks share is not ready yet, you can still move quickly by sending historical data as flat files for initial onboarding.

This is a practical short-term option when your team is still finalizing the long-term shared-table setup. In most cases, these files should represent the same curated, aggregated outputs you plan to expose later in Databricks.

For flat-file delivery, make sure each file has:

  • a clearly defined row structure

  • consistent field names

  • explicit date coverage

  • documented units and currencies where applicable

  • a matching data dictionary that explains what each column means

If you are sharing multiple files, it should be obvious how they relate to one another and which business question each file supports.


What Paramark still needs, even with aggregated outputs

Choosing a curated-table approach does not remove the need for clear documentation. Paramark still needs enough context to interpret the data correctly.

Be prepared to document:

  • the table or file name

  • where the data lives

  • the schema or row grain

  • whether the data is marketing input data or KPI data

  • the channel represented, if applicable

  • refresh frequency

  • known caveats, exclusions, or transformations

If you already use the Paramark Data Catalog, you can document the curated table or flat files there instead of listing every upstream raw source.


Best practices for aggregated-table sharing

  • Share final tables, not views that may change unpredictably.

  • Use stable column names and avoid frequent schema changes during onboarding.

  • Keep the long-term shared table and the short-term flat files as close as possible in structure.

  • Include campaign-mapping logic or naming conventions when sub-channel breakouts matter.

  • Flag any data that is intentionally excluded so Paramark does not assume the table is exhaustive.


When to ask Paramark for help

If you are unsure whether your curated outputs have the right grain or contain the right fields, ask your Paramark onboarding lead to review a sample schema before finalizing the share. It is much faster to validate the structure up front than to rebuild the shared tables after onboarding starts.

If you are deciding between a single unified table and multiple related tables, Paramark can help you choose the simplest structure that still supports your modeling goals.