1. When Querying data from Big Query the TIMESTAMP...
# gooddata-cn
1. When Querying data from Big Query the TIMESTAMP is mapped to DATE and it does not support any granularity levels like hour, minute and second. As per documentation it does support the granularity. Can you clarify why is this limitation and how can we overcome this ? https://help.gooddata.com/doc/enterprise/en/data-integration/data-preparation-and-distribution/direct-data-distribution-from-data-warehouses-and-object-storage-services/gooddata-bigquery-integration-details https://www.gooddata.com/developers/cloud-native/doc/1.1/concepts/date/
Hi Guruprasad, how did you create the model (LDM)? Have you scanned your BigQuery and generated LDM or have you created LDM and mapped it to PDM manually? When you create Date dataset manually, by default TIME granularities are not checked. Even when you map DATE reference to TIMESTAMP column, granularities are not regenerated. You have to check TIME granularities manually in this case. Here is a screenshot of default granularities in DATE dataset created manually: