Is there a way to yield async context managers

[dagsir[bot]]

Is there a way to yield async context managers?

I am trying to follow this example:

    def yield_for_execution(self, context):
        # keep connection open for the duration of the execution
        with get_database_connection(self.username, self.password) as conn:
            # set up the connection attribute so it can be used in the execution
            self._db_connection = conn

            # yield, allowing execution to occur
            yield self```
I would like to use an asyncronouse psycopg cursor, but haven't been able to get it to work. Is there support for this?

---

*The question was originally asked in [Dagster Slack](https://dagster.slack.com/archives/C01U954MEER/p1700145452955879?thread_ts=1700145452.955879&cid=C01U954MEER).*

[alangenfeld]

Its unclear from the code provided so far what exactly you are trying to do in the context of Dagster and what exactly did not work.

async functions are supported for @op / @asset

[tyler-jenkins]

We're looking for async resources that require a context managers, like AsyncConnection from psycopg. Is there support for this?