Published inGoogle Cloud - Community·Feb 26Member-onlyAutomating table backups in VertexAI training tasks — through BigQueryDiscover the advantages and the necessity of backing up a table during its usage in a VertexAI training task. We at REEA implemented an automated approach by utilizing Cloud Workflows to retain the tables used in a training task, with the objective of preserving the exact records for future analysis. …Vertex AI9 min readVertex AI9 min read
Dec 25, 2022Implementing trademark availability and search using USPTO Trademark API — part 2Trademarks are a valuable business asset that can help distinguish your brand and products from those of your competitors. As such, it’s important to choose a trademark that is not only unique and memorable but also available for use. …Trademark4 min readTrademark4 min read
Published inGoogle Cloud - Community·Mar 3, 2022Member-onlyIntegrating DockerSlim container minify step on Cloud BuildWhenever we are dealing with containers, the general recommendation is to make them leaner, smaller, faster, and secure. The smaller the container image is, the faster your application will spin up for the first time, and the faster it will scale. But more on this topic, the industry weighs the…Google Cloud Platform7 min readGoogle Cloud Platform7 min read
Published inGoogle Cloud - Community·Feb 9, 2022Member-onlyReduce your BigQuery bills with BI Engine capacity orchestrationLearn how we at REEA are orchestrating BI Engine reservations by dynamically changing allocation size based on usage using Cloud Workflows on a 5TB dataset, considered small for BigQuery but with big cost savings and accelerated queries. This article resulted from my experience at REEA, and as GDE on Stackoverflow…Google Cloud Platform10 min readGoogle Cloud Platform10 min read
Jan 23, 2022USPTO Trademark API — Search trademark & owner database — part 1In this article, we will describe how to use USPTO Trademark API service to execute trademark keywords search, owner search, or check if a trademark keyword is available. USPTO Trademark API is available on RapidAPI Hub, it’s an unofficial REST API for accessing the United States Patent and Trademark Office…Rest Api5 min readRest Api5 min read
Published inGoogle Cloud - Community·May 18, 2021Member-onlyAutomate the execution of BigQuery queries with Cloud WorkflowsResolve repetitive queries with scheduled invocations, combine simple queries to complex DML statements by using Cloud Workflows instead of BigQuery Scripting. SQL pipelines! In this article, we will explore how to use Workflows Connectors to run BigQuery query pipelines to execute a query, retrieve query results, loop through the resultset…Google Cloud Platform4 min readGoogle Cloud Platform4 min read
Published inGoogle Cloud - Community·Feb 15, 2021Member-onlyFirestore Backups the easy way with Cloud WorkflowsBackup every night your Firestore collections to secure Cloud Storage the easy way with Cloud Workflows, you don’t need to be a developer to setup the steps. Database Backups! We know how important they are, a wrong click and someone could delete your collection or the entire database. …Google Cloud Platform7 min readGoogle Cloud Platform7 min read
Published inGoogle Cloud - Community·Dec 11, 2020Member-onlyRun shell commands and orchestrate Compute Engine VMs with Cloud WorkflowsAutomate the execution of shell commands in a fully serverless and secure way without managing private keys. What a joy for a Cloud Architect to work with. Sometimes, as part of a workflow process, it is necessary to connect to a VM in order to perform different tasks. We are…Google Cloud Platform7 min readGoogle Cloud Platform7 min read
Published inGoogle Cloud - Community·Nov 30, 2020Member-onlyUsing Cloud Workflows to load Cloud Storage files into BigQueryIn this article, we will orchestrate and automate Google Cloud with serverless workflows. We will create a Cloud Workflow to load data from Google Storage into BigQuery. …Google Cloud Platform6 min readGoogle Cloud Platform6 min read
Published inGoogle Cloud - Community·Nov 10, 2020Introducing “GCP Project Switcher” Extension for VS Code — My Weekend ProjectWriting, debugging and deploying from Visual Studio Code for Google Cloud Platform is working out great as you have multiple options to interact with Google Cloud products: the Terminal pane, to use the gcloud command-line tool by using VSCode Tasks to automate commands [my setup] Cloud Code toolbox All these…Vscode3 min readVscode3 min read