As we mentioned at the beginning of this guide, preparing data for usage and analysis can be difficult, time-consuming work. The good news is that after all the above is completed, the hard part is over. Stitch consolidates and tracks your data for you so you can get to what you really want to do: checking out the data.
If you're the chart-building, eye-candy analysis kind of person, you can layer a visualization tool on top of Redshift instance to create charts, graphs, and more. Check out our partners if you're interested in learning more about visualizing your data.
To connect to and query your data, you'll need a compatible SQL client.
While Amazon recommends SQL Workbench/J to connect to and query Redshift, you can use any SQL client that supports PostgreSQL JDBC or ODBC drivers. Click here to check out some of our recommendations.
Want to use your data for something other than creating charts or queries? From machine learning to statistical modeling, we've put together a list of data science clients you can utilize to get started.