Skip to main content

Community

Connector Improvement: Salesforce Event Log Storage

Planned

Please sign in to leave a comment.

Comments

3 comments

  • Official comment

    Thanks for the clarification, Aaron. We understand the issue and the team will work on a fix. Stay tuned here for updates.

    Best,

    Sadie

    Hi Aaron,

    Thanks for reaching out about this. Just to confirm: are you referring to the EventLogFile? What are you seeing now in your connection and what would be your ideal state?

    Best,

    Sadie

    Hi Sadie - This includes all of the "...EventLog" tables. In our case we were specifically trying to capture ReportEventLog, LoginEventLog, and LightningPageViewEventLog. The problem, is that the ID field in these tables does not contain a primary key. We were told by the Fivetran support rep that Fivetran was using that ID and attempting to deduplicate records before writing to our warehouse, so only a single row of data would ever be loaded.