Issue Summary
- Redash V9 beta is deployed on AWS as ECS service
- Users Able to create Reports and Dashboards and queries.
- Facing issue with particular query type.
select * from schema_test.products
where brand_name = '{{ param }}'
``
* Created query with parameters
* By selecting the Gear icon above parameters name in query result section,
* I am selecting type as query based dropdown
* Selecting a query that we already have saved
* Errors out with Query cannot be saved
2021-06-03T12:54:06.635-07:00 raise self.error
2021-06-03T12:54:06.635-07:00
Copy
sqlalchemy.exc.ProgrammingError: (pg8000.exceptions.ProgrammingError) {‘S’: ‘ERROR’, ‘V’: ‘ERROR’, ‘C’: ‘42601’, ‘M’: ‘syntax error at or near “$1”’, ‘P’: ‘204’, ‘F’: ‘scan.l’, ‘L’: ‘1128’, ‘R’: ‘scanner_yyerror’}
sqlalchemy.exc.ProgrammingError: (pg8000.exceptions.ProgrammingError) {‘S’: ‘ERROR’, ‘V’: ‘ERROR’, ‘C’: ‘42601’, ‘M’: ‘syntax error at or near “$1”’, ‘P’: ‘204’, ‘F’: ‘scan.l’, ‘L’: ‘1128’, ‘R’: ‘scanner_yyerror’}
2021-06-03T12:54:06.635-07:00 [SQL: SELECT group_id, view_only
2021-06-03T12:54:06.635-07:00 FROM queries
2021-06-03T12:54:06.635-07:00 JOIN data_source_groups ON queries.data_source_id = data_source_groups.data_source_id
2021-06-03T12:54:06.635-07:00 WHERE queries.id in %s]
2021-06-03T12:54:06.635-07:00 [parameters: ((‘637’,),)]
2021-06-03T12:54:06.635-07:00 (Background on this error at: http://sqlalche.me/e/13/f405)
### Technical details:
* Redash Version: V9 Beta
* Browser/OS: Chrome
* How did you install Redash: Deployed on AWS using Docker and ECS service