Functions, an algorithm, BigQuery, and the absence of frameworks

Abstract

In this article, we are going to explain how to solve the following problem: perform a data insertion in a BigQuery table using the Python programming language, when we cannot use frameworks, chatGPT, GitHub Copilot, etc., to obtain a solution. The solution focuses on developing a series of functions that allow us to validate the data types of the table fields involved in the insertion, order the data to be inserted and give them the required structure according to the data types present. For this, we also show the development of an algorithm focused on performing such processes.