If I understand correctly, you're using AGOL with Field Maps. You can begin by importing your hosted feature layer into your database to create a Source copy. Then, you can develop a script to back up this Source copy into another feature dataset for redundancy, replacing the backup at a set interval (e.g., hourly, daily, or weekly). The script would then truncate the table and reload the latest data from AGOL into the database. To automate this process, you can schedule the script to run on a server using Task Scheduler, enabling near real-time access to Field Maps data based on your update frequency. Alternatively, if you're proficient with FME Form + Flow, you could leverage that software for automation instead.
However, keep in mind that if you modify the schema of your Field Maps layers, you’ll need to update the corresponding database copies used for dashboarding, as well as any historical backups, to maintain data consistency.
