Skip to main content
Solved

Seeding Amplitude with .csv data

  • August 18, 2023
  • 1 reply
  • 396 views

Hi, is there a way to seed my Amplitude account only using csv data? Right now the setup wizard is trying to make me connect an API source, but I just want to import some event data from a csv file and then analyze it with Amplitude. I’m not even able to access the dashboard at all because the setup wizard wants an API connection. Help!

Thanks!

Best answer by Saish Redkar

Hi @Andreezy 

That would have been a really good feature to get immediate value from a csv file, but afaik it’s not supported currently.

The two main ingestion avenues would be either to test out the SDK or use one of the cloud storage/warehouses for data ingestion.

If you have Snowflake warehouse, you can try converting the csv data into a table and then setting up the appropriate schema in the sync. Or import that data via S3.

Other option would be to write a script in Python which reads the csv data and posts each event in there to Amplitude via the HTTP API.

But all these ingestion approaches require some dev work upfront.

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

1 reply

Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1382 replies
  • Answer
  • August 30, 2023

Hi @Andreezy 

That would have been a really good feature to get immediate value from a csv file, but afaik it’s not supported currently.

The two main ingestion avenues would be either to test out the SDK or use one of the cloud storage/warehouses for data ingestion.

If you have Snowflake warehouse, you can try converting the csv data into a table and then setting up the appropriate schema in the sync. Or import that data via S3.

Other option would be to write a script in Python which reads the csv data and posts each event in there to Amplitude via the HTTP API.

But all these ingestion approaches require some dev work upfront.


Reply


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