feat(redshift-driver): introspection for external schemas/tables (e.g. Spectrum)

[KSDaemon]

This PR brings support for the introspection of external queries in AWS RedShift. External table properties in external schemas are returned with the common tables metadata. This is pretty useful in the case of using Redshift Spectrum.

Check List

• [x] Tests has been run in packages where changes made if available
• [x] Linter has been run for changed code
• [x] Tests for the changes have been added if not covered yet
• [ ] Docs have been added / updated if required

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

8 Skipped Deployments

| Name | Status | Preview | Comments | Updated (UTC) | | :--- | :----- | :------ | :------- | :------ | | **examples-angular-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-angular-dashboard/83BqNZFrzdS3knH81EHiWkikkrbg)) | [Visit Preview](https://examples-angular-dashboard-git-feat-redshift-sp-8c3015-cube-dev.vercel.app) | | Oct 24, 2024 10:31am | | **examples-react-d3** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-d3/E5LSx8ChjiDJCoxWuwcPred6B3KY)) | [Visit Preview](https://examples-react-d3-git-feat-redshift-spectrum-schema-cube-dev.vercel.app) | | Oct 24, 2024 10:31am | | **examples-react-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-dashboard/Ddd5Gq3Avfjgzupr26QzWhWquVdu)) | [Visit Preview](https://examples-react-dashboard-git-feat-redshift-spec-682139-cube-dev.vercel.app) | | Oct 24, 2024 10:31am | | **examples-react-data-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-data-table/2stDtHgGpWL59P8RC8crbgKh1Suu)) | [Visit Preview](https://examples-react-data-table-git-feat-redshift-spe-66c2e9-cube-dev.vercel.app) | | Oct 24, 2024 10:31am | | **examples-react-highcharts** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-highcharts/J5wHqrbCm6EZXGvHV23AAqAYJanS)) | [Visit Preview](https://examples-react-highcharts-git-feat-redshift-spe-ae3d51-cube-dev.vercel.app) | | Oct 24, 2024 10:31am | | **examples-react-material-ui** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-material-ui/ActT7bQ5o7PneBgew441UiU8bayv)) | [Visit Preview](https://examples-react-material-ui-git-feat-redshift-sp-098d77-cube-dev.vercel.app) | | Oct 24, 2024 10:31am | | **examples-react-pivot-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-pivot-table/2DoKppqFZSJrQX7jgriGREY6Zj8s)) | [Visit Preview](https://examples-react-pivot-table-git-feat-redshift-sp-5bc9b2-cube-dev.vercel.app) | | Oct 24, 2024 10:31am | | **examples-vue-query-builder** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-vue-query-builder/DsHtQwk9FPPPLt3hH8ujGdiKEiz2)) | [Visit Preview](https://examples-vue-query-builder-git-feat-redshift-sp-20011d-cube-dev.vercel.app) | | Oct 24, 2024 10:31am |

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 82.53%. Comparing base (34dc819) to head (1ae6880). Report is 13 commits behind head on master.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## master #8849 +/- ## ========================================== - Coverage 82.55% 82.53% -0.02% ========================================== Files 221 221 Lines 77830 77572 -258 ========================================== - Hits 64249 64023 -226 + Misses 13581 13549 -32 ``` | [Flag](https://app.codecov.io/gh/cube-js/cube/pull/8849/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=cube-js) | Coverage Δ | | |---|---|---| | [cubesql](https://app.codecov.io/gh/cube-js/cube/pull/8849/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=cube-js) | `82.53% <ø> (-0.02%)` | :arrow_down: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=cube-js#carryforward-flags-in-the-pull-request-comment) to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.