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

Matillion ETL
1

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 but we are not on Matillion ETL for Redshift and we want to write to a MySQL database instead of a MSSQL database.

2

Hello,

 

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 )

 

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 ;)

 

-Michael

3

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 👍