Support Batch Metadata Freshness

[MichelleArk]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-snowflake functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Support computing metadata-based freshness in batch by implementing a new method calculate_freshness_from_metadata_batch on the RedshiftAdapter and supporting the TableLastModifiedMetadataBatch capability

dbt-adapters spec: dbt-labs/dbt-adapters#127

Describe alternatives you've considered

No response

Who will this benefit?

dbt source freshness metadata users will have access to much speedier source freshness calculations!

Are you interested in contributing this feature?

yes

Anything else?

No response