Datameer DAP DB table to get schema details for export job


1 comment

  • Konsta Danyliuk

    Hello Trupti.

    At Datameer 7.2 one could get list of column names for a certain Workbook's Sheet from the table sheet_column. Below query will return the list of columns, based on a Workbook's configuration ID and the name of the Sheet you use as an ExportJob source.

    SELECT name FROM sheet_column WHERE sheet_fk = (SELECT id FROM sheet WHERE workbook_fk = <Workbook's ConfID> AND name = "<Desired Sheet name>") GROUP BY;

    Hope this is something you are looking for.

    Comment actions Permalink

Please sign in to leave a comment.