Writings.

  1. Generating series in Redshift

    Redshift in 99% of cases means data warehouse, where generating series (especially date series) is quite a common case. You will be disappointed to find out no information about series in official documentation (the only thing that you will be able to find - "generate_series function is not…

    redshift AWS Analytics sql

  2. Running static Iglu repository on AWS S3

    During setuping Snowplow analytics systems I have to setup a private Iglu repository. The main idea behind this is described on (https://github.com/snowplow/iglu/wiki/Setting-up-an-Iglu-repository). That manual missed several steps that are really important for building Iglu repository on AWS infrastructure. I had spent a lot of…

    Snowplow AWS S3 Iglu Repository Analytics

  3. build-test-data plugin: how to generate IDs for domain entities in a batch

    I have faced an inssue on grails project: domain entities has assigned id, so in tests I have to manually set up id for every created entity: new Entity(id: id_value, ...).save() It is very verbose and creates additional task to create and maintain id variable. In addition, there…

    grails groovy build-test-plugin ID batch

  4. Typecasting in SQL could force database does not take into account index or sort column

    I faced this issue while working with Redshift. But it can be found in any SQL database engine. Redshift is known as special column database, that allows run query in parallel way that to distribution and sort key. Of course, the most widely used sort key is date and should…

    sql redshift timestamp postgres casting

  5. Crafting architecture solution at tech interview

    From time to time at technical interviews, your can face with architecture tasks. The main aim of such tasks to find out your ability to create scalable and solid solutions with attention to bottlenecks. Moreover, such task gives an opportunity to understand of your outlook with modern tools and frameworks.…

    interview architecture high-load scalability amazon services