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!

Lian Eloisa Martecio

Posted 2 years ago · Edited 1 year ago·Last reply 2 years ago

3 comments

Grant Rollerson

·2 years ago · Edited

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.

Grant Rollerson

·2 years ago · Edited

- 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.

Lian Eloisa Martecio

OP2 years ago · Edited

Great! Thanks, I'll try it out and see what happens.

Update: it worked!

But I wonder how others deal Assets having "Missing from source" tag? Is there a way to delete them automatically? I see there's a workflow package. But when I ran it, it just created a task and seem to need manual work (selection and actual deletion).