A Smooth Sea Never Made a Skillful Sailor

In today's discourse, we delve into the intricacies of accessing Snowflake via the Trino project. This article illuminates the seamless integration of Trino with Snowflake, offering a comprehensive analysis of its benefits and implications. Previous Articles Previous articles on Snowflake and Trino: SaaS Galore: Integrating CockroachDB with Confluent Kafka, FiveTran and Snowflake Data federation with CockroachDB and Presto Motivation A common query among potential adopters of Snowflake pertains to its compatibility with on-premise data and cloud platforms like Azure. In this article, we address this question head-on, exploring the feasibility of accessing Snowflake alongside on-premise data through the Trino project. Let's unravel the possibilities together. High Level Steps Deploy Trino in Docker Get a trial Snowflake account Connect the dots Conclusion Step by Step Instructions Navigating the landscape of data integration can be daunting, especially when...

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering CLI query stats, clone schemas quickly, distinguish which table IDs correspond to which table names, connect to non-default databases and copy columns between column families. Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Topics Topic 1: SHOW LAST QUERY STATISTICS Topic 2: Clone table definitions in bulk across schemas Topic 3: Quick way to map a table name to a table ID Topic 4: Changing default database for sql client Topic 5: Quick way to move a column from one Column Family to another Topic 1: SHOW LAST QUERY STATISTICS CockroachDB has a very user-friendly and helpful UI called DB Console. I like to refer to it when I debug query performance. We have a very useful Statements page which shows a statement overview, explain plan and execution stats. Little did I know CockroachDB has an und...