All metadata queries available for externally managed OTF tables are equally applicable to managed OTF tables. When using these functions on managed OTF tables, the table should be referenced using the three-dot notation (for example, datalakename.databasename.tablename) instead of the two-dot notation, following the same convention used for externally managed OTF tables.
The following four queries are applicable to Managed OTF (MOTF) Iceberg tables:
Select * from TD_SnapShots(ON ( FT4_MOTF_DATALAKE.motf_ut003u.motf1))d1;
*** Query completed. One row found. 5 columns returned.
*** Total elapsed time was 1 second.
snapshotId 7432980434935376960
snapshotTimestamp 2025-08-25 16:02:45
timestampMSecs 1756137765316
manifestList s3://otf-dml-testsuites-testbucket/pte46714375/ft4_motf_test/MOTF_UT003U/motf1/metadata/snap-7432980434935376960-2-40f11390-30c0-4282-ac4e-143f521990e6.avro
summary {"changed-partition-count":"0","total-records":"0","total-files-size":"0","total-data-files":"0","total-delete-files":"0","total-position-deletes":"0","total-equality-deletes":"0","iceberg-version":"Apache Iceberg unspecified (commit f8
Select * from TD_Manifests(ON ( FT4_MOTF_DATALAKE.motf_ut003u.motf1))d1;
*** Query completed. One row found. 7 columns returned.
*** Total elapsed time was 1 second.
snapshotId 2246721758884876009
snapshotTimestamp 2025-08-25 16:02:51
manifestList s3://otf-dml-testsuites-testbucket/pte46714375/ft4_motf_test/MOTF_UT003U/motf1/metadata/snap-2246721758884876009-2-d7403c41-967c-4c41-85db-6d2c7625c4e6.avro
manifestFile s3://otf-dml-testsuites-testbucket/pte46714375/ft4_motf_test/MOTF_UT003U/motf1/metadata/d7403c41-967c-4c41-85db-6d2c7625c4e6-m0.avro
manifestFileLength 7092
datafilecount 2
totalrowcount 12
SELECT * FROM TD_PARTITIONS(ON (MOTF_DDL2_LAKE1.motf_ddl2_usr1.OTF_TAB5)) D;
*** Query completed. One row found. 2 columns returned.
*** Total elapsed time was 1 second.
id name
----------- ------------------------------------------------------
1000 b_bucket
BTEQ -- Enter your SQL request or BTEQ command:
SEL * FROM TD_HISTORY(ON (MOTF_DATALAKE_DDL1_SNO_46804867_LAKE1.motf_ddl1_sno_46804867_us1.t1)) dt1;
*** Query completed. 2 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
id timestamp
-------------------- -------------------
6751282030660823455 2025-09-17 07:03:42
6201224338905223193 2025-09-17 07:03:53