SQL Synthetic Data: Generating realistic user timestamps in SQL How to generate timestamps in SQL that match realistic user behavior data.
SQL How to generate a series of numbers in SQL for Redshift, Azure, and Snowflake Generating a sequence of integers in Redshift, Azure, and Snowflake
SQL SQL Hack: How to join tables when the key is buried in a blob of text The SituationText blobs are a pain, but they are commonly used with data from email platforms, Salesforce, or dynamic UTMs. In these cases, the JOIN key is probably hidden in
SQL SQL Hack: How to get first value based on time without a JOIN or a Window Function? This is my favorite trick in SQL! If you are like me and have been working with data for a while, you have googled “how to get the first value