substitute variables in query string

This template is working as expected. But when I change it to function Substitution, it throws an error. Working template: Parameters: MyS3Bucket: Type: String Resources: createTableOriginalCsv: Type: ‘AWS::Athena::NamedQuery’ Properties: Database: default Description: First query to create table based on AWS bucket data Name: Blog1CreateTableOriginalCsv QueryString: >- CREATE table new_parquet11 WITH (format=’PARQUET’, parquet_compression=’SNAPPY’, partitioned_by=array[‘year’], external_location =…

Details