This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Tag: Google Tips & Tricks
-
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 […]
-
Using Cloud Build as your CI/CO for multiple Cloud Functions
There are many CI/CO tools available in the market today like GitLab CI, CircleCI I’m not so much in favor of these CI/CO services even if they have some cool features. I have been a Google Cloud Platform user for a few years now, and I prefer to use the tools that are available to […]
-
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.
-
Useful GCP commands when working with multiple GCP domains
I have recently been working on multiple Google Cloud Platform (GCP) domains, I’m not referring to GCP project I talking about different GCP Domains. I have been working with moln.co and socialclimate.tech. When working with different GCP domains, I needed to switch back and forth between the GCP domains. I have listed a few commands […]
-
How to empty a table in BigQuery
BigQuery is the Google Cloud Platform data warehouse solution, and setting up datasets you have many options for importing data into a BigQuery table. There are times when you just want to empty a table, to import data again.
-
How to build a RESTful API data pipeline with a Firebase Cloud Function and BigQuery
In this article, I will show how I build a data pipeline with a Google Cloud Function. My use case, in this case, was to use a RESTful API to get the data from an external system and create new entries from the data and store it in BigQuery.
-
Creating a table in BigQuery with your Google Sheet data
Did you know that you can link your Google Sheet with a BigQuery table and that any chances that you make in your Google Sheet are automatically updated in the BigQuery table? If you read on, I will provide the instructions on how you can do this, first I will provide some of my views […]
-
Connecting your Google Sheet to an external MySQL database
I have been working on a Data Studio project that uses various data sources such as Google Sheet, BigQuery and an external MySQL database. During the project, I came across a few issues with data missing or a date being 0000-00-00 00:00:00 in the dataset, it was Data Studio that flagged a problem and gave […]
-
Google Sheet get currency exchange rate with GOOGLEFINANCE formula
Google Sheet get currency exchange rate with GOOGLEFINANCE formula
-
How to setup Google IoT core with BigQuery and an IoT sensor
In this how-to, I will show you how to set up an IoT sensor connects it to the Google Cloud Platform IoT core send the data to Google Cloud Pub/Sub. Then code a cloud function, that will wait for a pub/sub trigger and store the data in BigQuery and Firebase. This how-to if you go […]