What is the best way of loading data and extracting from neo4j to redshift DB .
do you already have some ETL tools in place ?
just curious, why loading to Redshift DB ?
No we don't have any ETL tool. The Cypher query output to join with other tables present in Redshift .
This is my working pipleline
Neo4j -> Talend Neo4j (tNeo4jInput ) Extract CSV -> Talend S3 Bucket Upload -> Talend Redshift tRedshiftBulkExec (COPY)
Additionally, file management, job management, incremental load flag etc etc.