Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Your company is employing WILDCARD tables within Google BigQuery to execute queries spanning multiple tables that share similar naming conventions. The SQL statement designed for this purpose is encountering an error, resulting in a failure of the query. Identify the table naming pattern that will resolve the error and ensure the SQL statement works correctly.
Your company is employing WILDCARD tables within Google BigQuery to execute queries spanning multiple tables that share similar naming conventions. The SQL statement designed for this purpose is encountering an error, resulting in a failure of the query. Identify the table naming pattern that will resolve the error and ensure the SQL statement works correctly.
Explanation:
When querying BigQuery with wildcard tables, it's necessary to enclose the wildcard table name in backticks () because the wildcard character (*) is a special character. Options A and C do not utilize wildcards, and option B does not use backticks around the wildcard table reference. Therefore, option D is correct as it properly uses backticks around the wildcard table name bigquery-public-data.noaa_gsod.gsod*`.