Andrew Pruchinski
09/08/2022, 6:17 PM%
and pandas.read_sql. There seems to be an issue during compilation during a prefect flow run where it's complaining about the wildcard. We can run the queries outside of a prefect run no problem. When executing in prefect, we are getting formatting errors. Errors listed in threadsTypeError: %o format: an integer is required, not dict
ValueError: unsupported format character 'v' (0x76) at index 485
name ILIKE '% vs XXXXXXX'
as %
(wildcard + space) is being read a formatting method. And the other error was happening with the query AND id NOT ILIKE '%lounge%'
so %l
is being read as %oJeff Hale
09/08/2022, 11:08 PMAndrew Pruchinski
09/09/2022, 12:04 AMJeff Hale
09/09/2022, 12:23 AMAndrew Pruchinski
09/09/2022, 3:10 PM