5 Replies Latest reply on Nov 15, 2012 2:35 AM by Jurgen Schepens

    Extended Loading Metadata Running Time

    gall3on

      Hi,

       

      I'm connecting via sql to a work database using the following syntax:

       

      select

       

      CAST(acd_start_date_time AS DATE) 'Date Call',

      left(caller_ani,3) 'Area Code',

      count (1) as 'Switch Calls',

      count (talk_start_date_time) as 'Agent Calls'

       

      FROM db1 A

      left join db2 B

      On A.dial_id = B.dial_id

      where A.campaign_id = 'inbound' and A.acd_start_date_time is not null

       

      GROUP BY CAST(acd_start_date_time AS DATE), left(caller_ani,3)

       

      Running this query in SQL server takes less than a minute.  However, as I try to run this in Tableau it's going on 10+ minutes already, with the Loading Metadata status.

       

      Should this be happening?