What if a source has Views and Tables but the only structures desired are only the views. There is a parameter that you can set to include the View metadata. But no parameter to exclude tables (I understand why).
But now I want to exclude all tables. The reason is that the source is Snowflake and the tables have Variant Columns with Json files in them. Views were created that flatten out the Json file and the views are [TABLE_NAME]_V. So we would like to ignore all tables or objects that don't end in _V. I tried "<> %_V" but that didn't work.
Excludes Objects - Want to Source Views Only
2 replies