Special characters on table names Bigquery

does anyone know how to include special characters like $ on a table name or if the table already exist with a $ on its name, how to ingest it on bigquery.

Thank you in advance,

1 answer

  • answered 2021-07-27 16:12 Iñigo González

    That's not possible.

    BigQuery column names must contain only letters, numbers, and undescores. They must start with either a letter or an underscore.

    Link to relevant doc: https://cloud.google.com/bigquery/docs/schemas#column_names

    If a table contains special characters, you need to change its name before ingesting to BigQuery ($COLUMN_NAME -> DOLLAR_COLUMN_NAME, maybe?)

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum