Holistics jobs export

holistics-jobs-export.rb

require 'json'
require 'csv'

data = `pbpaste`
data = JSON.parse(data);nil
data = data.select{|d| d.dig('schedule', 'paused') == false && d['source_type'] == 'dbtable' };nil
keys = [
  'title', 
  'description',
  'src_db', # from_ds_name
  'src_table', # source_config.fqname
  'interval', # schedule.friendly_description
]

jobs = data.each_with_object([]) do |d, memo|
  memo << [d['title'], d['description'], d['from_ds_name'], d.dig('source_config', 'dbtable', 'fqname'), d.dig('schedule','friendly_description')]
end;nil

CSV.open('tmp/holistics-job.csv','w', write_headers: true, headers: keys) do |csv|
  jobs.each {|j| csv << j}
end;nil