Send data to databases and data warehouses

Databases are a common destination for flow results. The Insert modules found under the Database category in Flow Studio's Module library are the simplest way to store data in any of the common databases. They work in a similar way, regardless of the database type.

Data warehouses

When working with data warehouses like Snowflake, you can use Insert modules to write data directly to the destination tables. However, this might not be the most efficient way due to both performance and costs.

A more common approach is to batch data, upload it to a staging area that is accessed from the warehouse, and then use the corresponding Publisher modules to transfer the batches into the destination tables.