Solved

How can I import historical Bigquery data into Amplitude?

  • 3 March 2023
  • 4 replies
  • 150 views

Looks like this feature is in beta but several folks have been able to figure it out. Would love advice - we’d love to put in historical data so we that we don’t lose any of the information before we connected our codebase to Amplitude. Thanks so much.

icon

Best answer by Saish Redkar 8 March 2023, 16:50

View original

4 replies

Userlevel 7
Badge +10

Hi @vpuri 

This document will help - https://www.docs.developers.amplitude.com/data/destinations/bigquery/

Looks like this feature is now GA to all plans.

Hey @Saish Redkar ! Thanks for this. It looks like this is from Amplitude to BQ. We’re looking for a way to import historical BQ data to Amplitude. Your help would be invaluable! 

Userlevel 7
Badge +10

Oh, my bad. Read it as export. Thanks for pointing it out, @vpuri.

I don’t see any mention of BQ as a Source yet, but import from GCS is definitely supported - https://www.docs.developers.amplitude.com/data/sources/google-cloud-storage/

 

I could find the following related post


Maybe @Amplitude Admin can help you point in the right direction.

Userlevel 7
Badge +10

@vpuri

I think they just added the BQ as a source link in there

https://www.docs.developers.amplitude.com/data/sources/bigquery/

Hope this helps.

Reply