Run SQL

Run predefined SQL scripts against an instance. Note, the scripts needs to be added to S3 by an administrator - this is not free-form SQL.

SQL files are downloaded from <your S3 bucket>/config

For SQL to be run against any clone of an instance, add a .sql file to <your S3 bucket>/config/stacks/<stackname-to-clone>/<stackname-to-clone>-clones-sql.d/

For SQL to run against a specific instance, add the file to <your S3 bucket>/config/stacks/<stackname>/local-post-clone-sql.d/

Application EC2 nodes require the S3:ListBucket permission in their IAM role, as the node downloads the SQL files directly from S3