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…2 min read·Apr 19, 2024----
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…2 min read·Sep 26, 2023----
Satyaprakash BommarajuTIL: Github Compare CommitsInteresting and short TIL .1 min read·Jul 16, 2023----
Satyaprakash BommarajuTIL: AWS Glue Dynamic Dataframe Tips toDf() — Use ResolveChoice for Mixed Data types in a columnResolveChoice to pick from among mixed data type3 min read·Feb 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 columns1 min read·Jan 6, 2023----
Satyaprakash BommarajuToday I Learnt : Pandas merge/concat Good linksApproaching Pandas in Python by reworking existing code presented a unique problem,1 min read·Dec 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.1 min read·Nov 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.1 min read·Sep 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 (…2 min read·Jul 13, 2022----
Satyaprakash BommarajuTIL : AWS S3 arn definitions in an IAM PolicyAn Interesting learning today courtesy of my colleague ( Tanuj Patel) was trying to understand how to define the right arns in a IAM policy1 min read·May 19, 2022----