I am trying to create schemas after deploying my redshift database and i am using the following local-exec on a null resource but its not creating anything?
Is there anything wrong with the resource created?
resource “null_resource” “db_setup” {
depends_on=[“aws_redshiftserverless_namespace.serverless”]
provisioner"local-exec" {
command=“pyqsl -h ‘redshift-serverless.xxxxxx.us-west-1.redshift-serverless.amazonaws.com’ -p xxxx -U {aws_redshiftserverless_namespace.serverless.admin_username} -d {aws_redshiftserverless_namespace.serverless.db_name} -f ‘${path.module}/scripts/schemas.sql’”
environment={
PGPASSWORD = “${aws_redshiftserverless_namespace.serverless.admin_user_password}”
}
}
}