KA Kandaanusha UNNEST in SQL UNNEST is a SQL function that expands a nested array or list into a set of rows. Each element of the array becomes a separate row in the…
HUM DSN VI Vinatara Pengalaman Magang Berdampak di Marica : Belajar dan Berkarya di Dunia UI/UX Mengikuti magang berdampak merupakan hal yang aku syukuri selama hidup, karena program ini merupakan satu satunya program dari pemerintah…
MKT TCH RA Rasiksuhail Power of SQL for JSON and String Arrays (1/2) Modern applications often deal with semi-structured data like JSON and arrays of strings. While traditional SQL databases were initially…
TCH SI Sim Delay · Mistertemp’s kitchen Our data migration from QLDB to DynamoDB How we migrated our production data from AWS QLDB to DynamoDB in one day with no downti
TCH MKT MA Martin Weitzmann · TDS Archive De-Nesting Google Analytics Data in BigQuery The proper way to flat tables
TCH IT Itsuki · AWS Tip AWS QuickSight: Handle Array Data Type It is really common for any dataset to have a column that fills with an array. However, if you have ever tried AWS QuickSight out, you will…
ECO SR Sradha Jana Resolving a unique real-time use-case with cross join and unnest to get the common data from… We all know the trivial definition of cross join, its helps to achieve cartesian product of two tables. In its simplest form an example of…
MDA TCH LE Leon Wei 7 Advanced SQL Techniques for Data Scientists in 2023 Advanced SQL techniques and strategies not only streamline the data analysis process but also help in generating valuable insights.