(venv) PS C:\Users\sthibeault\PycharmProjects\prefect> prefect deployment build -n gh-new -sb github/github-block-new --apply prefect_flows\Livevox-snowflake-upload.py:get_livevox_users
09
5933.049 | INFO | prefect.engine - Created flow run 'steel-coyote' for flow 'get-livevox-users'
09
5934.069 | INFO | Flow run 'steel-coyote' - Created task run 'get_session_id-f5b5b56d-0' for task 'get_session_id'
09
5934.070 | INFO | Flow run 'steel-coyote' - Executing 'get_session_id-f5b5b56d-0' immediately...
09
5934.816 | INFO | Task run 'get_session_id-f5b5b56d-0' - Finished in state Completed()
09
5934.958 | INFO | Flow run 'steel-coyote' - Created task run 'get_user_list-875e7d0f-0' for task 'get_user_list'
09
5934.959 | INFO | Flow run 'steel-coyote' - Executing 'get_user_list-875e7d0f-0' immediately...
09
5935.529 | INFO | Task run 'get_user_list-875e7d0f-0' - Finished in state Completed()
09
5935.688 | INFO | Flow run 'steel-coyote' - Created task run 'convert_results_to_df-1b2e3f5a-0' for task 'convert_results_to_df'
09
5935.688 | INFO | Flow run 'steel-coyote' - Executing 'convert_results_to_df-1b2e3f5a-0' immediately...
09
5936.049 | INFO | Task run 'convert_results_to_df-1b2e3f5a-0' - Finished in state Completed()
09
5936.136 | INFO | Flow run 'steel-coyote' - Created task run 'load_dataframe_to_snowflake-b5b7c969-0' for task 'load_dataframe_to_snowflake'
09
5936.137 | INFO | Flow run 'steel-coyote' - Executing 'load_dataframe_to_snowflake-b5b7c969-0' immediately...
09
5940.215 | INFO | Flow run 'steel-coyote' - Finished in state Completed('All states completed.')
Found flow 'get-livevox-users'
Deployment YAML created at 'C:\Users\sthibeault\PycharmProjects\prefect\get_livevox_users-deployment.yaml'.
Deployment storage GitHub(repository='
https://github.com/sthibeaultgateway/prefect-test-4.git', reference=None, access_token=SecretStr('**********')) does not have upload capabilities; no files uploaded. Pass
--skip-upload to suppress this warning.
Deployment 'get-livevox-users/gh-new' successfully created with id '2ce90d3f-57d5-4fe9-aa04-0b4bb3e07ccc'.
To execute flow runs from this deployment, start an agent that pulls work from the 'default' work queue:
$ prefect agent start -q 'default'
(venv) PS C:\Users\sthibeault\PycharmProjects\prefect> prefect agent start -q 'default'
Starting v2.6.5 agent connected to
https://api.prefect.cloud/api/accounts/8e48fde3-9f63-4f51-9931-648e3f621b03/workspaces/dc9faed8-bc98-4ccd-a4f4-fe5a9efc60c7...
_ _ _ _ _ _ _____ _
_ _ _ _ _____
| _ \ _ \ __| __| __/
_| _| /_\ / __|
_| \| | _|
| _/ / _|| _||
| (_ | | / _ \ (_ | _|| .` | | |
|_| |_|_\___|_| |___\___| |_| /_/ \_\___|___|_|\_| |_|
Agent started! Looking for work from queue(s): default...
10
0044.068 | INFO | prefect.agent - Submitting flow run 'e0a15f12-2239-4e46-bfe6-3475e01f08df'
10
0044.374 | INFO | prefect.infrastructure.process - Opening process 'delightful-magpie'...
10
0044.387 | INFO | prefect.agent - Completed submission of flow run 'e0a15f12-2239-4e46-bfe6-3475e01f08df'
10
0047.240 | ERROR | Flow run 'delightful-magpie' - Flow could not be retrieved from deployment.
Traceback (most recent call last):
File "C:\Users\sthibeault\PycharmProjects\prefect\venv\lib\site-packages\prefect\engine.py", line 247, in retrieve_flow_then_begin_flow_run
flow = await load_flow_from_flow_run(flow_run, client=client)
File "C:\Users\sthibeault\PycharmProjects\prefect\venv\lib\site-packages\prefect\client\utilities.py", line 47, in with_injected_client
return await fn(*args, **kwargs)
File "C:\Users\sthibeault\PycharmProjects\prefect\venv\lib\site-packages\prefect\deployments.py", line 159, in load_flow_from_flow_run
await storage_block.get_directory(from_path=deployment.path, local_path=".")
File "C:\Users\sthibeault\PycharmProjects\prefect\venv\lib\site-packages\prefect\filesystems.py", line 913, in get_directory
raise OSError(f"Failed to pull from remote:\n {err_stream.read()}")
OSError: Failed to pull from remote:
'g' is not recognized as an internal or external command,
operable program or batch file.
10
0047.889 | INFO | prefect.infrastructure.process - Process 'delightful-magpie' exited cleanly.