Is there an option to delete and Object, even it is having dependencies through CLI
I have a datapoint which is being used in the dataflow. I want to delete that particular datapoint by ignoring the dependency through CLI.
In Diyotta we have added new functionality to delete objects and get dependency for objects through dicmd.
New dicmd options are added to get dependency and delete in cli command.
Command: dicmd delete [-u userName -w userPassword] -p ProjectName [-l LayerName] [-g GroupName][-o DOBJ|DATAPOINT|NSEQ|EXPR|UDF|DATASUBFLOW|DATAFLOW|DATASTREAM|JOBFLOW|DATACONNECT|SCHTASK|SCHCAL|SCHEMAIL|SCHFILE|SCHEVENT|SCHEDULER|PROJECTPARAMS] [-t NZ|TD|OR|FF|PG|DB|HV|MS|BI|CO|SF|HD|JS|HB|XD|SP|TW|FB|SK|JM|KK|CS|SY|SS|TS|SN|MY|BQ|RT|AV|PR|AZ|GC|RS|DR|AU|OF|DC|DX|ES|GA|GW|PS|MD|BS|AD] -n ObjectName [-c ConnNm] [-f ForceDelete]
Example: dicmd delete -u sampleuser -w pwd -p QA_Testing -g TERADATA -o DATAPOINT -t TD -n CONN_TD -f Yes
Note: ForceDelete (-f) should be given as ‘Yes’ if dependent object(s) exists.
- Show Dependency
Command: dicmd getdependency [-u userName -w userPassword] -p ProjectName [-l LayerName] [-g GroupName] [-o DOBJ|DATAPOINT|DATAFLOW|NSEQ|EXPR|UDF|DATASUBFLOW|PP] [-t NZ|TD|OR|FF|PG|DB|HV|MS|BI|CO|SF|HD|JS|HB|XD|SP|TW|FB|SK|JM|KK|CS|SY|SS|TS|SN|MY|BQ|RT|AV|PR|AZ|GC|RS|DR|AU|OF|DC|DX|ES|GA|GW|PS|MD|BS|AD] -n ObjectName [-c ConnNm]
Example: dicmd getdependency -u sampleuser -w pwd -p QA_Testing -g HADOOP -o DATAPOINT -t HV -n HIVE_112