How to troubleshoot the error “This report does not support the partitioning type used in table”?

To generate reports, Smart Data queries Google BigQuery data using standard SQL as a default dialect. It is because standard SQL has much more features than legacy SQL and is compatible with date partitioned tables, in which we recommend storing your CRM data.

However, some reports still work based on legacy SQL we used at the earlier stages of Smart Data development. Due to technical limitations, legacy SQL can’t query the date partitioned tables. That is why, when you run the legacy query against date partitioned tables, the error “This report does not support the partitioning type used in table {table name}” occurs.

Yet, there is a solution we will outline below:

• go to Google BigQuery and create the copy of the table given in the error message;
• partition the copied table based on Ingestion time;
• create a new data source set in Smart Data, then add the copied table there;
• build the report using the newly created data source set.