--- title: "Shubham Baldava (@shubham-olake) | Hashnode" description: "Helping companies to ingest and maintain the Apache Iceberg lakehouses. Read the latest articles by Shubham Baldava on Hashnode." url: "https://hashnode.com/@shubham-olake" --- @shubham-olake # Shubham Baldava @shubham-olake · San Francisco · Joined September 2024 Helping companies to ingest and maintain the Apache Iceberg lakehouses [Website](https://olake.io/) ### [Postgres to BigQuery CDC on BigLake: Where the Setup Stops, and the Exact Messages](https://olake-blog.hashnode.dev/postgres-to-bigquery-cdc-on-biglake-where-the-setup-stops-and-the-exact-messages?utm_source=hashnode&utm_medium=feed) Slot, service account, catalog, first query and change sync, with the message each stop returns and what clears it. 9 min read · [olake-blog.hashnode.dev](https://olake-blog.hashnode.dev/postgres-to-bigquery-cdc-on-biglake-where-the-setup-stops-and-the-exact-messages?utm_source=hashnode&utm_medium=feed) [38m ago](https://hashnode.com/posts/postgres-to-bigquery-cdc-on-biglake-where-the-setup-stops-and-the-exact-messages/6af4d0ad6be71b286f164931) ### [MySQL to Snowflake: A Binlog Pipeline in Order, With the Exact Error at Each Step](https://olake-blog.hashnode.dev/mysql-to-snowflake-a-binlog-pipeline-in-order-with-the-exact-error-at-each-step?utm_source=hashnode&utm_medium=feed) Binlog, token, first sync, first query and change sync, each with the error text it can produce and the fix. 9 min read · [olake-blog.hashnode.dev](https://olake-blog.hashnode.dev/mysql-to-snowflake-a-binlog-pipeline-in-order-with-the-exact-error-at-each-step?utm_source=hashnode&utm_medium=feed) [15h ago](https://hashnode.com/posts/mysql-to-snowflake-a-binlog-pipeline-in-order-with-the-exact-error-at-each-step/6af3ffe2408ea79733d51fa9) ### [Postgres to Snowflake CDC: Setup Notes and the Errors You Will Hit](https://olake-blog.hashnode.dev/postgres-to-snowflake-cdc-setup-notes-and-the-errors-you-will-hit?utm_source=hashnode&utm_medium=feed) Set up Postgres to Snowflake CDC with OLake and fix the errors you will hit: walsender, network policy, token exchange, stale rows, quoting. 7 min read · [olake-blog.hashnode.dev](https://olake-blog.hashnode.dev/postgres-to-snowflake-cdc-setup-notes-and-the-errors-you-will-hit?utm_source=hashnode&utm_medium=feed) [1d ago](https://hashnode.com/posts/postgres-to-snowflake-cdc-setup-notes-and-the-errors-you-will-hit/6af2e66670d7076d72e75a68) ### [How Deduplication in Clickhouse works? (Avoiding FINAL keyword for better performance)](https://olake.hashnode.dev/how-deduplication-in-clickhouse-works-avoiding-final-keyword-for-better-performance-clz8brdt5003q27xk9filzg9u?utm_source=hashnode&utm_medium=feed) ClickHouse is optimised for its ingestion and reading speed to make your data near-real time latency, some trade-offs are made. De-duplication is something that ClickHouse doesn't guarantee in normal table. There are several strategies in Clickhouse ... 4 min read · [olake.hashnode.dev](https://olake.hashnode.dev/how-deduplication-in-clickhouse-works-avoiding-final-keyword-for-better-performance-clz8brdt5003q27xk9filzg9u?utm_source=hashnode&utm_medium=feed) [Jul 30, 2024](https://hashnode.com/posts/how-deduplication-in-clickhouse-works-avoiding-final-keyword-for-better-performance-clz8brdt5003q27xk9filzg9u/6702abc8077e7ebb3cc54e2e) ### [Why Datazip chose Clickhouse to provide a managed data warehouse?](https://olake.hashnode.dev/why-datazip-chose-clickhouse-as-a-data-warehouse-clwno87e5001tp9qx4peefp35?utm_source=hashnode&utm_medium=feed) Datazip is on a mission to make data engineering obsolete. Data engineering space is going through massive transformation as need for data engineers is ever growing. But the amount of data engineers available is not growing with the same space. So we... 4 min read · [olake.hashnode.dev](https://olake.hashnode.dev/why-datazip-chose-clickhouse-as-a-data-warehouse-clwno87e5001tp9qx4peefp35?utm_source=hashnode&utm_medium=feed) [May 26, 2024](https://hashnode.com/posts/why-datazip-chose-clickhouse-as-a-data-warehouse-clwno87e5001tp9qx4peefp35/6702ac03da64e7a573985144)