[CT-591] Spike: Better handling run_results in threading

[iknox-fa]

Is this your first time opening an issue?

• I have read the expectations for open source contributors

Describe the Feature

See #3600 for more details. This spike should give us a path forward to getting the run_result data if threads are killed due to --fail-fast or keyboard interrupts.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue, or it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest; add a comment to notify the maintainers.

[igorlaryush]

This would be very useful especially in case when database close connection for loading data but you have a large number of models running by dbt that doesn't fully finished and takes a lot of time.