Nilesh KhandalkarBigQuery ‘Qualify’ — Streamlines FilteringThe QUALIFY clause in BigQuery is used to filter the results of a query based on the output of window functions. It’s similar to the…Aug 19Aug 19
Nilesh KhandalkarMigrating Teradata to BigQueryThis blog will give a quick summary for the process of transferring both schema and data from a Teradata data warehouse to BigQuery.Nov 16, 2023Nov 16, 2023
Nilesh KhandalkarGoogle Cloud Storage & Life Cycle ManagementThis article gives a glimpse of Google Cloud Storage Life Cycle Management for Google Cloud Storage.Aug 8, 2023Aug 8, 2023
Nilesh KhandalkarGoogle Earth EngineGEE or Google Earth Engine is a groundbreaking product that has been available for researches and government use for more than a decade…Mar 24, 2023Mar 24, 2023
Nilesh KhandalkarWhy Airflow?Intro: Apache Airflow is an open source platform to programmatically author, schedule and monitor workflows. In simple language Apache…Nov 26, 2022Nov 26, 2022
Nilesh KhandalkarGoogle Cloud Analytics HubSharing data is essential to foster a data driven culture, data exchanges can be private or public data exchanges. BigQuery is a powerful…Oct 20, 20221Oct 20, 20221
Nilesh KhandalkarData Engineering — Your SQL Best FriendsData Engineering is quiet vast and involves lot of different skills for specific tasks, however one common thing which every Data Engineer…Jul 14, 20221Jul 14, 20221
Nilesh KhandalkarChange Data Capture with GCP BigQueryChange data capture (CDC) refers to the process of identifying and capturing changes made to data in a database and then delivering those…May 19, 20221May 19, 20221
Nilesh KhandalkarBigQuery Cursor equivalent and Dynamic SQL.In Oracle, cursors plays major role in PL/SQL blocks or Procedures to iterate through the table or datasets, there was always a question…May 12, 2022May 12, 2022
Nilesh KhandalkarMS Teams with Cloud Composer for failure NotificationsThis article is specifically to explain how failure notifications can be sent to MS teams channel from cloud composer.Mar 16, 2022Mar 16, 2022