Category: Google

  • What is Reverse ETL?

    What is Reverse ETL?

    The data engineering industry has evolved from Extract, Transform, Load (ETL) to ELT, where raw data is copied from the source system loaded into a data warehouse or data lake and then transformed. The current trend is to adopt a new approach, called “reverse ETL,” the process of moving data from a data warehouse into third-party…

  • Types of Cloud Deployment Models and How They Benefit Businesses

    Types of Cloud Deployment Models and How They Benefit Businesses

    The fast development of the internet brought new ways in which businesses are conducted. What was unimaginable only a few years ago, today is the norm. Businesses around the globe have seen new opportunities and decided to grab them. One such opportunity is cloud computing. 

  • Should You Move Your Business To The Cloud?

    Should You Move Your Business To The Cloud?

    In the realm of technology, the cloud is a ubiquitous presence, yet it often mystifies individuals who are not well-versed in its intricacies. It’s perfectly understandable if you find yourself pondering what the cloud truly represents. Contrary to common misconceptions, the cloud is not a singular monolithic entity. Instead, it comprises a multitude of distinct…

  • Maritime noon report with Google Cloud Dataprep

    Maritime noon report with Google Cloud Dataprep

    I recently worked on an exciting project, the use case for the project was to make the maritime noon report data available in Google BigQuery, which sounds simple enough. However, there were a lot of requirements, from collecting application data from the Greenpeace fleet in different formats leveraging Cloud Functions and API calls, landing the…

  • Securing HTTP trigger in Google Cloud Functions

    Securing HTTP trigger in Google Cloud Functions

    In this how-to article, I’m going to show how you can secure your Google Cloud Platform (GCP) Functions HTTP trigger, it has not been that straightforward to secure HTTP trigger in Cloud Functions in the past HTTP triggers in GCP were publicly available. While this might be useful in a lot of scenarios, it’s also…

  • BigQuery federated queries against WordPress Cloud SQL Database

    BigQuery federated queries against WordPress Cloud SQL Database

    BigQuery has added a new feature, in which you can connect to a Cloud SQL instance and make federated queries. In this how-to, I will explain how I made an external connection from BigQuery, then using federated queries to query my cloud SQL WordPress database and made a Top Story report in Google Data Studio.

  • Migrate your WordPress local MySQL to Cloud SQL

    Migrate your WordPress local MySQL to Cloud SQL

    Regardless of where you hosting your WordPress site, you can use Cloud SQL to be your backend database. In this How-to, I will explain the steps I took to migrate from the WordPress local MySQL to Cloud SQL.

  • Using Secret Manager in a Google Cloud Function with Python

    Using Secret Manager in a Google Cloud Function with Python

    When you write a cloud function, you need to protect an API key, account information user id and password, or other sensitive data. In the Google Cloud Platform (GCP) you can use the Secret Manager a secure and convenient storage system that provides a central place and single source of truth to manage access, and…

  • Do you have the right tools for your data

    Do you have the right tools for your data

    As organizations chase the dream of a data-driven business, the data literacy gap continues to widen. Data is a gold mine that can help organizations drive growth and revenue.

  • Disable Billing for Google Cloud Project when billing exceeds the budget limit

    Disable Billing for Google Cloud Project when billing exceeds the budget limit

    In this article, I will explain how you can create a Google Cloud Platform (GCP) Cloud Function that you can use to cap the cost if the cost is higher than the budget the billing will be disabled.