A published extract is a copy of the data as of its last refresh. Extract Refreshes on a data source (or on a workbook with an embedded extract) schedules new copies.
A full refresh rebuilds the whole extract. An incremental refresh only adds rows whose key column, chosen in Tableau Desktop, is newer than the last refresh. That is fast for data that only grows, like web sessions, but changes to older rows never arrive. A common pattern is incremental every hour plus a weekly full refresh.
A schedule runs while nobody is signed in, so the connection needs an embedded password. When a refresh fails after a password change or with Prompt user, fix the connection, not the schedule.
Tableau Cloud runs in the cloud, so it can't reach a database on your private network by itself. Tableau Bridge clients inside your network do it: the private network allowlist sends each domain to a pool of clients that can reach it. Tableau Server sits inside your network and reaches such databases directly.
Incremental keeps it current; the weekly full refresh picks up anything else.