Skip to content

BigQuery string literal error in TesseractΒ #9542

@itestyoy

Description

@itestyoy

Cube Tesseract generates queries like this with column names with double quotes, but for BigQuery, it is not a valid syntax.

WITH cte_0 AS (
  SELECT
    "tesseract".ad_unit `tesseract__ad_unit`
  FROM
    bi_data_export.cube_export__daily_analysis AS `tesseract`
  GROUP BY
    1
  ORDER BY
    1 ASC
),
cte_1 AS (
  SELECT
    `q_0`.`tesseract__ad_unit` `tesseract__ad_unit`,
    count(count("q_0"."tesseract__ad_unit")) OVER () `tesseract__cohort_user_count`
  FROM
    cte_0 AS `q_0`
  GROUP BY
    1
  ORDER BY
    2 DESC
),
Syntax error: Unexpected string literal "tesseract__ad_unit"

v.1.3.10
CUBEJS_TESSERACT_SQL_PLANNER: true

Metadata

Metadata

Assignees

No one assigned

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions