I ran below two command in VDP and python script (via JDBC driver), thry show different value, why? I want to have the python script running have the same return result as the VDP return result.
DESC VIEW view_1
VDP result: include name, expression, fields, query method, and so on
python retrun result: just have below things for each items:
('run_date', 'DATE', '91', None, None, None, False, False, False), ('reporting_date', 'TIMESTAMP', '93', '0', '0', None, False, False, False), ('entity_code', 'VARCHAR', '12', '5', None, '10', False, False, False), ...
How to make the python can also return the exact vql for a view? seems above result just some datatype for a view, I want the vql in VDP (no need for dependency view vql, just this view's vql is enough for me).
Thank you. Can you please reply it ASAP? thanks