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

But conversely, if my query is, for instance:
TIMESTAMP_MILLIS(event_time) as time,
then I get:
1.'time' column should be milliseconds since epoch. An example for 'time' column: 1396381378123.

I have tried a myriad variations of CAST functions back and forth, and whenever I get milliseconds, the tool asks me for timestamp, and vice versa. And in both cases, the preview of the data to be imported always displays correctly!

any ideas?

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet

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!