Search code examples
sqlgoogle-bigquerylooker-studio

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'

Solution

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

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