LIST ARCHIVE
Applies to: 
Databricks Runtime 10.4 LTS and above
Lists the ARCHIVEs added by ADD ARCHIVE.
Syntax
LIST [ARCHIVE | ARCHIVES] [file_name [...]]
Parameters
-
file_name
Optional a name of an archive to list.
Examples
SQL
> ADD ARCHIVES /tmp/test.zip /tmp/test_2.tar.gz;
> LIST ARCHIVE;
file:/tmp/test.zip
file:/tmp/test_2.tar.gz
> LIST ARCHIVE /tmp/test.zip /some/random.tgz /another/random.tar;
file:/tmp/test.zip