I need some help with understanding how to build an SQL from Mobile Push Extract that needs some transformation to the data like time zone, before being transferred to a AWS bucket.

I have an automation that starts with a Mobile Push Detail Extract Report and I need to use SQL to pull all of the fields in the report to a Data extension and then transfer the file to AWS, however I am not sure how to refer to this report in the SQL query itself because I'm not sure what the report is called?

For example query will start with: SELECT* FROM 'name of the report produced by the extract'

Is this the name that I gave this report in the filenaming pattern when creating an extract activity? but then it's dynamic name since it's called 'Test_Mobile_Push_Extract1%%Year%%%%Month%%%%Day%%', so it doesn't look like an option for including in this SQL or is there a default name that exists for this extract?

Also, do I need to import the extract results to a data extension prior to doing an SQL or can I pull directly from the Mobile push extract report activity?

I appreciate any assistance!

I need some help with understanding how to build an SQL from Mobile Push Extract that needs some transformation to the data like time zone, before being transferred to a AWS bucket.

I have an automation that starts with a Mobile Push Detail Extract Report and I need to use SQL to pull all of the fields in the report to a Data extension and then transfer the file to further.

I need to import the extract results to a data extension prior to doing an SQL or can I pull directly from the Mobile push extract report activity, isn't it?

I appreciate any assistance!