Skip to main content
Solved

Mass Delete Catalog Items

A
Data Voyager
Forum|alt.badge.img+2

Hi Community,

We have a scenario where an entire schema was imported as an Ataccama source. This resulted in over 700 tables/views brought in as catalog items.

Is there a way to bulk delete all 700?

Thank you.

Best answer by anna.spakova

@akuma You can also delete the catalog items through the ONE Desktop tool. In the first step you will read the catalog items you want to delete using ONE Metadata Reader step, and in the second step you delete them using ONE Metadata Writer step with workflow state as Deleted. If interested in this approach, I can provide more information/example of the plan configuration. This can be used for any assets in the platfrom (terms, rules, ...)

Anna

View original
Did this topic help you find an answer to your question?

4 replies

A
  • Anonymous
  • 0 replies
  • August 10, 2022

Hi @akuma ,

thank you for your question. For earlier versions than 13.9.0 the only solution is to delete it one by one. From version 13.9 bulk delete will be possible.

Kind regards,

Adél

P
1 person likes this
  • P
    PaulS
Catherine
Data Pioneer
Forum|alt.badge.img+5
  • CatherineData Pioneer
  • Data Pioneer
  • 31 replies
  • September 9, 2022

@akuma  You can massive delete at the schema level via “location”.  This will remove all tables/view that is associated to that schema(location)  see screen shot below.

 

anna.spakova
Ataccamer
Forum|alt.badge.img+3
  • anna.spakovaAtaccamer
  • Ataccamer
  • 151 replies
  • Answer
  • September 12, 2022

@akuma You can also delete the catalog items through the ONE Desktop tool. In the first step you will read the catalog items you want to delete using ONE Metadata Reader step, and in the second step you delete them using ONE Metadata Writer step with workflow state as Deleted. If interested in this approach, I can provide more information/example of the plan configuration. This can be used for any assets in the platfrom (terms, rules, ...)

Anna

S
E
2 people like this
  • S
    Siva_Madhavan
  • E
    elpertu
anna.spakova
Ataccamer
Forum|alt.badge.img+3

Hi, as requested via direct message, for reference there is an example attached (for terms). Be careful with mass deletes, the deleted entities cannot be recovered.

Anna

1 Attachments
Cansu
1 person likes this
  • Cansu
    Cansu

Reply


Related topics

Most Liked this week

Community Terms of Use & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings