sql - 带有 SQL 查询的 Data Studio SYSTEM_ERROR 代码 13

Question

SELECT user_leads.id, 
       first_name                              AS 'Nombres', 
       last_name                               AS 'Apellidos', 
       ip                                      AS 'IP o número de telefono', 
       city                                    AS 'Ciudad', 
       state                                   AS 'Estado', 
       From_unixtime(user_leads.timestamp)     AS 'Fecha', 
       Count(wadmin.id)                        AS 'Total Grupos de Whatsapp (Admin)', 
       Coalesce(Group_concat(wadmin.name), '') AS 'Grupos de Whatsapp (Admin)', 
       lead_sources.name                       AS 'Fuente', 
       lead_statuses.name                      AS 'Status', 
       dw.session_id 
FROM   user_leads 
       LEFT JOIN dialogflow_sessions AS dw 
              ON dw.lead_id = user_leads.id 
       LEFT JOIN user_lead_global_fields AS gf_ans 
              ON gf_ans.leadid = user_leads.id 
       LEFT JOIN lead_sources 
              ON lead_sources.id = sourceid 
       LEFT JOIN lead_statuses 
              ON lead_statuses.id = user_leads.statusid 
       LEFT JOIN whatsapp_groups AS wadmin 
              ON wadmin.admin_lead_id = user_leads.id 
GROUP  BY user_leads.id 
ORDER  BY user_leads.id DESC

我目前正在使用该查询，这是我尝试过的

1. 删除特殊字符
2. 删除“as *”语句
3. 清除缓存
4. 更改 sql 数据源并仔细检查我的连接但什么也没有

有人遇到过这个问题吗？

标签： sqlgoogle-data-studio

Answer 1

找到了。Data Studio 不喜欢列别名中的空格，但它不会为它们显示任何错误。使用下划线替换别名中的所有空格的工作方式相同