Data engineering salon. News and interesting reads about the world of data.
When we use the same schema approaches as Druid and Rockset, ClickHouse significantly outperformed both whilst using the cheaper AWS setup.
SQL’s UNION operation is not usually thought of as a means to boost performance.
Performing a migration is such a high adrenaline, stressful task.
Whether you are a developer, data analyst, QA engineer, DevOps person, or product manager - SQLite is a perfect tool for you.
We’re using dbt to simplify the management of the views and build more trust in the data we store in our data warehouse.
For archiving it is preferable to choose column based format and ORC.
We get a single binary.