Build-view tools / Autogen processes should never build views using "SELECT * FROM..."

Any automated processes such as View Builder in Collect, or any Autogen processes that build views typically in dswXXX databases shouldn't use the coding to build views of "SELECT * FROM xxx".

Views should be built by reading the metadata information to find every column, and build out the explicit SELECT statement with each columnname.

  • John Slagle
  • Jun 16 2021
  • Needs review
Stewardship Tier (SST) Framework / Framework
  • Attach files
  • Pedro Cardoso commented
    22 Jul, 2021 10:49pm

    John has SOLD me on this - the case of the shifting of fields and "non-breakage" of view, but integrity issues that could be hidden and cause VERY BAD THINGS is something I have had happen. I still think this is an edge case as any table schema change should only be done via an autogen activity/recycle, but this is good hygiene. VOTED UP!

    This should extend to our methodology where our consultants should NEVER do SELECT * in a view they are creating (e.g. off a target). ALWAYS select all the fields.

    Attachments Open full size
  • Pedro Cardoso commented
    22 Jul, 2021 10:38pm

    You'll have to sell me on this one for a vote. :-) What is the downside of current implementation?

    Attachments Open full size

Related ideas