Skip to main content
Solved

How can I import historical Bigquery data into Amplitude?

V

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.

Best answer by Saish Redkar

@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.

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

    4 replies

    Saish Redkar
    Expert
    Forum|alt.badge.img+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.

    Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
    Amplitude Admin
    1 person likes this
    • Amplitude Admin
      Amplitude Admin
    V
    • vpuri
    • Author
    • New Member
    • 1 reply
    • March 3, 2023

    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! 

    Amplitude Admin
    1 person likes this
    • Amplitude Admin
      Amplitude Admin
    Saish Redkar
    Expert
    Forum|alt.badge.img+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.

    Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills
    Amplitude Admin
    1 person likes this
    • Amplitude Admin
      Amplitude Admin
    Saish Redkar
    Expert
    Forum|alt.badge.img+10
    • Saish Redkar
    • Expert
    • 1382 replies
    • Answer
    • March 8, 2023

    @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.

    Saish | Connect with me on topmate.io/saish_redkar for supercharging your Amplitude skills

    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