Question: can ssms connect to redshift?
Answer: Connecting to Amazon Redshift from SQL Server Management Studio using ODBC Driver for Amazon Redshift. You can use the Microsoft SQL Server Management Studio to connect your Amazon Redshift data to an SQL Server instance.