Enterprise only
Use backticks around column names in SQL expressions when you need to
preserve case or include spaces. Backticks work in both Enterprise SQL statements
and table SDK expression strings. Use single quotes for SQL string literals,
and pass bare column names as the keys of values and values_sql.
Preserve camelCase names in SQL
SQL lowercases unquoted identifiers. If your table has a column namedmovieId,
SELECT movieId FROM movies looks for movieid and fails. Quote each column
reference to preserve its exact name:
SELECT query of a
materialized view definition.
Update columns and filter rows with the SDK
The following examples assumemovies has numeric columns movieId,
averageRating, and numVotes, and a string column reviewStatus.
Use backticks for column references inside both where and values_sql
expression strings:
"averageRating" contains only the column name. Its enclosing
quotes are Python syntax. A key such as '"averageRating"' or
"`averageRating`" includes SQL quote characters in the name and fails because
that column does not exist.
For a constant value, use values and pass the Python value directly:
values_sql, write the constant as a SQL string literal instead: