Home › Glossary › LATERAL

GLOSSARY TERM

LATERAL

See it in the glossary A–Z

This keyword allows a subquery or table function to use columns from whatever precedes it in the join, for instance LATERAL variant_explode(...). NATURAL can't be used alongside it.

Read more: Databricks docs

In the Ultra Transcenders books

DBX-DEPDBX-GENAI

Each book explains LATERAL in context, with comparison tables and the common traps.

Terms in this definition

Related terms

See LATERAL in the full glossary