Mike Grabbe
12/07/2022, 11:31 PM[
]
aren't being logged correctly. Has anyone else noticed this? Details in ๐งตfrom prefect import flow, task, get_run_logger
@task
def execute_sql(sql: str):
logger = get_run_logger()
<http://logger.info|logger.info>(f"Executing: {sql}")
<http://logger.info|logger.info>(sql)
@flow
def bracket_flow():
execute_sql("DROP TABLE [dbo].[SomeTable];")
execute_sql("EXEC [dbo].[usp_SomeProcedure];")
if __name__ == "__main__":
bracket_flow()
18:30:31.900 | INFO | prefect.engine - Created flow run 'impetuous-sheep' for flow 'bracket-flow'
18:30:32.506 | INFO | Flow run 'impetuous-sheep' - Created task run 'execute_sql-df2a3f5c-0' for task 'execute_sql'
18:30:32.507 | INFO | Flow run 'impetuous-sheep' - Executing 'execute_sql-df2a3f5c-0' immediately...
18:30:32.714 | INFO | Task run 'execute_sql-df2a3f5c-0' - Executing: DROP TABLE .[SomeTable];
18:30:32.715 | INFO | Task run 'execute_sql-df2a3f5c-0' - DROP TABLE .[SomeTable];
18:30:32.792 | INFO | Task run 'execute_sql-df2a3f5c-0' - Finished in state Completed()
18:30:32.885 | INFO | Flow run 'impetuous-sheep' - Created task run 'execute_sql-df2a3f5c-1' for task 'execute_sql'
18:30:32.886 | INFO | Flow run 'impetuous-sheep' - Executing 'execute_sql-df2a3f5c-1' immediately...
18:30:33.090 | INFO | Task run 'execute_sql-df2a3f5c-1' - Executing: EXEC .;
18:30:33.091 | INFO | Task run 'execute_sql-df2a3f5c-1' - EXEC .;
18:30:33.166 | INFO | Task run 'execute_sql-df2a3f5c-1' - Finished in state Completed()
18:30:33.247 | INFO | Flow run 'impetuous-sheep' - Finished in state Completed('All states completed.')
Andrew Huang
12/07/2022, 11:46 PMfrom prefect import flow, task, get_run_logger
@task
def execute_sql(sql: str):
logger = get_run_logger()
<http://logger.info|logger.info>(f"Executing: {sql}")
<http://logger.info|logger.info>(sql)
@flow
def bracket_flow():
execute_sql("DROP TABLE \[dbo].\[SomeTable];")
execute_sql("EXEC \[dbo].\[usp_SomeProcedure];")
if __name__ == "__main__":
bracket_flow()
Mike Grabbe
12/07/2022, 11:55 PMAndrew Huang
12/08/2022, 12:18 AMMike Grabbe
12/08/2022, 12:20 AMAndrew Huang
12/08/2022, 12:20 AMMike Grabbe
12/09/2022, 1:52 PMAndrew Huang
12/09/2022, 4:49 PM