DBD: Selecting a table vs. schema to optimize
DreaBrandford
Vertica Employee Employee
Does current DBD version have the next granularity level to table name (object name) within a schema rather than full schema level. If not then we have to copy a set of tables to a separate schema in-order to run DBD.
Asked during BDC session Vertica Database Designer – Today and Tomorrow
@ybei
Tagged:
0
Answers
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/DatabaseDesigner/DESIGNER_ADD_DESIGN_TABLES.htm
You can specify list of tables instead of schema.*
Personally I would appreciate an option to specify wildcard in table name as well, something like schema.analytics_*, but it is not a part of the product.
On the other hand when using DBD programmatically, a developer can easily generate the list of tables from database catalog.