Preet Singh
02/16/2022, 7:27 PMmessages
, calls
, message_media
) using the "Incremental | Append" sync mode cannot have its date columns (date_sent
, date_created
, date_updated
) queried. When we try to query date_created
directly, we receive a Spectrum Scan Error
. When we try date_created.member0
we receive relations "date_created" does not exist
. Moving to a "Full Refresh | Overwrite" sync mode (which does work as evidenced by some of our other tables) isn't possible because we have 4+ million records in the messages
tableAkshay Saini
02/17/2022, 5:36 PMJustin Reynolds
02/18/2022, 4:36 AMOfek Katriel
02/21/2022, 5:45 PMVinod Varma
02/21/2022, 7:01 PMdate_created
and other date_*
fields weren’t loaded in a consistent format.