postgres_ads = {
    "ACCOUNTS": "SELECT COUNT(*) FROM PUBLIC.ADS_ACCOUNT;",
    "CAMPAIGNS": "SELECT COUNT(*) FROM PUBLIC.ADS_CAMPAIGN;",
    "AD_SETS": "SELECT COUNT(*) FROM PUBLIC.ADS_AD_SET;",
    "GOOGLE_ADGROUP_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM GOOGLE.ADGROUP_PERFORMANCE_REPORT;",
    "GOOGLE_AGE_RANGE_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM GOOGLE.AGE_RANGE_PERFORMANCE_REPORT;",
    "GOOGLE_CAMPAIGN_GROUP_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM GOOGLE.CAMPAIGN_GROUP_PERFORMANCE_REPORT;",
    "GOOGLE_GENDER_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM GOOGLE.GENDER_PERFORMANCE_REPORT;",
    "GOOGLE_GEO_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM GOOGLE.GEO_PERFORMANCE_REPORT;",
    "GOOGLE_BUDGET_HISTORY ": "SELECT COUNT(*) FROM GOOGLE.BUDGET_HISTORY;",
    "FACEBOOK_AGE_GENDER_DAILY_REPORT": "SELECT COUNT(*) FROM FACEBOOK.AGE_GENDER_DAILY_REPORT;",
    "FACEBOOK_AGE_GENDER_DAILY_REPORT_ACTIONS": "SELECT COUNT(*) FROM FACEBOOK.AGE_GENDER_DAILY_REPORT_ACTIONS;",
    "FACEBOOK_AGE_GENDER_DAILY_REPORT_CONVERSIONS": "SELECT COUNT(*) FROM FACEBOOK.AGE_GENDER_DAILY_REPORT_CONVERSIONS;",
    "FACEBOOK_AGE_GENDER_DAILY_REPORT_UNIQUE_ACTIONS": "SELECT COUNT(*) FROM FACEBOOK.AGE_GENDER_DAILY_REPORT_UNIQUE_ACTIONS;",
    "FACEBOOK_COUNTRY_DAILY_REPORT": "SELECT COUNT(*) FROM FACEBOOK.COUNTRY_DAILY_REPORT;",
    "FACEBOOK_COUNTRY_DAILY_REPORT_ACTIONS": "SELECT COUNT(*) FROM FACEBOOK.COUNTRY_DAILY_REPORT_ACTIONS;",
    "FACEBOOK_COUNTRY_DAILY_REPORT_CONVERSIONS": "SELECT COUNT(*) FROM FACEBOOK.COUNTRY_DAILY_REPORT_CONVERSIONS;",
    "FACEBOOK_COUNTRY_DAILY_REPORT_UNIQUE_ACTIONS": "SELECT COUNT(*) FROM FACEBOOK.COUNTRY_DAILY_REPORT_UNIQUE_ACTIONS;",
    "FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT": "SELECT COUNT(*) FROM FACEBOOK.PUBLISHER_PLATFORM_DAILY_REPORT;",
    "FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_ACTIONS": "SELECT COUNT(*) FROM FACEBOOK.PUBLISHER_PLATFORM_DAILY_REPORT_ACTIONS;",
    "FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_CONVERSIONS": "SELECT COUNT(*) FROM FACEBOOK.PUBLISHER_PLATFORM_DAILY_REPORT_CONVERSIONS;",
    "FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_UNIQUE_ACTIONS": "SELECT COUNT(*) FROM FACEBOOK.PUBLISHER_PLATFORM_DAILY_REPORT_UNIQUE_ACTIONS;",
    "FACEBOOK_AD_SET_HISTORY": "SELECT COUNT(*) FROM FACEBOOK.AD_SET_HISTORY;"
}

