{"id":10203,"date":"2023-07-06T21:46:00","date_gmt":"2023-07-07T02:46:00","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=10203"},"modified":"2023-08-02T14:12:19","modified_gmt":"2023-08-02T19:12:19","slug":"tableau-postgresql-query-stats-about-data-source-types","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=10203","title":{"rendered":"Tableau PostgreSQL Query: Stats About Data Source Types"},"content":{"rendered":"\n<p>I wanted to report on the different types of data sources used in our Tableau instance &#8212; as well as show how many of each type are in use. <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- Query to found how many of each data source type\nselect datasources.db_class, count(datasources.db_class) as count\nfrom datasources\nleft outer join users on users.id = datasources.owner_id\nleft outer join system_users on users.system_user_id = system_users.id\nleft outer join sites on datasources.site_id = sites.id\nleft outer join projects on datasources.project_id = projects.id\nleft outer join workbooks on datasources.parent_workbook_id = workbooks.id\ngroup by datasources.db_class \norder by count desc ;\n<\/pre><\/div>\n\n\n<p>Answer: About half of them are Oracle!<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2023\/08\/TableauDatasourceStats.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"580\" data-id=\"10204\" src=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2023\/08\/TableauDatasourceStats-1024x580.png\" alt=\"\" class=\"wp-image-10204\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2023\/08\/TableauDatasourceStats-1024x580.png 1024w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2023\/08\/TableauDatasourceStats-300x170.png 300w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2023\/08\/TableauDatasourceStats-768x435.png 768w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2023\/08\/TableauDatasourceStats-750x425.png 750w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2023\/08\/TableauDatasourceStats.png 1048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/figure>\n","protected":false},"excerpt":{"rendered":"<p>I wanted to report on the different types of data sources used in our Tableau instance &#8212; as well as show how many of each type are in use. Answer: About half of them are Oracle!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1852],"tags":[1822],"class_list":["post-10203","post","type-post","status-publish","format-standard","hentry","category-tableau","tag-tableau"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10203"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10203\/revisions"}],"predecessor-version":[{"id":10205,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10203\/revisions\/10205"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}