25 Messages
•
5K Points
Is there a way to select certain Database Views in Schema Sync Config?
We want to include database Views as part of the metadata sync. I know there's a configuration rule to include/exclude database views. And you can also set this via API skipview command line set to true or false. However, we don't want to bring in all the database views and want the option to select.
For tables, there's a configuration setting to select tables to Include and Exclude. Will this work for database views?
Is there an API string I can use?
Thanks!
Accepted Solution
grantrollerson1
144 Messages
•
9.9K Points
8 months ago
I tested in the Edge sync (Database / Configuration) and added a test view to the 'Exclude Tables' list and resynchronised. This was a database on a Redshift cluster, the database configuration settings;
- Include Tables >> Yes (*)
- Exclude Tables >> <my view in test>
- Options >> Database Views Included
The result was ... the view was excluded (set to 'Missing from source'). So yeap, looks like that's a pathway.
(edited)
1