Error when using BigQuery tables as a data source

[anonymous]

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.

[anonymous]

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.

[anonymous]

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%20supported%20%2D%20Any%20BigQuery%20tables%20that%20have%20partitioned%20columns%20will%20report%20an%20error%20during%20configuration%20in%20AppSheet.%20Use%20a%20BigQuery%20View%20that%20omits%20the%20partitioned%20column%20to%20work%20around%20this%20limitation

[Aleksi]

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