snowflake_ads = {
    "ACCOUNTS": "SELECT COUNT(*) FROM (SELECT ACCOUNT_ID FROM SYS.FACEBOOK_ADS_ACCOUNT UNION ALL SELECT ACCOUNT_ID FROM SYS.GOOGLE_ADS_ACCOUNT);",
    "CAMPAIGNS": "SELECT COUNT(*) FROM (SELECT CAMPAIGN_ID FROM SYS.FACEBOOK_ADS_CAMPAIGN  WHERE ACCOUNT_ID IN  (SELECT ACCOUNT_ID FROM SYS.FACEBOOK_ADS_ACCOUNT)  UNION ALL  SELECT CAMPAIGN_ID FROM SYS.GOOGLE_ADS_CAMPAIGN  WHERE CUSTOMER_ID IN  (SELECT ACCOUNT_ID FROM SYS.GOOGLE_ADS_ACCOUNT));",
    "AD_SETS": "SELECT COUNT(*) FROM (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET  WHERE ACCOUNT_ID IN  (SELECT ACCOUNT_ID FROM SYS.FACEBOOK_ADS_ACCOUNT)  AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.FACEBOOK_ADS_CAMPAIGN)  UNION ALL  SELECT AD_SET_ID FROM SYS.GOOGLE_ADS_AD_SET  WHERE CUSTOMER_ID IN  (SELECT ACCOUNT_ID FROM SYS.GOOGLE_ADS_ACCOUNT)  AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.GOOGLE_ADS_CAMPAIGN));",
    "GOOGLE_ADGROUP_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM EXP.GOOGLE_ADGROUP_PERFORMANCE_REPORT WHERE CAMPAIGN_ID IS NOT NULL AND CUSTOMER_ID IN  (SELECT ACCOUNT_ID FROM SYS.GOOGLE_ADS_ACCOUNT) AND AD_GROUP_ID IN  (SELECT AD_SET_ID FROM SYS.GOOGLE_ADS_AD_SET) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.GOOGLE_ADS_CAMPAIGN);",
    "GOOGLE_AGE_RANGE_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM EXP.GOOGLE_AGE_RANGE_PERFORMANCE_REPORT WHERE CAMPAIGN_ID IS NOT NULL AND CUSTOMER_ID IN  (SELECT ACCOUNT_ID FROM SYS.GOOGLE_ADS_ACCOUNT) AND AD_GROUP_ID IN  (SELECT AD_SET_ID FROM SYS.GOOGLE_ADS_AD_SET) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.GOOGLE_ADS_CAMPAIGN);",
    "GOOGLE_CAMPAIGN_GROUP_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM EXP.GOOGLE_CAMPAIGN_GROUP_PERFORMANCE_REPORT WHERE CAMPAIGN_ID IS NOT NULL AND CUSTOMER_ID IN  (SELECT ACCOUNT_ID FROM SYS.GOOGLE_ADS_ACCOUNT) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.GOOGLE_ADS_CAMPAIGN) AND BUDGET_ID IN  (SELECT ID FROM EXP.GOOGLE_BUDGET_HISTORY);",
    "GOOGLE_GENDER_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM EXP.GOOGLE_GENDER_PERFORMANCE_REPORT WHERE CAMPAIGN_ID IS NOT NULL AND CUSTOMER_ID IN  (SELECT ACCOUNT_ID FROM SYS.GOOGLE_ADS_ACCOUNT) AND AD_GROUP_ID IN  (SELECT AD_SET_ID FROM SYS.GOOGLE_ADS_AD_SET) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.GOOGLE_ADS_CAMPAIGN);",
    "GOOGLE_GEO_PERFORMANCE_REPORT": "SELECT COUNT(*) FROM EXP.GOOGLE_GEO_PERFORMANCE_REPORT WHERE CAMPAIGN_ID IS NOT NULL AND CUSTOMER_ID IN  (SELECT ACCOUNT_ID FROM SYS.GOOGLE_ADS_ACCOUNT) AND AD_GROUP_ID IN  (SELECT AD_SET_ID FROM SYS.GOOGLE_ADS_AD_SET) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.GOOGLE_ADS_CAMPAIGN);",
    "GOOGLE_BUDGET_HISTORY ": "SELECT COUNT(*) FROM EXP.GOOGLE_BUDGET_HISTORY WHERE CAMPAIGN_ID IS NOT NULL AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.GOOGLE_ADS_CAMPAIGN) AND ID IN  (SELECT BUDGET_ID FROM EXP.GOOGLE_CAMPAIGN_GROUP_PERFORMANCE_REPORT);",
    "FACEBOOK_AGE_GENDER_DAILY_REPORT": "SELECT COUNT(*) FROM EXP.FACEBOOK_AGE_GENDER_DAILY_REPORT WHERE CAMPAIGN_ID IS NOT NULL AND ACCOUNT_ID IN  (SELECT ACCOUNT_ID FROM SYS.FACEBOOK_ADS_ACCOUNT) AND ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.FACEBOOK_ADS_CAMPAIGN);",
    "FACEBOOK_AGE_GENDER_DAILY_REPORT_ACTIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_AGE_GENDER_DAILY_REPORT_ACTIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_AGE_GENDER_DAILY_REPORT_CONVERSIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_AGE_GENDER_DAILY_REPORT_CONVERSIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_AGE_GENDER_DAILY_REPORT_UNIQUE_ACTIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_AGE_GENDER_DAILY_REPORT_UNIQUE_ACTIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_COUNTRY_DAILY_REPORT": "SELECT COUNT(*) FROM EXP.FACEBOOK_COUNTRY_DAILY_REPORT WHERE CAMPAIGN_ID IS NOT NULL AND ACCOUNT_ID IN  (SELECT ACCOUNT_ID FROM SYS.FACEBOOK_ADS_ACCOUNT) AND ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.FACEBOOK_ADS_CAMPAIGN);",
    "FACEBOOK_COUNTRY_DAILY_REPORT_ACTIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_COUNTRY_DAILY_REPORT_ACTIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_COUNTRY_DAILY_REPORT_CONVERSIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_COUNTRY_DAILY_REPORT_CONVERSIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_COUNTRY_DAILY_REPORT_UNIQUE_ACTIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_COUNTRY_DAILY_REPORT_UNIQUE_ACTIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT": "SELECT COUNT(*) FROM EXP.FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT WHERE CAMPAIGN_ID IS NOT NULL AND ACCOUNT_ID IN  (SELECT ACCOUNT_ID FROM SYS.FACEBOOK_ADS_ACCOUNT) AND ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.FACEBOOK_ADS_CAMPAIGN);",
    "FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_ACTIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_ACTIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_CONVERSIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_CONVERSIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_UNIQUE_ACTIONS": "SELECT COUNT(*) FROM EXP.FACEBOOK_PUBLISHER_PLATFORM_DAILY_REPORT_UNIQUE_ACTIONS WHERE ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET);",
    "FACEBOOK_AD_SET_HISTORY": "SELECT COUNT(*) FROM EXP.FACEBOOK_AD_SET_HISTORY WHERE CAMPAIGN_ID IS NOT NULL AND ACCOUNT_ID IN  (SELECT ACCOUNT_ID FROM SYS.FACEBOOK_ADS_ACCOUNT) AND ADSET_ID IN  (SELECT AD_SET_ID FROM SYS.FACEBOOK_ADS_AD_SET) AND CAMPAIGN_ID IN  (SELECT CAMPAIGN_ID FROM SYS.FACEBOOK_ADS_CAMPAIGN);"
}


postgres_linkfire = {
    "DIM_LINKFIRE_LINK": "SELECT count(*) count FROM linkfire.dim_link;",
    "FACT_EVENT_FUNNEL": "SELECT sum(event_count) count FROM linkfire.fact_event_funnel_daily;",
    "DIM_REFERRER": "SELECT count(*) count FROM linkfire.dim_referrer;",
    "DIM_CAMPAIGN_LINK": "SELECT count(*) count FROM linkfire.dim_link_campaign;",
    "DIM_TERRITORY": "select 256 count"
}

snowflake_linkfire = {
    "LINKFIRE_IMPORT_LOG": "select count(*) from DELPHI_LINKFIRE.SYS.LINKFIRE_EXPORT_LOG where datediff(day, EXPORT_TIMESTAMP , current_date())  <= 2;",
    "DIM_LINKFIRE_LINK": "select count(*) count from DELPHI_LINKFIRE.LINKFIRE.DIM_LINKFIRE_LINK where LINKFIRE_LINK_URL is not null and convert_timezone('UTC', created_at) < (select max(EXPORT_TIMESTAMP_UTC) from DELPHI_LINKFIRE.SYS.LINKFIRE_EXPORT_LOG);",
    "FACT_EVENT_FUNNEL": "SELECT count(*) count FROM DELPHI_LINKFIRE.LINKFIRE.FACT_EVENT_FUNNEL WHERE LINKFIRE_LINK_ID not in (select LINKFIRE_LINK_ID from DELPHI_LINKFIRE.LINKFIRE.DIM_LINKFIRE_LINK where LINKFIRE_LINK_URL is null) and convert_timezone('UTC', created_at) < (select max(EXPORT_TIMESTAMP_UTC) from DELPHI_LINKFIRE.SYS.LINKFIRE_EXPORT_LOG) and TERRITORY_NAME in (select TERRITORY_NAME from DELPHI_LINKFIRE.LINKFIRE.DIM_TERRITORY where IS_VALID );",
    "DIM_REFERRER": "select count(*) count from DELPHI_LINKFIRE.LINKFIRE.DIM_REFERRER where convert_timezone('UTC', created_at) < (select max(EXPORT_TIMESTAMP_UTC) from DELPHI_LINKFIRE.SYS.LINKFIRE_EXPORT_LOG);",
    "DIM_CAMPAIGN_LINK": "SELECT count(*) count FROM DELPHI_LINKFIRE.LINKFIRE.DIM_CAMPAIGN_LINK dcl join (select CAMPAIGN_ID, ACCOUNT_ID, max(UPDATED_AT) as campaign_updated_at from DELPHI_ADS_DATA.SYS.FACEBOOK_ADS_CAMPAIGN group by CAMPAIGN_ID, ACCOUNT_ID union select CAMPAIGN_ID, CUSTOMER_ID as ACCOUNT_ID, max(UPDATED_AT) as campaign_updated_at from DELPHI_ADS_DATA.SYS.GOOGLE_ADS_CAMPAIGN group by CAMPAIGN_ID, ACCOUNT_ID) campaign on dcl.CAMPAIGN_ID = campaign.CAMPAIGN_ID join (select ACCOUNT_ID, UPDATED_AT as account_updated_at from DELPHI_ADS_DATA.SYS.GOOGLE_ADS_ACCOUNT union select ACCOUNT_ID,UPDATED_AT as account_updated_at from DELPHI_ADS_DATA.SYS.FACEBOOK_ADS_ACCOUNT) account on campaign.ACCOUNT_ID = account.ACCOUNT_ID;",
    "DIM_TERRITORY": "select count(*) count from DELPHI_LINKFIRE.LINKFIRE.DIM_TERRITORY"
}