CETAS is the acronym for Create External Table As Select. This allow us to export the result of a select to an external table in different formats, such as PARQUET or CSV.
We can also convert the format from one external table to another. The SELECT used on the CETAS can be an external table query. In this way we would be converting files in a data lake from one format to another. For example, we could convert CSV files to PARQUET.
The following query is an example of CETAS:
CREATE EXTERNAL TABLE csvsampletables
WITH (
LOCATION = ‘filescsv/’,