Satyaprakash BommarajuTIL : Space in CSV header name and parquet conversion exceptionAn interesting learning today; a member of my team was sharing a parquet file generated out of a CSV, that was not being read by any tool…Apr 19Apr 19
Satyaprakash BommarajuTIL: AD Get Active Users ListA Completely new learning for me in a technology rarely used by me. A sudden outage in a AD mailer and Power BI forced me to investigate a…Sep 26, 2023Sep 26, 2023
Satyaprakash BommarajuTIL: AWS Glue Dynamic Dataframe Tips toDf() — Use ResolveChoice for Mixed Data types in a columnResolveChoice to pick from among mixed data typeFeb 18, 2023Feb 18, 2023
Satyaprakash BommarajuTIL : PowerBI powerquery appends suffixes to duplicate column names in the resultsetAn interesting problem today, a couple of us were looking at a PowerBI report and in the .pbix file in the table view there were columnsJan 6, 2023Jan 6, 2023
Satyaprakash BommarajuToday I Learnt : Pandas merge/concat Good linksApproaching Pandas in Python by reworking existing code presented a unique problem,Dec 13, 2022Dec 13, 2022
Satyaprakash BommarajuTIL : Kubernetes follow logs across all deployed podsI am always fascinated by how much I can learn everyday, its interesting to keep absorbing new information.Nov 7, 2022Nov 7, 2022
Satyaprakash BommarajuTIL : Presto SQL JSON FunctionsToday was interesting learning, there was a requirement to extract a value from a JSON string column from Amazon Athena.Sep 22, 2022Sep 22, 2022
Satyaprakash BommarajuTIL : PostgreSQL regexp_split_to_table conversion to Presto: SQL compatible outputInteresting problem today had to convert a sql that used a PostgreSql function called regex_split_to_table (…Jul 13, 2022Jul 13, 2022