Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Can data be written from Snowflake into MS SQL Server?

Hi,

I'm trying to automate an import of some data that I have in the data warehouse (Snowflake) back to our internal database (MS SQL Server). I've seen the Database Query Component, but that looks like it can only read from databases (MS SQL Server included amongst other platforms) and write it into the data warehouse (Snowflake), but not the other way around?

Is there a way to write things from the data warehouse out to the database?

Thanks.
Tam.

1 Community Answers

Matillion Agent  

Paul Johnson —

Hi Tam,
To do this I would recommend you use the S3 Unload component and then write a stored procedure or use SSIS to load the data into MS SQL Server from there.
Matillion provides ELT for cloud data warehouses, so this is not supported currently.

Regards,
Paul

Post Your Community Answer

To add an answer please login