DuckDB tricks - renaming fields in a SELECT * across tables
How to use DuckDB's COLUMNS expression to automatically rename fields when using SELECT * across joined tables, avoiding ambiguous column names.
Robin Moffatt is a Principal DevEx Engineer and seasoned conference speaker with 15+ years of experience presenting at top events like QCon, Devoxx, Kafka Summit, and Strata. He shares insights on developer experience, distributed systems, and cloud technologies through his blog, YouTube, and public talks.
625 articles from this blog
How to use DuckDB's COLUMNS expression to automatically rename fields when using SELECT * across joined tables, avoiding ambiguous column names.
A monthly roundup of interesting links and articles about data engineering, databases, streaming tech, and data infrastructure.
Monthly roundup of news and resources in data streaming, stream processing, and the Apache Kafka ecosystem, curated by industry experts.
A guide on how to selectively disable Vale prose linting for specific sections within AsciiDoc documents, explaining two methods and common pitfalls.
An overview of Apache Flink CDC, its declarative pipeline feature, and how it simplifies data integration from databases like MySQL to sinks like Elasticsearch.
Monthly roundup of news and developments in data streaming, stream processing, and the data ecosystem, featuring Apache Flink, Kafka, and open-source tools.
Explores the core reasons for using Change Data Capture (CDC) to extract data from operational databases for analytics and other applications.
A monthly roundup of news, talks, and developments in data streaming, Apache Flink, Kafka, and related technologies from September 2024.
A recap of the 2024 Current conference on data streaming, covering keynotes, product updates, and talks on Apache Flink and related technologies.
A technical guide on configuring Apache Flink to write data to Delta Lake tables stored on S3, including required JARs and configuration steps.
A technical guide on troubleshooting S3 connectivity issues in Apache Flink SQL, focusing on configuration and common pitfalls.
A technical guide on using Apache Flink SQL to stream data from Apache Kafka into Apache Iceberg tables, including code examples.
A monthly roundup of news, articles, and developments in data streaming, stream processing, and related technologies like Apache Kafka, Flink, and Paimon.
A data professional shares their curated list of data tech blogs and explains their return to using RSS feeds to stay current in the field.
A developer troubleshoots a connection issue when using ngrok to expose a local Kafka service, ultimately discovering a DNS-related problem.
A guide to prevent AWS CLI from clearing the screen after displaying help or command output, using environment variables like MANPAGER and AWS_PAGER.
A developer's guide to troubleshooting common pitfalls and misconfigurations when setting up and using Apache Flink SQL with JDBC connectors.
A monthly roundup of news and resources on stream processing, Apache Flink, Kafka, and data engineering from industry experts.
Overview of Apache Flink sessions at Kafka Summit London 2024, covering streaming data processing, SQL, checkpoints, and AI integration.
A guide to using Apache Flink's SQL Gateway REST API for submitting and managing SQL jobs, including practical examples with Postman and HTTPie.