Create a UDF instead of the jinja macro that does the logic for get_current_catalog() and call it as a sql query in the python model:

query = "SELECT get_current_catalog() AS CURRENT_CATALOG" result = session.sql(query).to_pandas()