Hi,
Interested in migrating our scRNA database to Synapse. We currently have our storage layer in S3 and Redshift (column oriented database with SQL language). What's the best way to migrate over?
Also, once we do migrate to Synapse, would there be a simple way to implement CRUD operations using Synapse SQL for the "Tables" object?
Created by dylanmendonca We are happy to help.
> What's the best way to migrate over?
Have you reviewed our documentation? For example:
https://help.synapse.org/docs/Upload-and-Download-Data-in-Bulk.2003796248.html
https://help.synapse.org/docs/Tables.2011038095.html
One tip to add is that Synapse works best when data is imported in large chunks (large files or large numbers of table rows) rather than small ones (small files or individual rows). If your files are small, zip them up into large (>1MB files) before uploading.
> would there be a simple way to implement CRUD operations using Synapse SQL for the "Tables" object?
I suggest having a look at the documentation for Tables, above.
If you have further questions, please ask!
Drop files to upload
Adding/deleting/inserting rows into Synapse tables using SQL page is loading…