Settings

Theme

Ask HN: Spreadsheet like tools that sync to Redshift

5 points by tegansnyder 4 years ago · 2 comments · 1 min read


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.

stefaniabje 4 years ago

You might wanna check out Rudderstack or Stitchdata:

https://rudderstack.com/guides/how-to-load-data-from-google-...

https://www.stitchdata.com/blog/google-sheets-stitch-easy-sy...

And here's a reverse path from Census as well:

https://www.getcensus.com/sync/redshift-to-google-sheets

cpach 4 years ago

Airtable…?

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection