SELECT COUNT(*) records, 'pinterest_ad_group'                                 tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_ad_group                                 UNION
SELECT COUNT(*) records, 'pinterest_ad_group_conversion_stats'                tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_ad_group_conversion_stats                UNION
SELECT COUNT(*) records, 'pinterest_ad_group_stats'                           tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_ad_group_stats                           UNION
SELECT COUNT(*) records, 'pinterest_ad_group_targeting_conversion_stats'      tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_ad_group_targeting_conversion_stats      UNION
SELECT COUNT(*) records, 'pinterest_ad_group_targeting_stats'                 tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_ad_group_targeting_stats                 UNION
SELECT COUNT(*) records, 'pinterest_advertiser'                               tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_advertiser                               UNION
SELECT COUNT(*) records, 'pinterest_audience'                                 tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_audience                                 UNION
SELECT COUNT(*) records, 'pinterest_board'                                    tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_board                                    UNION
SELECT COUNT(*) records, 'pinterest_campaign'                                 tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_campaign                                 UNION
SELECT COUNT(*) records, 'pinterest_campaign_conversion_stats'                tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_campaign_conversion_stats                UNION
SELECT COUNT(*) records, 'pinterest_campaign_stats'                           tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_campaign_stats                           UNION
SELECT COUNT(*) records, 'pinterest_location'                                 tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_location                                 UNION
SELECT COUNT(*) records, 'pinterest_pin'                                      tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_pin                                      UNION
SELECT COUNT(*) records, 'pinterest_pin_promotion'                            tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_pin_promotion                            UNION
SELECT COUNT(*) records, 'pinterest_pin_promotion_conversion_stats'           tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_pin_promotion_conversion_stats           UNION
SELECT COUNT(*) records, 'pinterest_pin_promotion_stats'                      tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_pin_promotion_stats                      UNION
SELECT COUNT(*) records, 'pinterest_pin_promotion_targeting_conversion_stats' tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_pin_promotion_targeting_conversion_stats UNION
SELECT COUNT(*) records, 'pinterest_pin_promotion_targeting_stats'            tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_pin_promotion_targeting_stats            UNION
SELECT COUNT(*) records, 'pinterest_preview'                                  tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_preview                                  UNION
SELECT COUNT(*) records, 'pinterest_tag'                                      tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_tag                                      UNION
SELECT COUNT(*) records, 'pinterest_user'                                     tableName, MAX(collection_timestamp) latest_timestamp FROM pinterest_user
;
SELECT COUNT (*), 'adwords_account'                      as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_account                       UNION
SELECT COUNT (*), 'adwords_ad'                           as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_ad                            UNION
SELECT COUNT (*), 'adwords_ad_lifetime_no_segment'       as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_ad_lifetime_no_segment        UNION
SELECT COUNT (*), 'adwords_ad_no_segment'                as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_ad_no_segment                 UNION
SELECT COUNT (*), 'adwords_ad_segment'                   as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_ad_segment                    UNION
SELECT COUNT (*), 'adwords_adgroup'                      as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_adgroup                       UNION
SELECT COUNT (*), 'adwords_adgroup_lifetime_no_segment'  as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_adgroup_lifetime_no_segment   UNION
SELECT COUNT (*), 'adwords_adgroup_lifetime_segment'     as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_adgroup_lifetime_segment      UNION
SELECT COUNT (*), 'adwords_adgroup_no_segment'           as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_adgroup_no_segment            UNION
SELECT COUNT (*), 'adwords_adgroup_segment'              as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_adgroup_segment               UNION
SELECT COUNT (*), 'adwords_adgroup_video_segment'        as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_adgroup_video_segment         UNION
SELECT COUNT (*), 'adwords_age_range'                    as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_age_range                     UNION
SELECT COUNT (*), 'adwords_audience'                     as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_audience                      UNION
SELECT COUNT (*), 'adwords_budget'                       as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_budget                        UNION
SELECT COUNT (*), 'adwords_campaign'                     as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_campaign                      UNION
SELECT COUNT (*), 'adwords_campaign_lifetime_no_segment' as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_campaign_lifetime_no_segment  UNION
SELECT COUNT (*), 'adwords_campaign_no_segment'          as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_campaign_no_segment           UNION
SELECT COUNT (*), 'adwords_gender'                       as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_gender                        UNION
SELECT COUNT (*), 'adwords_geo'                          as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_geo                           UNION
SELECT COUNT (*), 'adwords_placement'                    as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_placement                     UNION
SELECT COUNT (*), 'adwords_video'                        as name,MAX(etl_timestamp) AS latest_timestamp FROM adwords_video
;
SELECT COUNT(*) records,'facebook_action_carousel_breakdown'             tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_action_carousel_breakdown             UNION
SELECT COUNT(*) records,'facebook_action_product_breakdown'              tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_action_product_breakdown              UNION
SELECT COUNT(*) records,'facebook_ad'                                    tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad                                    UNION
SELECT COUNT(*) records,'facebook_ad_action'                             tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action                             UNION
SELECT COUNT(*) records,'facebook_ad_action_breakdown'                   tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action_breakdown                   UNION
SELECT COUNT(*) records,'facebook_ad_action_dco_breakdown'               tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action_dco_breakdown               UNION
SELECT COUNT(*) records,'facebook_ad_action_dma_breakdown'               tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action_dma_breakdown               UNION
SELECT COUNT(*) records,'facebook_ad_action_multiple_breakdown'          tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action_multiple_breakdown          UNION
SELECT COUNT(*) records,'facebook_ad_action_placement_breakdown'         tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action_placement_breakdown         UNION
SELECT COUNT(*) records,'facebook_ad_action_reaction_breakdown'          tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action_reaction_breakdown          UNION
SELECT COUNT(*) records,'facebook_ad_action_region_breakdown'            tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action_region_breakdown            UNION
SELECT COUNT(*) records,'facebook_ad_action_video_sound_breakdown'       tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_action_video_sound_breakdown       UNION
SELECT COUNT(*) records,'facebook_ad_insight'                            tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_insight                            UNION
SELECT COUNT(*) records,'facebook_ad_insight_breakdown'                  tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_insight_breakdown                  UNION
SELECT COUNT(*) records,'facebook_ad_insight_dco_breakdown'              tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_insight_dco_breakdown              UNION
SELECT COUNT(*) records,'facebook_ad_insight_dma_breakdown'              tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_insight_dma_breakdown              UNION
SELECT COUNT(*) records,'facebook_ad_insight_multiple_breakdown'         tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_insight_multiple_breakdown         UNION
SELECT COUNT(*) records,'facebook_ad_insight_placement_breakdown'        tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_insight_placement_breakdown        UNION
SELECT COUNT(*) records,'facebook_ad_insight_region_breakdown'           tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_insight_region_breakdown           UNION
SELECT COUNT(*) records,'facebook_ad_preview'                            tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_ad_preview                            UNION
SELECT COUNT(*) records,'facebook_adaccount'                             tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adaccount                             UNION
SELECT COUNT(*) records,'facebook_adcreative'                            tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adcreative                            UNION
SELECT COUNT(*) records,'facebook_adset'                                 tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset                                 UNION
SELECT COUNT(*) records,'facebook_adset_action'                          tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_action                          UNION
SELECT COUNT(*) records,'facebook_adset_action_breakdown'                tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_action_breakdown                UNION
SELECT COUNT(*) records,'facebook_adset_action_dma_breakdown'            tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_action_dma_breakdown            UNION
SELECT COUNT(*) records,'facebook_adset_action_multiple_breakdown'       tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_action_multiple_breakdown       UNION
SELECT COUNT(*) records,'facebook_adset_action_placement_breakdown'      tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_action_placement_breakdown      UNION
SELECT COUNT(*) records,'facebook_adset_action_reaction_breakdown'       tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_action_reaction_breakdown       UNION
SELECT COUNT(*) records,'facebook_adset_action_region_breakdown'         tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_action_region_breakdown         UNION
SELECT COUNT(*) records,'facebook_adset_action_video_sound_breakdown'    tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_action_video_sound_breakdown    UNION
SELECT COUNT(*) records,'facebook_adset_insight'                         tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_insight                         UNION
SELECT COUNT(*) records,'facebook_adset_insight_breakdown'               tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_insight_breakdown               UNION
SELECT COUNT(*) records,'facebook_adset_insight_dma_breakdown'           tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_insight_dma_breakdown           UNION
SELECT COUNT(*) records,'facebook_adset_insight_multiple_breakdown'      tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_insight_multiple_breakdown      UNION
SELECT COUNT(*) records,'facebook_adset_insight_placement_breakdown'     tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_insight_placement_breakdown     UNION
SELECT COUNT(*) records,'facebook_adset_insight_region_breakdown'        tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_adset_insight_region_breakdown        UNION
SELECT COUNT(*) records,'facebook_campaign'                              tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign                              UNION
SELECT COUNT(*) records,'facebook_campaign_action'                       tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_action                       UNION
SELECT COUNT(*) records,'facebook_campaign_action_breakdown'             tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_action_breakdown             UNION
SELECT COUNT(*) records,'facebook_campaign_action_dma_breakdown'         tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_action_dma_breakdown         UNION
SELECT COUNT(*) records,'facebook_campaign_action_multiple_breakdown'    tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_action_multiple_breakdown    UNION
SELECT COUNT(*) records,'facebook_campaign_action_placement_breakdown'   tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_action_placement_breakdown   UNION
SELECT COUNT(*) records,'facebook_campaign_action_reaction_breakdown'    tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_action_reaction_breakdown    UNION
SELECT COUNT(*) records,'facebook_campaign_action_region_breakdown'      tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_action_region_breakdown      UNION
SELECT COUNT(*) records,'facebook_campaign_action_video_sound_breakdown' tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_action_video_sound_breakdown UNION
SELECT COUNT(*) records,'facebook_campaign_insight'                      tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_insight                      UNION
SELECT COUNT(*) records,'facebook_campaign_insight_breakdown'            tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_insight_breakdown            UNION
SELECT COUNT(*) records,'facebook_campaign_insight_dma_breakdown'        tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_insight_dma_breakdown        UNION
SELECT COUNT(*) records,'facebook_campaign_insight_multiple_breakdown'   tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_insight_multiple_breakdown   UNION
SELECT COUNT(*) records,'facebook_campaign_insight_placement_breakdown'  tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_insight_placement_breakdown  UNION
SELECT COUNT(*) records,'facebook_campaign_insight_region_breakdown'     tablename,MAX(etl_timestamp) AS latest_timestamp FROM facebook_campaign_insight_region_breakdown