cube-js / cube-js/cube

BigQuery pre-aggregations datetime error

Open
#9,495 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

Hi!
Cube (1.2.9) generates SQL to pre-aggregated table but doesn’t cast field to datetime
when we use filter by this member.

Image

```
pre_aggregations: PRE_AGGREGATIONS_ENABLED ? {
model__daily_analysis_rollup_by_activity: {
dimensions: (CUBE) => [
CUBE.app_name,
CUBE.cohort_date,

],
measures: (CUBE) => [
CUBE.count,
],

time_dimensions: [
{ dimension: (CUBE) => CUBE.cohort_date, granularity: 'day' },
{ dimension: (CUBE) => CUBE.cohort_date, granularity: 'week' },
{ dimension: (CUBE) => CUBE.cohort_date, granularity: 'month' },
{ dimension: (CUBE) => CUBE.cohort_date, granularity: 'quarter' },
{ dimension: (CUBE) => CUBE.cohort_date, granularity: 'year' },
],
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.