PopulateFarmDb.java

private void createCustomResourceToPopulateDb(ApiStackProps props, Role lambdaRdsProxyRoleWithPw) throws IOException {
    // See https://docs.aws.amazon.com/cdk/api/latest/java/software/amazon/awscdk/customresources/package-summary.html for details on writing a Lambda function
    // and providers
    Function dbPopulatorHandler =
        defaultLambdaRdsProxy("PopulateFarmDb", props, lambdaRdsProxyRoleWithPw);
Provider dbPopulatorProvider =
        new Provider(
            this,
            "InvokePopulateDataProvider",
            ProviderProps.builder().onEventHandler(dbPopulatorHandler).build());
String scriptFile = "../ApiHandlers/scripts/com/ilmlf/db/dbinit.sql";
    String sqlScript = new String(Files.readAllBytes(Paths.get(scriptFile)));
    
    CustomResource initCustomResource = new CustomResource(
        this,
        "PopulateDataProviderv22",
        CustomResourceProps.builder()
            .serviceToken(dbPopulatorProvider.getServiceToken())
            .resourceType("Custom::PopulateDataProvider")
            .properties(Map.of("SqlScript",sqlScript))
            .build());
  }