> delta_0000000_0000000 ... > I am using Glue data catalog as metastore, so should there be any link up to > these tables from hive?
That would be why transactions are returning as 0 (there is never a transaction 0), because it is not using a Hive standard metastore. You might not be able to use transactional tables with a non-standard metastore, because DbTxnManager & DbLockManager might not be working without a DB. Looking at that, it looks like you will not be able to use transactional tables without using a proper Hive metastore backed by RDS. Cheers, Gopal