I have a connector with 10 tables and one of them ...
# ask-community-for-troubleshootingg
gunu
07/29/2021, 12:34 PMI have a connector with 10 tables and one of them i want to perform a full refresh.
1. what is the easiest way to achieve this?
2. If i delete all related tables in the database e.g.
mytablemytable_scd_airbyte_raw_mytablec
Chris (deprecated profile)
07/29/2021, 12:36 PM
why do you want to full refresh? because data changed or schema changed?
Chris (deprecated profile)
07/29/2021, 1:03 PM
for the moment, normalization always do full refresh from the raw tables
Chris (deprecated profile)
07/29/2021, 1:09 PM
but the raw table will not be full refreshed, that depends on state that is saved in the airbyte database
we have issues open to improve this and allow api or ui to update this state:
https://github.com/airbytehq/airbyte/issues/4319
g
gunu
07/29/2021, 2:08 PMwell really to try solve this issue: https://airbytehq.slack.com/archives/C01MFR03D5W/p1627387750374100
the error suddenly appeared and wanting to do a refresh - this is a major blocking for our analytics workflow. and unfortunately this connector has many large tables in it so I don’t want to reset the entire connector
gunu
07/29/2021, 2:12 PMso to confirm the state is referenced in the airbyte db and so deleting these tables will definitely not cause a full refresh on the next sync?
c
Chris (deprecated profile)
07/29/2021, 5:03 PM
yes it shouldn’t
3 Views