CODEWITHSUNDEEP
sqlgoogle-bigquerylooker-studio
Daniel Ogunfadebo
Daniel Ogunfadebo

Reputation: 15

Date formatting from BigQuery to Data Studio

I'm trying to connect Google Analytics data from BigQuery for visualization in Data studio; I can't get the date formatted in a readable format in data studio.

I've tried using this reg expression:

REGEXP_EXTRACT(date, '..../*.')

but i still can't get it to work. The text format is '20210921'

Upvotes: 1

Views: 414

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172974

Use parse_date('%Y%m%d', date)

another option is cast(date as DATE format('YYYYMMDD'))

Upvotes: 1

Related Questions