Add table expiry

[thomas-vl]

Description & motivation

Add hours_to_expiration as an option to external tables in bigquery resolves: #225

version: 2

sources:
  - name: test
    loader: gcloud storage
    dataset: "{{ target.dataset }}"
    tables:
      - name: test
        description: Sheet
        external:
          hours_to_expiration: 24
          location: 'https://docs.google.com/spreadsheets/d/id'
          options:
            format: google_sheets
            skip_leading_rows: 1
            sheet_range: 'sheetrange'
        columns:
          - name: column_name
            data_type: STRING
            description: "Column Name"

Checklist

• [x] I have verified that these changes work locally
• [x] I have updated the README.md (if applicable)
• [x] I have added an integration test for my fix/feature (if applicable)

[dataders]

any progress on this @thomas-vl?

[github-actions[bot]]

This PR has been marked as Stale because it has been open with no activity as of late. If you would like the PR to remain open, please comment on the PR or else it will be closed in 7 days.