Migrate dbcp-dev GCP project from Catalyst to Climate Partners org

deployment-gap-model-education-fund / deployment-gap-model

ETL code for the Deployment Gap Model Education Fund

https://www.deploymentgap.fund/

MIT License

6 stars 2 forks source link

Migrate dbcp-dev GCP project from Catalyst to Climate Partners org #205

Closed bendnorman closed 2 years ago

bendnorman commented 2 years ago

We are migrating the gcp project to climate partners org so they are the owners. This makes it easier for them if catalyst leaves the project for some reason.

I created a project in climate partners called dbcp-dev, the id is dbcp-dev-350818. I enabled BigQuery and the Google Maps Geocoding API.

This PR mostly changes some column names in eip_projects and eip_facilities to comply with Big Query.

TrentonBush commented 2 years ago

Looks good to me! I only didn't merge it because the dashboards are still connected to the Catalyst GCP. If I wanted to update that one, would I just change the line GCP_PROJECT_ID=dbc-dev in the local.env? Oh and the google maps API key

bendnorman commented 2 years ago

Yes if you want to run the ETL just change GCP_PROJECT_ID and API_KEY_GOOGLE_MAPS. For updating the dashboards you should be able to log in using the OAuth flow in tableau. Maybe we could hop on a call and work through the tableau dashboards.