'Amazon Redshift data sharing feature
In Amazon Redshift data sharing, if I change the definition of a table or view in the producer cluster by adding a column etc., will it be automatically reflected in the table or view of the data sharing area?
I will add an object to the data sharing area with ALTER DATASHARE ~ ADD TABLE, but if I change the definition, do I need to enter the above command again?
If you have any idea, I would appreciate it if you could answer.
I'm not used to English, so I'm sorry if it's a strange English sentence.
Solution 1:[1]
If you change the table/view by adding or removing columns it will be reflected automatically on the consumer: no need to alter the datashare. However if you rename the table/view you will have to add it to the datashare objects.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Filippo Loddo |
