Skip to main content
Solved

BigQuery - User properties ingested through bigquery don't sync totally or veeerrry slowly

Adrien Taravant

Hi !

 

I setup yesterday (more than 15 hours ago) a connection between bigquery and amplitude. 

I triggered a full sync on 24k users, ingesting 3 distinct user properties for those users. 

It seems to work BUT after 15 hours or so I see only 4.3k users have been updated (see screenshot below)

 

If I look via “segmentation” chart I find a different result 

 

Is there something around how I look at the data and actually everything is already ingested and updated ?

 

Or is that normal that it takes so long to update the user properties? Or is there some mechanism that explains that? 

 

Thanks!

Best answer by Adrien Taravant

Ok no issue on ingestion actually. It’s actually I believe just about the way amplitude handle user properties and display them. Basically nothing will show until an event from those user happens again. Which is an issue but a different one.

View original
Did this topic help you find an answer to your question?

Adrien Taravant

Ok no issue on ingestion actually. It’s actually I believe just about the way amplitude handle user properties and display them. Basically nothing will show until an event from those user happens again. Which is an issue but a different one.

sydney.koh
Team Member
Forum|alt.badge.img+8
  • sydney.koh
  • Amplitude Support
  • April 11, 2024
Hi Adrien,

Yes it is true the two charts does query on data differently! The User Composition chart will query on values that they see on the most recent active event. The Event Segmentation chart however will query on the values of the event that you choose on the chart. So if you choose the event test for example we show values at the time of that event test.

Does this align with the differences you are seeing?

Best,
Sydney


P.S. Checkout upcoming events and user meetups on our events page.

Reply


Helpful Members this Week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings