# Is there a way to pass grid variables to a transformation job and have the "Read"/"Write" components access the variables?

**URL:** <https://matillioncommunity.discourse.group/t/is-there-a-way-to-pass-grid-variables-to-a-transformation-job-and-have-the-read-write-components-access-the-variables/2147>\
**Category:** Matillion ETL\
**Created:** [April 18, 2023, 3:06pm UTC](https://matillioncommunity.discourse.group/t/is-there-a-way-to-pass-grid-variables-to-a-transformation-job-and-have-the-read-write-components-access-the-variables/2147 "2023-04-18T15:06:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ishan.bhardwaj](https://avatars.discourse-cdn.com/v4/letter/i/a4c791/32.png) [@ishan.bhardwaj](https://matillioncommunity.discourse.group/u/ishan.bhardwaj)\
**Post date:** [April 18, 2023, 3:06pm UTC](https://matillioncommunity.discourse.group/t/is-there-a-way-to-pass-grid-variables-to-a-transformation-job-and-have-the-read-write-components-access-the-variables/2147/1 "2023-04-18T15:06:31Z")

</div>

I'm working on CDC for my warehouse, and with the warehouse size increasing, I want to add a scalable methodology for my CDC. The CDC is done in 3 steps, 1. Insert New Records 2. Insert Changed Records 3. Close out Changed (Old) Records.

&nbsp;

Hoping to complete the 3 steps through variables for table names so I don't end up with a hundred components doing the same thing.

&nbsp;

I know one way to go about it is Shared Jobs, but just looking for some direction.

---

<div class="post-metadata">

**Author:** ![ASD](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/asd/32/1323_2.png) [@ASD](https://matillioncommunity.discourse.group/u/ASD)\
**Post date:** [April 20, 2023, 7:15am UTC](https://matillioncommunity.discourse.group/t/is-there-a-way-to-pass-grid-variables-to-a-transformation-job-and-have-the-read-write-components-access-the-variables/2147/2 "2023-04-20T07:15:54Z")

</div>

You can pass Grid variable values to transformation using Grid Iterator. You need to configure the grid values for each iteration to pass in transformation using environment variable.

&nbsp;

Check this --\> https://documentation.matillion.com/docs/2943274