Amazon Redshift Spectrum

  • Useful blend of managed vs fully serverless (with BigQuery being the only truly serverless)
  • Redshift Spectrum which
  • filename date2008_pipe.txt instead of the advised date_pipe.txt
  • delimiter “\t” in sales_tab.txt instead of the advised “|”
  • date format “D/M/YYYY hh:mm:ss” instead of the advised “YYYY-MM-DD hh:mm:ss”; I resolved this using Google Sheets as follows
  • row count 172456 instead of the advised 172462

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Oli Steadman

Oli Steadman

Bass/BV @StornowayBand. DataCat @AstraZeneca. Consulting via StoneStreetProductions.