# How do I enable 'SKIP\_FILE' or 'CONTINUE' for the ON\_ERROR option in RDBMS Query Component for Snowflake. Is there any way in Matillion or do I need to this in Snowflake?

**URL:** <https://matillioncommunity.discourse.group/t/how-do-i-enable-skip-file-or-continue-for-the-on-error-option-in-rdbms-query-component-for-snowflake-is-there-any-way-in-matillion-or-do-i-need-to-this-in-snowflake/1963>\
**Category:** Matillion ETL\
**Created:** [November 24, 2022, 4:14pm UTC](https://matillioncommunity.discourse.group/t/how-do-i-enable-skip-file-or-continue-for-the-on-error-option-in-rdbms-query-component-for-snowflake-is-there-any-way-in-matillion-or-do-i-need-to-this-in-snowflake/1963 "2022-11-24T16:14:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![NeelamMacwan](https://avatars.discourse-cdn.com/v4/letter/n/8baadc/32.png) [@NeelamMacwan](https://matillioncommunity.discourse.group/u/NeelamMacwan)\
**Post date:** [November 24, 2022, 4:14pm UTC](https://matillioncommunity.discourse.group/t/how-do-i-enable-skip-file-or-continue-for-the-on-error-option-in-rdbms-query-component-for-snowflake-is-there-any-way-in-matillion-or-do-i-need-to-this-in-snowflake/1963/1 "2022-11-24T16:14:01Z")

</div>

We have some bad data coming in Snowflake which has caused the data load to fail. I know Snowflake has the option to skip the file or continue on error, but not sure if it is in Matillion.

Can anyone please point this out

&nbsp;

Thanks.

Neelam

---

<div class="post-metadata">

**Author:** ![NeelamMacwan](https://avatars.discourse-cdn.com/v4/letter/n/8baadc/32.png) [@NeelamMacwan](https://matillioncommunity.discourse.group/u/NeelamMacwan)\
**Post date:** [December 6, 2022, 2:01pm UTC](https://matillioncommunity.discourse.group/t/how-do-i-enable-skip-file-or-continue-for-the-on-error-option-in-rdbms-query-component-for-snowflake-is-there-any-way-in-matillion-or-do-i-need-to-this-in-snowflake/1963/2 "2022-12-06T14:01:24Z")

</div>

Can anyone look into this please?

Thanks in advance.

&nbsp;

Regards,

Neelam Macwan

---

<div class="post-metadata">

**Author:** ![gjohnson3](https://avatars.discourse-cdn.com/v4/letter/g/9d8465/32.png) [@gjohnson3](https://matillioncommunity.discourse.group/u/gjohnson3)\
**Post date:** [June 1, 2023, 2:35pm UTC](https://matillioncommunity.discourse.group/t/how-do-i-enable-skip-file-or-continue-for-the-on-error-option-in-rdbms-query-component-for-snowflake-is-there-any-way-in-matillion-or-do-i-need-to-this-in-snowflake/1963/3 "2023-06-01T14:35:23Z")

</div>

Surely this should be configurable on the "Load Options" property of a DBQuery... Please Matillion devops... you're our only hope.

---

<div class="post-metadata">

**Author:** ![ramalingam](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/ramalingam/32/909_2.png) [@ramalingam](https://matillioncommunity.discourse.group/u/ramalingam)\
**Post date:** [June 5, 2023, 2:12pm UTC](https://matillioncommunity.discourse.group/t/how-do-i-enable-skip-file-or-continue-for-the-on-error-option-in-rdbms-query-component-for-snowflake-is-there-any-way-in-matillion-or-do-i-need-to-this-in-snowflake/1963/4 "2023-06-05T14:12:58Z")

</div>

[@NeelamMacwan](https://matillioncommunity.discourse.group/u/NeelamMacwan)​ one work around I can see is to not use the Matillion managed stage option, but to create your own custom stage object with whatever configurations you would want and then use that in your load process.

CREATE STAGE my\_int\_stage

COPY\_OPTIONS = (ON\_ERROR='skip\_file');

https://docs.snowflake.com/en/sql-reference/sql/create-stage#examples