{"id":8839,"date":"2026-09-16T11:30:45","date_gmt":"2026-09-16T11:30:45","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=8839"},"modified":"2026-09-17T06:12:30","modified_gmt":"2026-09-17T06:12:30","slug":"displaying-error-message-in-bigquery","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/","title":{"rendered":"Displaying error message in BigQuery"},"content":{"rendered":"\r\n<h1>Viewing Detailed Error Messages in BigQuery<\/h1>\r\n<p class=\"wp-block-paragraph\">Accessing detailed error messages in BigQuery is essential for diagnosing and resolving issues encountered during query execution. This introduction elucidates the importance and methods of viewing detailed error messages in BigQuery, empowering users to troubleshoot effectively and optimize query performance.<\/p>\r\n<p>BigQuery surfaces error information in a few different places, depending on whether a query fails before it even runs, fails partway through execution, or completes but produces a result you want to flag as invalid yourself. This covers all three.<\/p>\r\n<h2>Catching Errors Before You Run a Query<\/h2>\r\n<p>As you type a query, the query editor checks it in the background. A red exclamation mark next to a line, and in the query validator at the bottom of the editor, means BigQuery has already spotted a problem, usually a syntax error, before you have even clicked Run. A green checkmark in the same spot means the query is valid and ready to execute. Catching an error here costs nothing, since the query never actually runs, whereas an error caught after clicking Run may have already used some processing time.<\/p>\r\n<h2>Common BigQuery Error Reasons to Know<\/h2>\r\n<p>When a query does fail, the error response includes a reason code that tells you what category of problem you are dealing with. A few of the most common:<\/p>\r\n<ul>\r\n<li><b><\/b><strong><b>invalidQuery, <\/b><\/strong>a syntax error somewhere in the query itself.<\/li>\r\n<li><b><\/b><strong><b>notFound, <\/b><\/strong>the query references a table, dataset, or column that does not exist, often a typo in a name.<\/li>\r\n<li><b><\/b><strong><b>accessDenied, <\/b><\/strong>your account or service account does not have the right permission on the resource being queried.<\/li>\r\n<li><b><\/b><strong><b>resourcesExceeded, <\/b><\/strong>the query needed more memory or resources than allowed, often fixable by simplifying the query or filtering data earlier.<\/li>\r\n<li><b><\/b><strong><b>billingTierLimitExceeded, <\/b><\/strong>the query is scanning or processing far more data than expected, often due to an inefficient join.<\/li>\r\n<\/ul>\r\n<p>Knowing the category narrows down where to look immediately, rather than rereading the entire query line by line.<\/p>\r\n<p>BigQuery surfaces error information in a few different places, depending on whether a query fails before it even runs, fails partway through execution, or completes but produces a result you want to flag as invalid yourself. This covers all three.<\/p>\r\n<h2>Catching Errors Before You Run a Query<\/h2>\r\n<p>As you type a query, the query editor checks it in the background. A red exclamation mark next to a line, and in the query validator at the bottom of the editor, means BigQuery has already spotted a problem, usually a syntax error, before you have even clicked Run. A green checkmark in the same spot means the query is valid and ready to execute. Catching an error here costs nothing, since the query never actually runs, whereas an error caught after clicking Run may have already used some processing time.<\/p>\r\n<h2>Common BigQuery Error Reasons to Know<\/h2>\r\n<p>When a query does fail, the error response includes a reason code that tells you what category of problem you are dealing with. A few of the most common:<\/p>\r\n<ul>\r\n<li><b><\/b><strong><b>invalidQuery, <\/b><\/strong>a syntax error somewhere in the query itself.<\/li>\r\n<li><b><\/b><strong><b>notFound, <\/b><\/strong>the query references a table, dataset, or column that does not exist, often a typo in a name.<\/li>\r\n<li><b><\/b><strong><b>accessDenied, <\/b><\/strong>your account or service account does not have the right permission on the resource being queried.<\/li>\r\n<li><b><\/b><strong><b>resourcesExceeded, <\/b><\/strong>the query needed more memory or resources than allowed, often fixable by simplifying the query or filtering data earlier.<\/li>\r\n<li><b><\/b><strong><b>billingTierLimitExceeded, <\/b><\/strong>the query is scanning or processing far more data than expected, often due to an inefficient join.<\/li>\r\n<\/ul>\r\n<p>Knowing the category narrows down where to look immediately, rather than rereading the entire query line by line.<\/p>\r\n\r\n\r\n\r\n<h3>Step One: Open BigQuery<\/h3>\r\n<p class=\"wp-block-paragraph\">In the console, open the menu, then go to BigQuery.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Open Menu &gt; <a href=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/\">Bigquery<\/a><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"292\" height=\"274\" class=\"wp-image-8840\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Two: Create a Dataset<\/h3>\r\n<p class=\"wp-block-paragraph\">Click the three dots next to your project, then Create Dataset.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"394\" height=\"169\" class=\"wp-image-8841\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-221.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-221.png 394w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-221-300x129.png 300w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Give Dataset ID.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click Create Dataset.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"557\" height=\"574\" class=\"wp-image-8842\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-222.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-222.png 557w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-222-291x300.png 291w\" sizes=\"auto, (max-width: 557px) 100vw, 557px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Three: Open the Dataset<\/h3>\r\n<p class=\"wp-block-paragraph\">Click the three dots next to the dataset, then Open.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"339\" height=\"188\" class=\"wp-image-8843\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-223.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-223.png 339w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-223-300x166.png 300w\" sizes=\"auto, (max-width: 339px) 100vw, 339px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Four: Create a Table<\/h3>\r\n<p class=\"wp-block-paragraph\">Click Create Table.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"318\" class=\"wp-image-8844\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-224.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-224.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-224-300x152.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Choose Empty table as the source, give it a name, then click Create.<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"496\" height=\"822\" class=\"wp-image-8845\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-225.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-225.png 496w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-225-181x300.png 181w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Five: Open the Table<\/h3>\r\n<p class=\"wp-block-paragraph\">Click the three dots next to the table, then Open.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"339\" height=\"251\" class=\"wp-image-8846\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-226.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-226.png 339w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-226-300x222.png 300w\" sizes=\"auto, (max-width: 339px) 100vw, 339px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Six: Insert Sample Data<\/h3>\r\n<p class=\"wp-block-paragraph\">Click Compose new query, then paste in the following:<\/p>\r\n<p>CREATE OR REPLACE TABLE business.customer AS<br \/>SELECT<br \/>\u00a0\u00a0123 AS cust_id,<br \/>\u00a0\u00a0&#8220;Evan&#8221; AS name;<br \/><br \/>SELECT * FROM business.customer;<\/p>\r\n<p>Click Run.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"142\" class=\"wp-image-8847\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-227.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-227.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-227-300x68.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"564\" class=\"wp-image-8848\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-228.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-228.png 470w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-228-250x300.png 250w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Seven: Delete a Row<\/h3>\r\n<p class=\"wp-block-paragraph\">Paste the following and click Run. It removes one row.<\/p>\r\n<p>DELETE FROM business.customer WHERE true;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"515\" class=\"wp-image-8849\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-229.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-229.png 580w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-229-300x266.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Eight: Raise a Custom Error With the ERROR Function<\/h3>\r\n<p class=\"wp-block-paragraph\">The <strong><b>ERROR<\/b><\/strong>\u00a0function lets you fail a query deliberately, with your own message, when a result does not meet a condition you care about. Here, the query checks that the table has at least one row, and raises a custom error if it does not.<\/p>\r\n<p>SELECT<br \/>\u00a0\u00a0COUNT(*) AS row_count<br \/>FROM business.customer<br \/>HAVING<br \/>\u00a0\u00a0IF(row_count &gt; 0, true,<br \/>\u00a0\u00a0\u00a0\u00a0ERROR(FORMAT(&#8220;Error: row_count must be positive but it is %t&#8221;, row_count))<br \/>\u00a0\u00a0);<\/p>\r\n<p>Click Run.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"571\" height=\"353\" class=\"wp-image-8850\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-230.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-230.png 571w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-230-300x185.png 300w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Nine: View the Error Message<\/h3>\r\n<p class=\"wp-block-paragraph\">Since the table has no rows left after the delete, the condition fails and BigQuery displays the custom message you wrote inside FORMAT.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"541\" height=\"194\" class=\"wp-image-8851\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-231.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-231.png 541w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-231-300x108.png 300w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\r\n<h2>Where to Look When a Query Fails for Another Reason<\/h2>\r\n<p>Most query failures are not a custom ERROR call, they are an ordinary mistake. When one happens, click <strong><b>Execution Details<\/b><\/strong>\u00a0under the query results pane to see the full job information, including the specific error reason. For jobs you are checking after the fact, the Job History tab in BigQuery lists your recent jobs, and from the command line, bq show, followed by a job ID, returns the same detail, with bq show and the pretty json format option giving you the full error object for programmatic use.<\/p>\r\n<h2>Common Mistakes to Avoid<\/h2>\r\n<ul>\r\n<li>Copying SQL from a document or slide without checking its quotation marks. Curly quotes inserted automatically by a word processor will break a string literal in BigQuery, the same as they would in most programming languages.<\/li>\r\n<li>Rerunning a failed query repeatedly without checking Execution Details first. The specific error reason usually points straight at the problem, rather than needing to guess from the query alone.<\/li>\r\n<li>Using ERROR for something better handled with a WHERE or HAVING filter. A custom error is meant to flag a condition that should never happen, not as a general substitute for filtering data you simply do not want in a result.<\/li>\r\n<\/ul>\r\n<p>That covers finding BigQuery&#8217;s own error details and raising a custom one with the ERROR function. To go further, explore <a href=\"https:\/\/prwatech.in\/gcp-training-institutes-in-bangalore\/\"><strong><b>Prwatech&#8217;s Google Cloud training<\/b><\/strong><\/a>\u00a0program, which includes placement assistance.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Viewing Detailed Error Messages in BigQuery Accessing detailed error messages in BigQuery is essential for diagnosing and resolving issues encountered during query execution. This introduction elucidates the importance and methods of viewing detailed error messages in BigQuery, empowering users to troubleshoot effectively and optimize query performance. BigQuery surfaces error information in a few different places, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1632,1],"tags":[728,1401,1403,732,1402,1409,605,729,699,700,735,617,683,684,685,611,1400,692],"class_list":["post-8839","post","type-post","status-publish","format-standard","hentry","category-bigquery","category-google-cloud-platform","tag-bigquery","tag-bigquery-console","tag-bigquery-documentation","tag-bigquery-sql","tag-bigquery-tutorial","tag-custom-error-message-in-bigquery","tag-gcp","tag-gcp-bigquery","tag-gcp-certification","tag-gcp-cloud-console","tag-google-bigquery","tag-google-cloud","tag-google-cloud-certification","tag-google-cloud-console","tag-google-cloud-courses","tag-google-cloud-platform","tag-google-cloud-platform-tutorial","tag-google-cloud-training"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>BigQuery Error Messages: Finding Them and Raising Your Own<\/title>\n<meta name=\"description\" content=\"Find BigQuery error details before and after a query runs, understand common error reasons, and raise a custom error with the ERROR function. Know more!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BigQuery Error Messages: Finding Them and Raising Your Own\" \/>\n<meta property=\"og:description\" content=\"Find BigQuery error details before and after a query runs, understand common error reasons, and raise a custom error with the ERROR function. Know more!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/\" \/>\n<meta property=\"og:site_name\" content=\"Prwatech\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prwatech.in\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-16T11:30:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-17T06:12:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png\" \/>\n\t<meta property=\"og:image:width\" content=\"292\" \/>\n\t<meta property=\"og:image:height\" content=\"274\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Prwatech\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:site\" content=\"@Eduprwatech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prwatech\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/\",\"url\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/\",\"name\":\"BigQuery Error Messages: Finding Them and Raising Your Own\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png\",\"datePublished\":\"2026-09-16T11:30:45+00:00\",\"dateModified\":\"2026-09-17T06:12:30+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Find BigQuery error details before and after a query runs, understand common error reasons, and raise a custom error with the ERROR function. Know more!\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png\",\"width\":292,\"height\":274},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Displaying error message in BigQuery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prwatech.in\/blog\/#website\",\"url\":\"https:\/\/prwatech.in\/blog\/\",\"name\":\"Prwatech\",\"description\":\"Share Ideas, Start Something Good.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prwatech.in\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\",\"name\":\"Prwatech\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g\",\"caption\":\"Prwatech\"},\"url\":\"https:\/\/prwatech.in\/blog\/author\/prwatech123\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BigQuery Error Messages: Finding Them and Raising Your Own","description":"Find BigQuery error details before and after a query runs, understand common error reasons, and raise a custom error with the ERROR function. Know more!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/","og_locale":"en_US","og_type":"article","og_title":"BigQuery Error Messages: Finding Them and Raising Your Own","og_description":"Find BigQuery error details before and after a query runs, understand common error reasons, and raise a custom error with the ERROR function. Know more!","og_url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2026-09-16T11:30:45+00:00","article_modified_time":"2026-09-17T06:12:30+00:00","og_image":[{"width":292,"height":274,"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png","type":"image\/png"}],"author":"Prwatech","twitter_card":"summary_large_image","twitter_creator":"@Eduprwatech","twitter_site":"@Eduprwatech","twitter_misc":{"Written by":"Prwatech","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/","url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/","name":"BigQuery Error Messages: Finding Them and Raising Your Own","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png","datePublished":"2026-09-16T11:30:45+00:00","dateModified":"2026-09-17T06:12:30+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Find BigQuery error details before and after a query runs, understand common error reasons, and raise a custom error with the ERROR function. Know more!","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-220.png","width":292,"height":274},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/displaying-error-message-in-bigquery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Displaying error message in BigQuery"}]},{"@type":"WebSite","@id":"https:\/\/prwatech.in\/blog\/#website","url":"https:\/\/prwatech.in\/blog\/","name":"Prwatech","description":"Share Ideas, Start Something Good.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prwatech.in\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3","name":"Prwatech","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c00bafc1b04045f31eda917de39891456c44fa47c092b9bb6be0f860a3a30a2f?s=96&d=mm&r=g","caption":"Prwatech"},"url":"https:\/\/prwatech.in\/blog\/author\/prwatech123\/"}]}},"_links":{"self":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8839","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/comments?post=8839"}],"version-history":[{"count":6,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8839\/revisions"}],"predecessor-version":[{"id":11779,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8839\/revisions\/11779"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=8839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=8839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=8839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}