Deepak kumarBuilding an Election Result Q&A Bot Using Langchain, LLaMA-3.1, and Groq CloudElection seasons often bring a surge of curiosity about outcomes, trends, and statistics. Answering real-time queries on these results…Sep 29Sep 29
Deepak kumarEnhance Your Bigquery Platform Monitoring: with Custom AlertsIn BigQuery monitoring, our monitoring options are quite restricted, and transforming them into actionable insights poses significant…May 272May 272
Deepak kumarBigQuery Job DetailsIdentifying the list of jobs executed in Bigquery and their slots details —Mar 3Mar 3
Deepak kumarMSTeams notification for Bigquery long-running QueriesTo receive notifications on Teams for prolonged queries, various methods can be employed. However, in this instance, we will utilize Python…Nov 19, 20231Nov 19, 20231
Deepak kumarIntegration of chatgpt in google docs.There are two ways to integrate chatgpt in google docs. Chatgpt provides an extension of google docs that you can get from the extension…Apr 5, 2023Apr 5, 2023
Deepak kumarHow to update all sequences with the max value of the respective tableTo update/restart all sequences with their max value of the respective table. Such activity is often encountered in migration work or…Mar 12, 2023Mar 12, 2023
Deepak kumarinMediaAgility SparksAnalysis of New Delhi’s Legislative Assembly Elections, 2020 with Python, BigQuery, & Data StudioI applied my tech skills to a real-life use case. It was fun!Feb 23, 2020Feb 23, 2020
Deepak kumarinMediaAgility SparksWorking with Nested and Repeated fields in BigqueryWhen I moved from SQL server and started working on BigQuery, one of the striking differences was how BigQuery denormalized data, as…Dec 5, 20193Dec 5, 20193
Deepak kumarTranspose of Rows to Column in BigqueryWe have some string data based on row and column delimited in the column of big query table. It is not a good practice to store the data…Jan 26, 20192Jan 26, 20192