Add support for Redshift data sharing tables
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
Info on data sharing: https://docs.aws.amazon.com/redshift/latest/dg/datashare-overview.html
Right now I have a "consumer" cluster that has read-only access to several tables from another cluster via data sharing, and I can see rows corresponding to these tables when I run this:
```sql
select * from svv_all_tables;
```
Note that `svv_tables` omits these rows, but `svv_all_tables` has them.
I can also see column information for all of those tables from this query:
```sql
select * from information_schema.columns;
```
But I cannot see the tables in the tables list in Postico - in fact on a cluster with just data sharing tables the tables list is blank, even though I can definitely see there is a table in `svv_all_tables` (and can query that table):
This is on `Version 2.3 dev (9781)`
Similar to https://github.com/jakob/Postico/issues/382
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the Redshift data-sharing documentation and compare the table discovery behavior described for svv_tables, svv_all_tables, and information_schema.columns. Reproduce the issue on a consumer cluster containing shared tables, then trace the table-listing entry point; done means shared tables appear in Postico's tables list.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- aws
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100