Writings.

  1. Scentbird Analytics 2.0. Migrate from Redshift to Snowflake. Redesign ETL process.

    As some of you may know I'm building analytics in Scentbird and my intial steps in building ETLs and choosing a data warehouse engine was not perfect. Initially, I'm a Java developer and I start that journey having zero experience in building data stack, I hope it gives me an…


  2. Timestamp to string conversion (Redshift vs Snowflake) issue

    Everyone faces some strange behavior in software products from time to time. Any software has bugs, so it does not surprise us much. However, in some case you facing not a clear but some kind of strange implementation that surprise you. I have such one from our Redshift to Snowflake…

    Snowflake redshift hascode DBT migration

  3. Connect Snowplow to Snowflake

    I have already mentioned that we are using Snowplow as our backbone system to collect our events. It was not mentioned that the last time setup Snowplow in pair Redshift was a long and awful ride. Mostly because of quite a bad Snowplow documentation and some mess with existing Snowplow…

    Snowplow AWS Snowflake Iglu

  4. Extracting data from Bigquery into Redsfhit

    Another morning, another challenge! :) This time I have to integrate data collected into Google Ads into our data warehouse based on Redshift. I started with Google and find several tricky ways to get data into Redshift. Some paid ETL services. Self-hosted script to capture data from Google Ads directly via…

    redshift bigquery ETL AWS GCS

  5. How do we build analytics system in Scentbird

    Couple month ago Scentbird have celebrated 2 years of building internal analytics system. I considered it is a time to start sharing our expirence with community and it was a theme of my HighLoad 2019 (the biggest conference in Russia regarding high load systems) speach. Here it is (in Russian)…

    Analytics Looker AWS Glue redshift DBT architecture