Can we have a rows filter where we can use column ...
# ask-community-for-troubleshooting
t
Can we have a rows filter where we can use column with value so that we can only filter and replicate only few rows from source to destination? EX: where status=’A’ So, here we want to replicate rows only matching status which is ‘A’, and remaining rows should not be replicate from source to destination. Source Status column Values: A I C But Destination we should have only status ‘A’. A
h
Hey we don't have this feature. But once the data is moved to destination then you can run custom DBT and apply some filter. I hope this helps
t
@Harshith (Airbyte) But instead of moving all the rows to destination, can't we restrict few rows to the destination? I mean during the replication, can't we use where condition in the configuration level or something for only that particular job?
u
Hey, we don't have that feature on the existing connector. In case you feel that's something reusable maybe you can write a custom connector(tweak the existing one a bit).
t
okay got it @Harshith (Airbyte) Thanks for the clarification.