PinnedInGoogle Cloud - CommunitybyAbhik Saha·Nov 23, 2024BigQuery Pipe Syntax — A Simplified SQL JourneyIntroduction
InGoogle Cloud - CommunitybyAbhik Saha·Feb 17, 2024Image to Task Translator using Multimodal Gemini Vision-ProIn today’s fast-paced world, the need to streamline complex processes efficiently is paramount. However, one of the challenges faced by…
InGoogle Cloud - CommunitybyAbhik Saha·Jun 20, 2023Implementing BigQuery Custom Mail Trigger: Responding to Errors with Automated NotificationsThis article dives further on error handling in BigQuery. If you haven’t already read the article, please go through it for reference…
InTowards DevbyAbhik Saha·May 28, 2023Part 1 -Dynamic Unpivoting in BigQueryDynamic unpivoting is a technique used to transform columns into rows in a table based on the data present. It is a process opposite to…
InTowards DevbyAbhik Saha·May 9, 2023Cloud Workflows in Google Cloud PlatformCloud Workflows is a fully managed service offered by Google Cloud Platform (GCP) that enables you to build and run serverless workflows…
Abhik Saha·May 7, 2023Scheduling BigQuery Procedures using Cloud Scheduler/BQ Scheduled QueriesUsing Google Cloud SchedulerA response icon1A response icon1
Abhik Saha·May 1, 2023Execution Precedence in SQLExecution precedence in SQL refers to the order in which the various operators and functions are evaluated within an SQL statement. SQL…
InGoogle Cloud - CommunitybyAbhik Saha·Apr 27, 2023Creating BigQuery Table Snapshots DynamicallyA table snapshot in BigQuery is a way of preserving the contents of a table, referred to as the base table, at a specific moment in time…
Abhik Saha·Apr 24, 2023Dynamic Inserts in Google BigQueryImagine a scenario in which you need to transfer data from tables in your development/testing dataset to tables in your production dataset…
InGoogle Cloud - CommunitybyAbhik Saha·Apr 23, 2023Loading an Excel file automatically into BigQuery (using Python)If you want to load an excel file into Google Cloud BigQuery, you can follow the below manual approach: