I'm working with a small team that is constantly juggling Excel files. I commonly have to write scripts to read these files and create records in a Redshift database. Are there any tools that would allow the less technical team members the ability to use a spreadsheet like interface to make edits and while synching their changes to Redshift. I'd like to avoid the ODBC connector for Excel.
You might wanna check out Rudderstack or Stitchdata:<p><a href="https://rudderstack.com/guides/how-to-load-data-from-google-sheets-to-redshift" rel="nofollow">https://rudderstack.com/guides/how-to-load-data-from-google-...</a><p><a href="https://www.stitchdata.com/blog/google-sheets-stitch-easy-sync-to-redshift/" rel="nofollow">https://www.stitchdata.com/blog/google-sheets-stitch-easy-sy...</a><p>And here's a reverse path from Census as well:<p><a href="https://www.getcensus.com/sync/redshift-to-google-sheets" rel="nofollow">https://www.getcensus.com/sync/redshift-to-google-sheets</a>