Create INSERT trigger

DROP TRIGGER IF EXISTS NEW_ROUTE;
CREATE TRIGGER NEW_ROUTE
    AFTER INSERT
    ON routes
    FOR EACH ROW
BEGIN
    CALL mysql.lambda_async(
            'arn:aws:lambda:eu-west-1:XXXXXXXXXX:function:RDS-EVENTS-CONSUMER',
            JSON_OBJECT('new', JSON_OBJECT(
                    'airportFrom', NEW.airportFrom,
                    'airportTo', NEW.airportTo,
                    'connectingAirport', NEW.connectingAirport,
                    'newRoute', NEW.newRoute is true,
                    'seasonalRoute', NEW.seasonalRoute is true,
                    'operator', NEW.operator,
                    'group', NEW.group,
                    'tags', NEW.tags,
                    'similarArrivalAirportCodes', NEW.similarArrivalAirportCodes,
                    'carrierCode', NEW.carrierCode)
                )
        );
end;

# Test insert
INSERT INTO flights.routes (airportFrom, airportTo, connectingAirport, newRoute, seasonalRoute, operator, `group`, tags, similarArrivalAirportCodes, carrierCode) 
VALUES ('FOO', 'BAR', null, false, false, 'RYANAIR', 'CITY', '', '', 'FR');