[CT-33] Add macro/run-operation for uploading files from local filesystem to S3

[NiallRees]

Describe the feature

Prompted by brooklyn-data/dbt_artifacts#60.

Access to a macro such as:

{% do adapter.upload_file(file_path, destination) %}

would enable dbt_artifacts to become compatible with Redshift. The user would need to create their own S3 bucket, and grant any policies needed.

The adapter already has boto3 as a dependency, so no additional packages should be needed.

Describe alternatives you've considered

A clear and concise description of any alternative solutions or features you've considered.

Additional context

Please include any other relevant context here.

Who will this benefit?

What kind of use case will this feature be useful for? Please be specific and provide examples, this will help us prioritize properly.

Are you interested in contributing this feature?

Let us know if you want to write some code, and how we can help.

[McKnight-42]

@NiallRees Thank you for also trying to implement this functionality in Redshift love the idea of having uniformity for how we extend our adapters as much as possible, I will open this up as a good first issue to work on as we did for the big-query

[McKnight-42]

boto3 upload_file would need to add a new method in impl.py to be able to reference within the adapter.sql suggested macro.

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue, or it will be closed in 7 days.