Error when using BigQuery tables as a data source

[Minami]

I am trying to create an app with BigQuery tables as the data source.
The following error occurred when I selected the target table and attempted to create an app.

Is it NG to include "_" in column names?

This table is a partitioned table with a pseudo column named "_PARTITIONTIME".
Is it possible to use partitioned tables as a data source?

[Joseph_Seddik]

A column name starting with "_" is OK for Big Query. 

A column name starting with "_partition" is also OK.

A column name starting with "_PARTITION" is NOT OK.

[Minami]

Thank you for your response.

I see that "_partition" is OK and "_PARTITION" is NOT OK.
Is there a difference between upper and lower case letters?

When I create a partitioned table in BigQuery, it seems to create a pseudo column named "_PARTITIONTIME", can I use the partitioned table as a data source for AppSheet?

[Aleksi]

@Minami Would you please send a support ticket to https://www.appsheet.com/Support/Contact so we could investigate this more closely, thanks. 

[Minami · Accepted solution]

Thank you!
I checked the following page and found that partitioned tables are not supported.

https://support.google.com/appsheet/answer/11905680?hl=en#:~:text=Partitioned%20tables%20are%20not%2...

[Aleksi]

Okay 🙂 I thought you were just suffering from the column name in general.