_fivetran_deleted column missing

[rdpom]

Hi! I have a fivetran connector which uses Airtable as a source and snowflake as a destination. 

Viewing the snowflake data in metabase, I can't see the column _fivetran_deleted, as expected with safe delete enabled. Any advice here? Thank you! 

[SVijay]

Hey @rdpom I have updates from our product team. While they're still looking into the Fivetran_Synced Column not being replicated, we perform hard deletes in live mode, so fivetran_deleted column is not required

If you wish to retain the past versions of the rows, we would recommend using history mode.

Our internal logs do indicate that the _Fivetran_Synced column was created. To ensure we're all on the same page, I would recommend creating a support ticket so we could look into a quick resolution.

Thank you

[Toby-Metcalf]

Thank you for staying on top of this @SVijay 

[rdpom]

@SVijay thanks for this update. 

Can you clarify what you mean by hard deletes in live mode? That seems different how I interpret the documentation for the Airtable Connector. Under Capture Deletes it highlights that Fivetran soft deletes records.

is this not correct? 

Filing a support ticket now thank you!