Writing Back to Your Application
In the Sample Architectures section, we shared some general practices that our users have employed when augmenting their data warehouse environment with SingleStore. Given the nature of data warehouses and how they may serve other applications, you may want to write your data back to them even after putting them in SingleStore. We understand that, and have methods to do so.
The best way to write to a cloud data warehouse from SingleStore is again via object storage (i.e., S3, GCS, Azure Blob). SingleStore Managed Service enables users to
SELECT… INTO… in order to take the output of a given query and drop it into object storage. This can also be bundled within a stored procedure for continuous updates. You can find that documentation here.