RRoger
02/22/2022, 4:54 AMparameters.yml
is a long complicated SQL string:
sql_param: >
SELECT
...
The weird thing is that running it in through the node produces errors. If I copy and paste the SQL string to a DB tool, it runs fine. Is yaml or Kedro treating some characters in the SQL script differently?
Is there a better way to make a node run SQL? Can I use pandas.SQLQueryDataSet even though the query is not supposed to return anything?