CTEs(Common Table Expression) or Temporary Tables for Spark SQL
- 1. Introduction
- 2. CTE for short clean code & temp tables for re-usability
- 3. Conclusion
- 4. Recommended reading
1. Introduction
...
Similar Articles (10 found)
🔍 75.9% similar
What are Common Table Expressions(CTEs) and when to use them?
- Introduction
- Setup
- Common Table Expressions (CTEs)
- Performance comparison
- Tear...
🔍 59.0% similar
Over the past year, I’ve been writing about several back-to-the-basics topics, like extracting data via APIs and SFTP, and building solid data models....
🔍 58.0% similar
How to improve at SQL as a data engineer
- 1. Introduction
- 2. SQL skills
- 3. Practice
- 4. Conclusion
- 5. Further reading
- 6. References
1. Intro...
🔍 57.7% similar
Using Joins and Group Bys the right way for data warehousing
- 1. Introduction
- 2. Joins & Group bys are two of the most commonly used operations in ...
🔍 56.6% similar
How to create an SCD2 Table using MERGE INTO with Spark & Iceberg
- 1. Introduction
- 2. MERGE INTO is used to UPDATE/DELETE/INSERT rows into a target...
🔍 56.6% similar
SQL Anti-Patterns You Should Avoid
Introduction
Today, I will be talking about some of the common and high impact SQL anti-patterns I have seen from e...
🔍 56.5% similar
Advanced SQL is knowing how to model the data & get there effectively
- 1. Introduction
- 2. SQL techniques
- 3. Query optimization
- 4. Data modeling...
🔍 56.5% similar
25 SQL tips to level up your data engineering skills
- Introduction
- Setup
- SQL tips
- 1. Handy functions for common data processing scenarios
- 1.1...
🔍 56.4% similar
Hi, fellow future and current Data Leaders; Ben here 👋
I recently was skimming the data engineering subreddit and came across a post with a title that...
🔍 56.2% similar
3 Key techniques, to optimize your Apache Spark code
- Intro
- Distributed Systems
- Setup
- Optimizing your spark code
- Technique 1: reduce data shu...