source-snapchat should optionally exclude the delay in data (DELAYED_DAYS)

[emily-flambe]

The Snapchat source connector has a delay so that it only returns finalized metrics. This is not appropriate for all use cases, as some teams require more up-to-date data in order to make quick ad spend decisions based on performance.

My team has delivered this to our customers by creating our own version of the Snapchat connector that sets DELAYED_DAYS=0, but it would be better for this to be configurable in the official Snapchat connector maintained by Airbyte.

I did find this thread from January 2024, but the workaround suggested feels overly complicated when the source connector's behavior can be adjusted with a simple parameter, either:

• user selects whether data should be fetched with a delay to guarantee completeness, or
• DELAYED_DAYS should be directly configurable to whatever value the user needs.