Hi, I am trying to export amplitude data to redshift. I was able to successfully export 1 day data into redshift for a given schema. But later I found out schema is incorrect and so I created one more export with the required schema. But I tried to backfill 1 day. But this time its taking long long time and not progressing at all. Its stuck at 50% and not progressing further. It always show the export status as 50%.
Kindly help me and guide me on this issue
Hi
Per the docs, this process can take anywhere from a single day to several weeks, depending on your data volume, warehouse size, cluster count, network bandwidth, and number of concurrent historical data exports you currently have, among other factors.
If everything checks out on the above factors, then maybe you can delete this export job and start a new one.
Hi Saish, Thanks for the reply.. Today I saw its in “Failed” status. Not sure what is the reason for the failure. Is their anyway to know what is the reason for the failure ?
But initially it got loaded successfully for different target database(with in same cluster)
When I am trying for different database I am facing this issue.
Also I have exported different amplitude event ot the same target redshift schema, even that export job worked fine.
Only this time I am facing this issue
any further guidance or assistance here ?
Thanks for jumping in
Hi
Hi
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.