17.10 - Examples: CREATE FOREIGN TABLE and READ_NOS Queries - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1214-171K
Language
English (United States)

CREATE FOREIGN TABLE and READ_NOS Queries

The following examples show CREATE FOREIGN TABLE and READ_NOS queries with TABLE_FORMAT NVP as DELTALAKE, MANIFEST NVP set to TRUE and the location of the manifest file inside the _symlink_format_manifest folder.

CREATE FOREIGN TABLE is used to create a manifest table. The table is created using the data files from the manifest files in the given location.

create foreign table dl_table1
,EXTERNAL SECURITY INVOKER TRUSTED test0
USING
( LOCATION  ('/s3/s3.amazonaws.com/testdeltalake/deltalakewp/_symlink_format_manifest')
MANIFEST('TRUE')
TABLE_FORMAT('DELTALAKE')
);

 *** Table has been created. 
 *** Total elapsed time was 4 seconds.
+---------+---------+---------+---------+---------+---------+---------+--------+

show table dl_table1;

 *** Text of DDL statement returned. 
 *** Total elapsed time was 1 second.
--------------------------------------------------------------------------------

CREATE MULTISET FOREIGN TABLE dl_table1 ,FALLBACK ,
     EXTERNAL SECURITY INVOKER TRUSTED TEST0 ,
     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/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;
SELECT * FROM dl_table1;

 *** Query completed. 61 rows found. 8 columns returned. 
 *** Total elapsed time was 6 seconds.

Location
---------------------------------------------------------------------------------------------
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00003-e4c7c3cb-7aa0-4814-85e2-4683c1cec53e.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340b7d4.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00003-e4c7c3cb-7aa0-4814-85e2-4683c1cec53e.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340b7d4.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340b7d4.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a72d9a.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04baac.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbdc2cb.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39a598.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5ccec.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04baac.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd8a72.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04baac.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd8a72.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab8901.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e53653984f5.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04baac.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd8a72.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00001-09b48cd3-5c6a-467a-a63a-134c752cdede.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b960bcc.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00001-09b48cd3-5c6a-467a-a63a-134c752cdede.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b960bcc.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a383400d1.c000.snappy.par
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b960bcc.c000.snappy.par
SELECT street FROM dl_table1;

 *** Query completed. 61 rows found. One column returned. 
 *** Total elapsed time was 3 seconds.

street
----------------------
3536 SUN MAIDEN WAY
3828 BLACKFOOT WAY
3361 ALDER CANYON WAY
4437 MITCHUM CT
8716 LONGSPUR WAY
1207 CRESCENDO DR
1675 VERNON ST Unit 8
318 ANACAPA DR
5712 MELBURY CIR
3318 DAVIDSON DR
7921 DOE TRAIL WAY
8020 WALERGA RD
7837 ABBINGTON WAY
140 VENTO CT
7641 ROSEHALL DR
448 ELMWOOD CT
4085 COUNTRY DR
8721 SPRUCE RIDGE WAY
4636 TEAL BAY CT
4508 OLD DAIRY DR
4008 GREY LIVERY WAY
633 HANISCH DR
9197 CORTINA CIR
7863 CRESTLEIGH CT
4741 PACIFIC PARK DR
5312 MARBURY WAY
3305 RIO ROCA CT
7895 CABER WAY
652 FIFTEEN MILE DR
5708 RIDGEPOINT DR
5308 MARBURY WAY
8108 FILIFERA WAY
8316 NORTHAM DR
4712 PISMO BEACH DR
308 ATKINSON ST
6709 ROSE BRIDGE DR
4509 WINJE DR
7901 GAZELLE TRAIL WAY
4240 WINJE DR
3228 BAGGAN CT
227 MAHAN CT Unit 1
7697 ROSEHALL DR
201 FIRESTONE DR
2981 WRINGER DR
3604 KODIAK WAY
8428 MISTY PASS WAY
37 WHITE BIRCH CT
167 VALLEY OAK DR
3930 ANNABELLE AVE
8636 LONGSPUR WAY
4844 CLYDEBANK WAY
1675 VERNON ST Unit 24
281 SPYGLASS HL
1975 SIDESADDLE WAY
3212 CORNICHE LN
506 BEDFORD CT
419 DAWNRIDGE RD
1407 TIFFANY CIR
1786 PIEDMONT WAY
624 HOVEY WAY
500 WINCHESTER CT
SELECT * FROM (  LOCATION='/s3/s3.amazonaws.com/testdeltalake/deltalakewp/_symlink_format_manifest'
AUTHORIZATION=test1 MANIFEST='TRUE' TABLE_FORMAT='DELTALAKE') as dt;

 *** Query completed. 61 rows found. 8 columns returned.
 *** Total elapsed time was 44 seconds.

Location
----------------------------------------------------------------------------------------------------
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00009-70377ec9-23db-4c9b-9c1f-50bf90a7
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00007-1ca7a971-5117-46b4-85b2-c7752bbd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00006-917150c3-054a-4ac7-a4ea-0ba96b39
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00003-e4c7c3cb-7aa0-4814-85e2-4683c1ce
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00003-e4c7c3cb-7aa0-4814-85e2-4683c1ce
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00005-0d48136f-25b1-4ee7-b754-b6d47dab
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00002-00c3c9b4-fc91-4762-8724-d1f7cdcd
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00002-83b8aad2-9d4a-4cef-ac9a-acb07340
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00008-f6f1e0f6-5ccd-48ff-97f0-b2d427b5
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00001-09b48cd3-5c6a-467a-a63a-134c752c
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95843/part-00004-66a61240-33fd-4fba-8bd1-5e536539
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00001-09b48cd3-5c6a-467a-a63a-134c752c
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00001-79ff7696-ba19-48fc-bbb4-842fbe04
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95678/part-00000-a1f8f541-c0b2-44ad-bfef-447a3834
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b96
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b96
/S3/s3.amazonaws.com/testdeltalake/deltalakewp/zip=95661/part-00000-0ab15a43-e3b4-4832-8775-d3db4b96