How can I import historical Bigquery data into Amplitude?

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.

Find more posts tagged with

Accepted answers

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.

All comments

Saish Redkar

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.

vpuri

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!

Saish Redkar

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

Quick Links

Unanswered Questions

time format on import from Big Query
I am running into a loop when attempting to import data from BigQuery. At origin, my data is already in milliseconds since epoch. If I query: event_time as time, I get the error: 1.'time' column should be a TIMESTAMP_NTZ column (Snowflake) or a TIMESTAMP column (BigQuery). example for the type of 'time' column is…
Import data from one amplitude account to another
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
@amplitude/plugin-web-vitals-browser build fails on CRA v4 (react-scripts@4.0.3)
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Question about Amplitude Export API Data Delay
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Retrieve via the API users based on a user property
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!