Note, I’ve changed the variable syntax with this:
variableSyntax: ‘$<([ :a-zA-Z0-9._,\-\/\(\)]+?)>’
I’m trying to build a SQL statement for IOT:
deviceJIT:
handler: hls/deviceJIT.deviceJIT
role: digiJITlambda
events:
- iot:
sql: SELECT * FROM '$aws/events/certificates/registered/$<file(../config/ca-id.json):certificateId>'
It is not substituting the value from the file into the SQL statement. When I look in AWS I just see the unsubstituted string.
I also tried the Fn:Join syntax but Cloudformation does not support it in a SQL statement.