# Matillion Sample Vs Running reality

**URL:** <https://matillioncommunity.discourse.group/t/matillion-sample-vs-running-reality/3165>\
**Category:** Matillion ETL\
**Created:** [April 14, 2025, 9:54am UTC](https://matillioncommunity.discourse.group/t/matillion-sample-vs-running-reality/3165 "2025-04-14T09:54:49Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![farid.srouji](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/farid.srouji/32/1136_2.png) [@farid.srouji](https://matillioncommunity.discourse.group/u/farid.srouji)\
**Post date:** [April 14, 2025, 9:54am UTC](https://matillioncommunity.discourse.group/t/matillion-sample-vs-running-reality/3165/1 "2025-04-14T09:54:49Z")

</div>

Need assistance in figuring the core difference in the sample and actual table results viewed.  
Owning an environment in Matillion, got differences that source back to the sample vs real run of the results.

---

<div class="post-metadata">

**Author:** ![ClaireSeniorCommunityManager](https://avatars.discourse-cdn.com/v4/letter/c/7ba0ec/32.png) [@ClaireSeniorCommunityManager](https://matillioncommunity.discourse.group/u/ClaireSeniorCommunityManager)\
**Post date:** [April 16, 2025, 4:28pm UTC](https://matillioncommunity.discourse.group/t/matillion-sample-vs-running-reality/3165/2 "2025-04-16T16:28:53Z")

</div>

Hi @farid.srouji and thanks so much for the question.

The following actions typically happen when running a single data-loading component.

1. Execute the query/api-command with the source
2. Push the returned data into files in a staging area (SF-stage/s3/blob)
3. Issue a COPY command to Snowflake/Redshift to load from staging
4. Delete the staged files

When you sample, the 1st step is run and a limited result is shown.There is also a `limit` where the data-source supports it.

Let me know if that helps or if you have any further questions - Claire

---

<div class="post-metadata">

**Author:** ![farid.srouji](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/farid.srouji/32/1136_2.png) [@farid.srouji](https://matillioncommunity.discourse.group/u/farid.srouji)\
**Post date:** [April 28, 2025, 7:23am UTC](https://matillioncommunity.discourse.group/t/matillion-sample-vs-running-reality/3165/3 "2025-04-28T07:23:06Z")

</div>

Thank you very much for your reply