Extract the workbook, export and import jobs as a text file

Follow

Ganesh Saptharishi

• May 17, 2021 11:06

For a clean up exercise, I would like to extract the current inventory of workbooks, export and import jobs.  I am not an admin and manually building this consumes time.  Any help is appreciated.

0

• Official comment

  

  Brian Junio

  • May 17, 2021 16:48

  Ganesh,

  Good morning!

  The best way to obtain this data will be to directly query Datameer's `dap` database which contains all of the requested details.  

  As you stated, you are not an admin so it may not be possible for you to reach this database.  In this case, you will need to reach out to your Datameer administrator and have them return the output of the following query:

  SELECT dap_file.id Artifact_ID, 
    dap_file.name Name, 
    CASE dap_file.extension
      WHEN 'DATA_STORE_EXTENSION' THEN 'Connection'
      WHEN 'UPLOAD_JOB_EXTENSION' THEN 'FileUpload'
      WHEN 'IMPORT_LINK_JOB_EXTENSION' THEN 'Datalink'
      WHEN 'IMPORT_JOB_EXTENSION' THEN 'ImportJob'
      WHEN 'WORKBOOK_EXTENSION' THEN 'Workbook'
      WHEN 'INFOGRAPHIC_EXTENSION' THEN 'Infographic'
      WHEN 'EXPORT_JOB_EXTENSION' THEN 'ExportJob'
      END Artifact_Type,
    permission.owner Owner
  FROM dap_file
  INNER JOIN permission on dap_file.permission_fk = permission.id
  WHERE dap_file.extension LIKE '%EXTENSION%' AND dap_file.file_mode = 'NORMAL';

  If they were to save this dataset as a CSV file, you could then upload it to Datameer for further analysis. 

  If you have any questions, please let me know!

  Cheers,

  Brian

  Comment actions Permalink
• 

  Konsta Danyliuk

  • May 18, 2021 08:07
  • Edited

  Hello Ganesh.
  You could also set up a Connection to the Datameer database, import data from desired tables, and then build the analysis in a Workbook. Please check the KB article How to Create Import Jobs to Import Datameer dap Database Data for more details.

  0

  Comment actions Permalink

Please sign in to leave a comment.