https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
g

gunu

07/29/2021, 12:34 PM
I 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.
mytable
,
mytable_scd
,
_airbyte_raw_mytable
. and resync the connector, will it perform a full-refresh?
c

Chris (deprecated profile)

07/29/2021, 12:36 PM
why do you want to full refresh? because data changed or schema changed?
for the moment, normalization always do full refresh from the raw tables
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 PM
well 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
so 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