Home ยป gcp

gcp

Connect cumul.io to a MySQL Database

  • by
  • 4 min read

Being a little bit bored with the default visualization tools in R and Python, I decided to look into the available visualization tools that are out there in the data ecosystem. The Belgian visualization tool cumul.io focusses on integration in platforms, but it also seems like a solid entry-level visualization… 

Solved: “The caller does not have permission” – Using the API with a private Google Spreadsheet

Ahh, user rights. The cause and solution to all of life’s identification problems. In this blog post I explain how you can access (private) google spreadsheets using the Python gspread library. Before you get started: make sure you have administrator rights to the spreadsheets you are trying to work with.… 

Reading from and writing files to GCP Storage in an AI Platform job

  • by
  • 1 min read

When you’re trying to access a CSV file stored in Google Cloud Storage when submitting a job to AI Platform, your first reflex is probably to use pandas’ read_csv. However, this will produce the following error: ImportError: The gcsfs library is required to handle GCS files That’s because pandas is… 

Creating a GCP Service Account and linking it to your system

When you haven’t gone through the Google Cloud Platform authentication process in your development environment, you might run into the following error message. In this blog post, I explain how you can solve it. google.auth.exceptions.DefaultCredentialsError: Could not automatically determine credentials. Please set GOOGLE_APPLICATION_CREDENTIALS or explicitly create credentials and re-run the…