CODEWITHSUNDEEP
amazon-web-servicesaws-lambdaaws-cdkamazon-aurora
korum
korum

Reputation: 170

Can you create AWS RDS Aurora tables using CDK?

I'm fairly new to AWS CDK, and I just created an architecture with an Aurora cluster inside of it. Is there a way to initialize a database schema inside of my CDK files? It seems a bit annoying to create the instance and then have to connect through other means in order to set up a schema. My impression of CDK is that you can do everything relating to setting up the services, so I was curious if this is a possibility.

If this isn't possible, can I use a lambda that fires off after the CDK deployment? Or maybe have a snapshot inside of s3? I'm just trying to find the best solution!

Upvotes: 6

Views: 6401

Answers (1)

Chris Williams
Chris Williams

Reputation: 35188

You can do this, although it requires you to execute it as a custom resource within the CDK.

You would need to create a Lambda function the performs the SQL DDL tasks for you. This would then return a successful flag back to the execution runtime to say that this "resource" was successfully created.

Upvotes: 10

Related Questions