Ice PandainSelectFromStock transaction processing with ChatGPT and Code Interpreter (Part One)Seamless Program Development without Writing a Single Line of Code·4 min read·Aug 10, 2023----
Ice PandainSelectFromHow to Secure Your Airbyte Instance on GCP Using Identity-Aware ProxyIntroduction·7 min read·May 24, 2022----
Ice PandaHow to write custom functions for google sheet plugin with auto-completion and proper docstringsProblem Statement·3 min read·Dec 11, 2020----
Ice PandaHow to connect to Google CloudSQL Postgres with DBeaverUsing SSL/TSL with Cloud SQL in DBeaver·3 min read·Nov 29, 2020--1--1
Ice PandaPre-commit hooks claim files are modified but no changes are detected by GitI recently started using pre-commit hooks to format code before committing changes to Git repositories.·2 min read·Oct 16, 2020--1--1
Ice PandaHow to get the first row from each group with the maximum value of a particular column in BigQueryA tutorial with two solutions.·2 min read·Oct 6, 2020----
Ice PandaHow to select data from columns contain a substring from BigQueryHow to deal with the requests that ask for data from columns that contain a user-defined substring in the column name from BigQuery·3 min read·Sep 23, 2020----
Ice PandaMigrate data from Firestore to Cloud SQL on Google CloudIntroduction·4 min read·Sep 8, 2020--1--1
Ice PandaPost requests from Cloud Function have empty body and the workaroundIn the last post I talked about creating cross-project Pubsub topic and subscription on GCP. The subscription is a cloud function with an…·3 min read·Aug 2, 2020--1--1
Ice PandaHow to create PubSub subscriptions across two different GCP projectsI’m recently working on a PubSub subscription with a Cloud Function to process events generated by a PubSub topic in a different GCP…·4 min read·Jul 20, 2020--3--3