sql

Martynas Maciulevičius 2024-10-08T17:14:35.153349Z

Does anyone know if it's possible to run full Redshift query locally? I'm not talking about "just use Postgres". I'm talking about running all of the utility functions like CONVERT_TIMESTAMP and so on so that I wouldn't need to hack to target both environments.

dharrigan 2024-10-10T09:26:30.135579Z

I certainly can't vouch for this particular approach (never used it, although I do use the other functions, such as s3, sqs, sns heavily), but localstack does offer a redshift option...that you can run locally (unfortunately, looks like it's a pro image, so a sub is required). Others may have a much better idea 🙂 https://docs.localstack.cloud/user-guide/aws/redshift/

dharrigan 2024-10-10T09:27:21.178829Z

Alternatively, datagrip does offer a Redshift connector (again, never used - but you could at least run the query locally)....