Aginity Script
I'm using aginity script to execute to file, but column headers are not included in the results. Is it possible to include them?
-
Official comment
Hi Alan,
That`s correct - there is no possibility to write the header now.
This feature is in our backlog already.
Cannot say when it appears in the product but we release a new version every 2 weeks.
So, keep using the product and don`t miss new updates and one day this feature will be there.
Comment actions -
Hi Sergey,
Using Aginity Pro 0.17.281
Greenplum connection
Example script is:
#+sql:output file:path 'c:/users/alan/desktop/backlog_list':delimiter ',':null_value 'NULL':quote_char '"':overwrite true#+beginSELECTi.pyid , substring(i.workbasket,1,2) as market , i.workbasket , i.pyfrom , i.pyto
FROMinteraction_main i
WHEREi.pystatuswork = 'Open' and substring(i.pyid,1,2) = 'I-' and substring(i.workbasket,1,2) is not NULL and substring(i.workbasket,1,2) <> 'TX'
ORDERBYmarket, i.workbasket, i.pyfrom;#+END -
Hi Jeff Schlitt,
Coud you please update the documentation https://aginity-documentation.readthedocs.io/projects/aginity-pro/en/latest/docs/Query_Panel/using_panel/#executing-to-a-file to include the ability to add the column headers, and how to compress to Zip?
Thanks
Jonathan
Please sign in to leave a comment.
Comments
4 comments