@Marvin , does Prefect allow aPI access to the underlying Sqlite or equivalent database when using the Cloud product

Based on the Prefect documentation, when using Prefect Cloud, there is no mention of direct API access to the underlying SQLite database or an equivalent database. However, Prefect supports an in-memory SQLite database for testing purposes and is not compatible with multiprocessing. For production environments and particularly in the context of Prefect Cloud, you would typically interact with the service through the Prefect API, managed services, and user interfaces rather than accessing the database directly. For more information, you can refer to the following links: - Prefect Server and Database Setup - Configuring a Prefect Server Instance It is important to remember that database access patterns and capabilities might differ based on the deployment method (i.e., self-hosted Prefect Server vs. Prefect Cloud), and direct database access is not a standard feature exposed in cloud-based software as a service (SaaS) product offerings. If you need more specific database interaction details or have other use cases, it may be helpful to contact Prefect support directly.

hi @KG - in general the API is how you access the database 🙂 what are you trying to do?

Trying to figure out why I have pending FlowRuns from July2023 🥴 Initial thought was I could query DB and see if there is a FlowRun record for each run I see in the UI

I would use

client.read_flow_runs

with a

FlowRunFilter

that specifies some dates!