Using Terraform and Google Cloud
• Create a Cloud SQL Progress Server with 2 databases (Schema will be provided)
• Create cloud functions for loading market data into the DB (Python Code to retrieve the data will be provided)
• Create a Jupyter notebook (offline - outside google cloud) with code for
○ Trigger above created cloud functions (also passing parameters).
○ Query the data from the above Cloud SQL DB into dataframe.
○ Write data to the Cloud SQL DB.
Specifications for Cloud Functions:
• They should accept parameters.
• They should be able to access CSV files in Cloud Storage.
More Details will be provided to interested parties.