Hi
@Thomas Adams, if I understand your question correctly, you'd like to store some credentials like username/password in environment variables; that's certainly doable with Prefect!
https://docs.prefect.io/core/concepts/configuration.html#user-configuration should help you get started with environment variables.
For an ETL example,
https://docs.prefect.io/core/tutorials/etl.html#e-t-and-l should be helpful to get an understanding for how Prefect can be used to break down those tasks; adding a task to handle authorization as an upstream dependency (that returns a token or code) could be accomplished by adding a task which makes an http call to your auth provider. For that, I'd recommend the
requests
package or one of the various OAuth python libraries (
https://oauth.net/code/python/ has a nice list!).
Is that helpful?