May 02, 2024 at 10:30:38 AM
BigQuery has introduced Time Series functions, currently in preview, to simplify rounding timestamps and datetimes values. The new functions include DATE_BUCKET, DATETIME BUCKET, and TIMESTAMP_BUCKET, which are used to bucket dates, datetimes, and timestamps respectively. The example in the screenshot demonstrates grouping event_timestamps into 15-minute buckets using these functions.
The Only Digital Marketing Feed You'll Ever Need.
Stay informed your way. Tailored updates when and how you want them. 100% Free.
10,000+ Users
500+ Sources
1000+ Tools
Markifact is a Verified Tool. Want to get this badge? Contact us.
Marketing Workflows Powered by AI
Marketing Auditor is a Verified Tool. Want to get this badge? Contact us.
Automated audits for Google Ads and Analytics.
Generative AI-powered data intelligence platform
GA4 SQL is a Verified Tool. Want to get this badge? Contact us.
Generate GA4 BigQuery queries easily
Automated marketing solutions powered by your data
Automated cloud data pipelines, no coding needed
AI-powered analytics for agencies
Effortlessly centralize and move data from any source
