I am trying to creating an external table with Partition below is the reference image i am using.

[![enter image description here](https://i.stack.imgur.com/cFkQP.png)](https://i.stack.imgur.com/cFkQP.png)

Here is what i am intending to do :

I have files flowing into this folder:
[![enter image description here](https://i.stack.imgur.com/6dLKy.png)](https://i.stack.imgur.com/6dLKy.png)

I need to query the external table based on the date :

eg :

select \* from where \_PartitionDate ='';

My specific query is what should i fill in the GCS bucket & source Data partitioning fields.

Thank you.