Ask Your Question
1

Data deletion from database

asked 2017-09-12 22:05:07 -0600

Vivian Yang gravatar image

updated 2017-09-13 16:07:37 -0600

metadaddy gravatar image

How can i delete data from one table in one database (postgres)? I would need to achieve one action which is Delete all the data in the table.

However, One pipeline should have one origin and destination. Current approach i am using is JDBC Query Consumer 1 - [ To select all the data] JDBC QUery 1 - [ To write a query to delete all the data]

Is it a correct approach?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2017-09-13 16:13:21 -0600

metadaddy gravatar image

A pipeline can have multiple destinations, and it can also generate events, which are consumed by executor stages.

So, one way to do this would be to configure the JDBC Query Consumer to produce events, then use the JDBC Query Executor to TRUNCATE data from the relevant table. This case study has an example of the JDBC Query Consumer producing events.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-09-12 22:05:07 -0600

Seen: 51 times

Last updated: Sep 13 '17