Hey folks, I have a question concerning the MySQLFetch task, since it appears I can't supply a file to the query parameter e.g. task = MySQLFetch(query="./data/test-query.sql", ... Is this on the roadmap since otherwise I will have to load each file and pass into the task as a string manually ... thanks for any pointers!
a
Anna Geller (old account)
07/27/2021, 10:36 AM
Hi @Nicholas Hemley, perhaps you could try this before you pass the query to the MySQLFetch task?
Copy code
with open("./data/test-query.sql", "r") as sql_script:
query = sql_script.read()
🙌 2
n
Nicholas Hemley
07/27/2021, 11:35 AM
hehehe, thanks! I guess I was testing the limits of "no such thing as a dumb question" 😉 I have the files loading using Local() Storage so another brick in the wall.