Based on the information provided in the extracts, it seems that you can set up a full-refresh sync with the overwrite mode for your Salesforce source. This mode will overwrite all data in the destination table with a new copy of the source data, regardless of whether the data has previously been synced or not [source](https://airbyte.com/tutorials/full-data-synchronization). However, it's important to note that this approach will not preserve any SCD (Slowly Changing Dimension) history, as the full-refresh overwrite mode will replace the entire destination table with the new data [source](https://docs.airbyte.com/understanding-airbyte/connections/full-refresh-overwrite). If you want to refresh your Salesforce sync once a week, you can create a new connection with the full-refresh overwrite mode and schedule it to run weekly. This will ensure that your base tables are refreshed, but it won't maintain the SCD history. Unfortunately, the extracts do not provide information on how to set up a full-refresh sync that overwrites the base tables without affecting the SCDs. You might want to explore other options or consult the Airbyte documentation and community for more guidance.