Add macro/run-operation for uploading files from local filesystem to BigQuery.

[NiallRees]

Describe the feature

Prompted by brooklyn-data/dbt_artifacts#6.

Access to a macro such as:

{% do adapter.upload_file(file_path, destination) %}
would enable dbt_artifacts to become compatible with BigQuery. It looks as though the function to wrap is load_table_from_file.

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 Been trying to gather some context on this, seems you have a good idea what path we will need to follow on this, I"m here to assist in anyway I can if you want to work on this.

[NiallRees]

Hey @McKnight-42 - I'm going to struggle to get time to contribute this myself, but would love to see this developed!