Happy 2sday everyone! I have a SQL YAML question. ...
# beginners-need-help
r
Happy 2sday everyone! I have a SQL YAML question. One of the items in my
parameters.yml
is a long complicated SQL string:
Copy code
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?