Solved

Export data amplitute to bigquery

  • 19 April 2023
  • 2 replies
  • 183 views

Hi ! 

I have follow the steps here to export data to bigquery. The issue is i can only have data from the day i have set up the connection but not before. 

How can i retrieve the data from 3 or 4 month ago ? 

 

Thanks 

 

 

 

icon

Best answer by belinda.chiu 5 May 2023, 23:56

View original

2 replies

Userlevel 5
Badge +8

@mdeguerre welcome to the community and apologies for the delay in getting back to you. I’ve opened a ticket with our tech support team to look into this. They’ll likely ask for a link to the BigQuery project. If you don’t mind DM’ing that to me, I’ll add it to the ticket. 🙏🏻

Userlevel 6
Badge +8

Hi @mdeguerre ! Welcome to Amplitude Community :) If you want to do a backfill of your historical Amplitude events to BigQuery, you should be able to manually start a sync of your historical data: https://www.docs.developers.amplitude.com/data/destinations/bigquery/#:~:text=manually%20start%20a%20sync%20of%20your%20historical%20data 

After you create the destination, you should then be able to see a Backfill tab that will allow you to configure the date range in which you would like to backfill the data. Hope this helps! 

Reply