Is it possible to spin up a free development / test instance of an AWS Redshift server to run test queries on? I have a traditional MS SQL Server background and am interested in looking into AWS Redshift. Microsoft offers a free download of their development version installer of SQL Server, and I was wondering if there's an equivalent for AWS Redshift so that I can run some test queries and check out the performance.
Redshift is a service so you cannot run it locally unless you want to buy AWS Outposts. 

Nevertheless, you can try RS during Free Tier - trial period. After that price can be as low as $0.25 per Hour (+traffic+tax), billed hourly.