Short for REPLACE TABLE AS SELECT; Databricks SQL users typically write CREATE OR REPLACE TABLE ... AS SELECT. Schema and rows are swapped for whatever the query returns, and Delta logs this as another version.
Also called REPLACE TABLE AS SELECT.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains RTAS in context, with comparison tables and the common traps.
Terms in this definition
- Databricks SQL
Brings warehousing to an Azure Databricks lakehouse. ANSI SQL runs against Delta tables using SQL warehouses, compute tuned for heavy query concurrency and BI tools.
- CRUD
Shorthand for create, read, update and delete, the four basic things you do with data. Data-plane roles in Azure Cosmos DB, for instance, authorise those operations on items.
- Schema
The middle part of a Unity Catalog name (
catalog.schema.table), grouping tables, views, volumes, functions and models inside a catalog. A grant on it covers everything in it now and later, and nothing inside can be reached withoutUSE SCHEMA. - RETURNS
States what a function gives back, as a type or a table, inside
CREATE FUNCTION. SQL functions can leave it out and have the type worked out from their body.