Andrew Pruchinski09/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 threads
TypeError: %o format: an integer is required, not dict
ValueError: unsupported format character 'v' (0x76) at index 485
name ILIKE '% vs XXXXXXX'
(wildcard + space) is being read a formatting method. And the other error was happening with the query
AND id NOT ILIKE '%lounge%'
is being read as %o
Jeff Hale09/08/2022, 11:08 PM
Andrew Pruchinski09/09/2022, 12:04 AM
Jeff Hale09/09/2022, 12:23 AM
Andrew Pruchinski09/09/2022, 3:10 PM