Example: Creating Delta Lake Table - Teradata VantageCloud Lake

CREATE FOREIGN TABLE Statement

CREATE FOREIGN TABLE delta_lake_table,
  EXTERNAL SECURITY INVOKER TRUSTED test0
  USING (
    LOCATION ('/S3/YOUR-BUCKET.s3.amazonaws.com/testdeltalake/deltalakewp/_symlink_format_manifest')
    MANIFEST ('TRUE')
    TABLE_FORMAT ('DELTALAKE')
  );

SHOW TABLE Statement

SHOW TABLE delta_lake_table;

Result:

CREATE MULTISET FOREIGN TABLE NOS_USR.delta_lake_table ,FALLBACK ,
     EXTERNAL SECURITY INVOKER TRUSTED
     MAP = TD_MAP1
     (
      Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
      street VARCHAR(22) CHARACTER SET UNICODE NOT CASESPECIFIC,
      state VARCHAR(2) CHARACTER SET UNICODE NOT CASESPECIFIC,
      bedrooms INTEGER,
      bathrooms INTEGER,
      sqft INTEGER,
      types VARCHAR(11) CHARACTER SET UNICODE NOT CASESPECIFIC,
      price INTEGER)	
USING
(
      LOCATION  ('/S3/YOUR-BUCKET.s3.amazonaws.com/testdeltalake/deltalakewp/_symlink_format_manifest')
      MANIFEST  ('TRUE')
      TABLE_FORMAT ('DELTALAKE')
      PATHPATTERN  ('$var1/$zip/$var3')
      STOREDAS  ('PARQUET')
)
NO PRIMARY INDEX
PARTITION BY COLUMN ADD 65524 ;