Skip to content

conversations_messages__messaging_transcript

Description: Child table derived from the nested structure of conversations_messages extracted from Genesys Cloud.

Column Type Description
id text Unique identifier of the record in Genesys Cloud.
pcfrom text Field pcfrom extracted from Genesys Cloud.
to text Field “to” extracted from Genesys Cloud.
timestamp timestamp with time zone Field timestamp extracted from Genesys Cloud.
message_text text Field message_text extracted from Genesys Cloud.
from_user__id text Identifier of a related entity in Genesys Cloud.
from_user__name text Descriptive name of the related entity.
from_user__username text Field from_user__username extracted from Genesys Cloud.
exported boolean Indicates whether the record was marked as exported by the pipeline.
_sdc_source_key_id text Technical control field from the Singer/SDC pipeline.
_sdc_sequence bigint Technical ingestion sequence from the Singer/SDC pipeline.
_sdc_level_0_id bigint Technical identifier of the first nested array level in the Singer/SDC pipeline.

Last updated: