I’m trying to ingest data from snowflake into amplitude using what is shown here
I’ve got Snowflake and Amplitude connected correctly but when I start the ingestion, it says it completed with no errors but no data is actually ingested. At first I thought it was because my user_ids probably isn’t in the correct format and/or I’m using the wrong user_id but I double checked and everything looks to be in order.
my sql is as follows
with user_emails as (
select user_id, user_email from users
to_varchar( user_id ) as "user_id"
, object_construct('email', user_email) as "user_properties"
I’ve checked that the user_ids in snowflake exist in amplitude, and they are there. Not really sure how to start troubleshooting this. Any thoughts?