Configure a data layer checker - Alibaba Cloud's

A data layer checker is used to specify the naming conventions of tables at the data layer. This way, you can use a table name to easily ... DocumentCenter   AllProducts Search DocumentCenter DataWorks DataModeling DataWorksDataModeling DataWarehousePlanning Datalayer Configureadatalayerchecker all-products-head ThisProduct ThisProduct AllProducts Configureadatalayerchecker Youcanaddacheckeronthedetailspageofthecreateddatalayertospecifythe namingconventionsoftablesatthedatalayer.Thisfacilitatessubsequenttable management.Thistopicdescribeshowtoviewdetailsaboutadatalayerandhowto addadatalayercheckerinDataModeling. Prerequisites Adatalayerforwhichyouwanttoconfigureacheckeriscreated.Formoreinformation abouthowtocreateadatalayer,seeCreateadatalayer. Backgroundinformation Adatalayercheckerisusedtospecifythenamingconventionsoftablesatthedata layer.Thisway,youcanuseatablenametoeasilyobtainthefollowinginformation aboutthetable:businesstype,functionality,anddatagranularity.Thedatalayer checkeralsohelpsreduceoperationsandmaintenance(O&M)costs. Youcanaddandconfigureacheckerforadefaultdatalayercreatedbythesystem orforyourcustomdatalayer. NoteYoucanrepeatthefollowingstepstoaddandconfigureacheckerforeachdatalayer. OntheDataLayerpage,clickthecreateddatalayertogotothedetailspageofthedatalayer. Configureadatalayerchecker.Onthedetailspageofthedatalayer,addandconfigureacheckerforthedatalayer: NoteAdatalayercheckerisusedtospecifythenamingconventionsoftablesatthedata layer.Thisway,youcanuseatablenametoeasilyobtainthefollowinginformation aboutthetable:businesstype,functionality,anddatagranularity.Thedatalayer checkeralsohelpsreduceoperationsandmaintenance(O&M)costs. IntheCheckerManagementsection,clickAdd. Configureparametersforthechecker. Parameter Description Abbreviation Theabbreviationofthechecker. Theabbreviationcanbeupto128charactersinlength,andcancontainlowercase letters,digits,andunderscores(_).Itmuststartwithalowercaseletter. Name Thenameofthechecker. Thenamecanbeupto2,048charactersinlength,andcancontainletters,digits, underscores(_),ampersands(&),andparentheses().Itmuststartwithaletteror adigit. Type YoucansetTypeonlytoTableNameChecker.Theparameterisusedtocheckwhetherthenamesoftablesatadatalayerconform tothenamingconventionsofthedatalayer. RuleDefinition Therulesagainstwhichthenamesoftablesatadatalayerarechecked.Youcanenter atablenameprefixtodefinearule.Forexample,adatalayermuststartwithdim.Youcanalsoclicktheicontodefinearulebyenteringtheabbreviationofabusinesscategory,datadomain, businessprocess,root,multi-root,storagestrategy,dimensiondefinition,orperiod, orenteringacustomdefinition. Default Specifieswhetherthecheckerisconfiguredasthedefaultchecker. Enabled Specifieswhethertheconfiguredcheckertakeseffect.Bydefault,theconfigured checkerisenabled. Real-timeCheck Specifieswhethertoenablereal-timecheck.Bydefault,real-timecheckisdisabled. Real-timecheckisenabled:Thetablenameisautomaticallycheckedinrealtimewhen thetableisbeingcreatedormodified. Real-timecheckisdisabled:Thetablenameisnotcheckedinrealtimewhenthetable isbeingcreatedormodified.YouneedtoclickStartCheckonthedetailspageofthedatalayertocheckthetablenameafterthetableis createdormodified. Description Thedescriptionofthechecker. ClickSavetosavethesettingsofthechecker. Startthecheckerandviewthecheckresult. Afterthecheckerisconfigured,clickStartCheck.Thesystemstartsallcheckersatthedatalayertocheckwhetherthenamesofall tablesatthedatalayerconformtothenamingconventionsofthedatalayerbased onthecheckersettings. Afterthecheckiscomplete,clickViewResultstoviewthecheckresultsintheViewResultdialogbox. Example1:SettheRuleDefinitionparameterto^dim_.*fortheconfiguredcheckerintheCheckerManagementsectionifanenterpriserequires thatthenamesoftablesatadatalayerstartwithdim_.ThefollowingtabledescribesthecheckresultsafteryouclickStartCheckfor tablesdim_sku,dim_store,dimension_warehouse,andfact_order. Tablename Namingconventionsobserved dim_sku Yes dim_store Yes dimension_warehouse No fact_order No Example2:AnenterpriserequiresthattablesattheDWDlayerbenamedintheformat ofAbbreviationofdatalayer_Datadomainofthetable_Abbreviationofcustomtablename tag_df/di.ThefollowingtabledescribesthecheckresultsafteryouclickStartCheckfor tablesdwd_sale_order_df,dwd_sale_order_di,dwd_sale_order,anddws_sale_order_df. Tablename Namingconventionsobserved dwd_sale_order_df Yes dwd_sale_order_di Yes dwd_sale_order No dws_sale_order_df No Whattodonext Afterthedatalayeriscreatedandconfigured,youcancontinuetoplanandcreate datadomains,businessprocesses,andbusinesscategoriesinDataWarehousePlanning. Formoreinformation,seeDatadomain,Businessprocess,andBusinesscategory. Previous:Createadatalayer Next:Viewandmanagedatalayers Howhelpfulwasthispage? Whatmightbetheproblems? Moresuggestions? SendFeedback Thankyou!We'vereceivedyourfeedback.