I need the command to get the table data size.
I need it to track the Aster-Teradata data transfer job progress, The Aster MR connector for Teradata (load_to_teradata/load_from_teradata) does not return any progress info, during the job processing.
The following SQL statements can be used (through ACT) to get database table sizes.
select schema, relname, sum(size_on_disk)::double as size_on_disk
from nc_tablesize_details(on (select 1) partition by 1)
group by 1, 2
order by 1, 2;
Teradata Database Connectors are processed a statements of the type “Teradata Import” and “Teradata Export”. They are displayed as such on the AMC Dashboards. The progress of these statements can be viewed in “Processes” Tab. Please see Section “Teradata-Aster Database Connector | AMC Support” in “Teradata_Aster_Big_Analytics_Appliance_Database_User_Guide” for more details