Running DBD for specific group of table

Anant_Rustagi

Is it possible to run the DBD on group of tables in a independent physical schema? instead of running it on whole database?

Vivek_V__Kumar

HI,
The Designer has two modes, Comprehensive and Query-specific. Comprehensive does a complete set of projections based on your existing design. Query-specific only does a set of projections for the table(s) in the query/queries provided. So if your query is on a single table then it will only do projections for that table. If it involves multiple tables it will do projections for all tables referenced in the query. 

Daniel_Leybovic

Hi!

Yes, just follow to DBD API:

• http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFuncti...
• https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/ProgrammersGuide/DBDAPI/WorkflowForRunnin...