문제 설명
Firebase에서 Amazon Redshift로 데이터 로드 (Load data from firebase to amazon redshift)
Firebase에 약 500MB의 데이터가 있고 이를 매일 amazon redshift로 옮기고 싶습니다. 위의 문제에 대한 가장 좋은 방법은 무엇입니까?
미리 감사합니다.
참조 솔루션
방법 1:
What is "the best way" depends on your criteria, and often highly subjective. But a few pointers may help you get started:
- don't download the entire data with a single
ref.once('value'. Loading that much data will take time and all your regular users will be blocked while your read is being fulfilled. - do consider using Firebase's private backups. These are coming out of a different data stream, so will not interfere with your regular users. But the downside is that you'll need to a paid app to be able to use this feature.
- do consider how you can make your backup process streaming, instead of daily. Firebase is a real‑time database, and typically works best when you consider the data flow to be real‑time too.
(by Shailendra、Frank van Puffelen)