# Hello, We have some applications which use a database based on MariaDB (MySQL) we are wondering how one would go about writing data from Snowflake to those Databases aside from unload data from Snowflake to azure blob and using bash or python to import

**URL:** <https://matillioncommunity.discourse.group/t/hello-we-have-some-applications-which-use-a-database-based-on-mariadb-mysql-we-are-wondering-how-one-would-go-about-writing-data-from-snowflake-to-those-databases-aside-from-unload-data-from-snowflake-to-azure-blob-and-using-bash-or-python-to-import/1747>\
**Category:** Matillion ETL\
**Created:** [May 17, 2022, 12:51pm UTC](https://matillioncommunity.discourse.group/t/hello-we-have-some-applications-which-use-a-database-based-on-mariadb-mysql-we-are-wondering-how-one-would-go-about-writing-data-from-snowflake-to-those-databases-aside-from-unload-data-from-snowflake-to-azure-blob-and-using-bash-or-python-to-import/1747 "2022-05-17T12:51:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![justin.ten.have1623833247849](https://avatars.discourse-cdn.com/v4/letter/j/b487fb/32.png) [@justin.ten.have1623833247849](https://matillioncommunity.discourse.group/u/justin.ten.have1623833247849)\
**Post date:** [May 17, 2022, 12:51pm UTC](https://matillioncommunity.discourse.group/t/hello-we-have-some-applications-which-use-a-database-based-on-mariadb-mysql-we-are-wondering-how-one-would-go-about-writing-data-from-snowflake-to-those-databases-aside-from-unload-data-from-snowflake-to-azure-blob-and-using-bash-or-python-to-import/1747/1 "2022-05-17T12:51:02Z")

</div>

Would the only possible solution be a custom Bash/Python script? The Microsoft SQL Output component shows the most resemblance to what we're trying to achieve [https://documentation.matillion.com/docs/9041587](https://documentation.matillion.com/docs/9041587) but we are not on Matillion ETL for Redshift and we want to write to a MySQL database instead of a MSSQL database.

---

<div class="post-metadata">

**Author:** ![MichaelBoucht](https://avatars.discourse-cdn.com/v4/letter/m/3da27b/32.png) [@MichaelBoucht](https://matillioncommunity.discourse.group/u/MichaelBoucht)\
**Post date:** [June 13, 2022, 3:52pm UTC](https://matillioncommunity.discourse.group/t/hello-we-have-some-applications-which-use-a-database-based-on-mariadb-mysql-we-are-wondering-how-one-would-go-about-writing-data-from-snowflake-to-those-databases-aside-from-unload-data-from-snowflake-to-azure-blob-and-using-bash-or-python-to-import/1747/2 "2022-06-13T15:52:58Z")

</div>

Hello,

&nbsp;

If you have RDS MariaDB in AWS, you can use Matillion component RDS Bulk Output to bulkload from a Snowflake Table/View ( https://documentation.matillion.com/docs/2433679 )

&nbsp;

However, if it's not, Bash/Python would be the way, perhaps try and create a shared job on this one to make it into a generic solution and share it to the world in Matillion Exchange ;)

&nbsp;

-Michael

---

<div class="post-metadata">

**Author:** ![SB699925](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/sb699925/32/1180_2.png) [@SB699925](https://matillioncommunity.discourse.group/u/SB699925)\
**Post date:** [August 19, 2022, 5:43am UTC](https://matillioncommunity.discourse.group/t/hello-we-have-some-applications-which-use-a-database-based-on-mariadb-mysql-we-are-wondering-how-one-would-go-about-writing-data-from-snowflake-to-those-databases-aside-from-unload-data-from-snowflake-to-azure-blob-and-using-bash-or-python-to-import/1747/3 "2022-08-19T05:43:18Z")

</div>

Any updates on this one? We also need to pump data FROM Snowflake INTO MySQL...

​

Matillion is great when Snowflake is the target but not so hot when it's the source.

​

Would be great if you guys built Unload components for ALL the major SQL database flavours similar to the MSSQL Unloader 👍