Tableau bleuprintで大事だなと思ったことまとめ
URL
https://help.tableau.com/current/offline/ja-jp/tableau_blueprint.pdf
SELECT
s.name AS site_name,
COALESCE(SUM(w.size), 0) AS total_workbook_size,
COALESCE(SUM(d.size), 0) AS total_datasource_size,
COALESCE(SUM(w.size), 0) + COALESCE(SUM(d.size), 0) AS total_storage_size
FROM sites s
LEFT JOIN workbooks w ON s.id = w.site_id
LEFT JOIN datasources d ON s.id = d.site_id
GROUP BY s.name
ORDER BY total_storage_size DESC;