title: How to extract data from oracle database and save in Google cloud platform
body: <p>Need to extract the data from oracle database and stored in Google cloud platform. Data is around 10 TB. Is it possible through Spark? Data has to transfer monthly once. Data to be stored and processed in GCP as follows :</p>
  
  <p>Oracle database to Cloud storage (not has to do CSV Export) then it will be clean and prepared in Dataprep which will be further process through Dataflow and then last it will be get stored under Big Query (from big query data scientist will use data for their model creation). </p>
  
  <p>No third party tool to be used during this. Any open source tool is allowed. </p>
  
  <p>I am thinking to extract data from spark (though use of DataProc for spark job) and store it in GCP (any one Cloud storage or big table or big query). Through cloud sql - it is not possible, since it does not support for oracle database. </p>
  
  <p>Any new architecture is also fine, if my above logic is wrong. Please suggest. 
  Thank you. </p>