{"id":8733,"date":"2026-09-17T10:33:56","date_gmt":"2026-09-17T10:33:56","guid":{"rendered":"https:\/\/prwatech.in\/blog\/?p=8733"},"modified":"2026-09-18T15:44:18","modified_gmt":"2026-09-18T15:44:18","slug":"adding-drive-file-into-bigquery","status":"publish","type":"post","link":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/","title":{"rendered":"Adding Drive File into BigQuery"},"content":{"rendered":"\r\n<h1>Querying a Google Drive File Directly From BigQuery<\/h1>\r\n<p class=\"wp-block-paragraph\">BigQuery can create an external table linked directly to a file sitting in Google Drive, most commonly a Google Sheet, without importing or copying the data anywhere. BigQuery reads the file in place each time the table is queried, so any edit made in the Sheet shows up the next time someone runs a query against it.<\/p>\r\n<p>Incorporating files from Google Drive into BigQuery offers a streamlined pathway to leverage diverse data sources within Google&#8217;s comprehensive cloud ecosystem. This introduction elucidates the process of seamlessly integrating Drive files into BigQuery, highlighting the methods, considerations, and advantages inherent in this operation.<\/p>\r\n<p>Google Drive serves as a robust cloud storage platform, facilitating collaboration and centralizing document management. BigQuery, on the other hand, is a powerful data analytics platform renowned for its scalability and performance. By bridging these platforms, users can harness the rich data stored in Drive for advanced analytics and insights generation.<\/p>\r\n<h2>Step by Step Process of adding Drive files into BigQuery<\/h2>\r\n<p>The process of adding Drive files into BigQuery typically involves exporting the desired files from Drive to Google Cloud Storage in a compatible format, such as CSV or JSON. Subsequently, users can leverage BigQuery&#8217;s native functionality to ingest the data from Cloud Storage into BigQuery tables, enabling seamless integration with existing datasets and analytical workflows.<\/p>\r\n<h3><strong>Prerequisites<\/strong><\/h3>\r\n\r\n\r\n\r\n<h3>Step One: Create a Sample Google Sheet<\/h3>\r\n<p class=\"wp-block-paragraph\">Open drive.google.com and click New.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"200\" height=\"271\" class=\"wp-image-8735\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.png\" alt=\"\" \/><\/figure>\r\n<p>Choose Google Sheets, then Blank Spreadsheet.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Google Sheets &gt; Blank Spreadsheet.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"379\" class=\"wp-image-8736\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-124.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-124.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-124-300x181.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n<p>Add a small sample dataset, such as a message and its language code.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Type the spreadsheet like below.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"414\" height=\"266\" class=\"wp-image-8737\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-125.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-125.png 414w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-125-300x193.png 300w\" sizes=\"auto, (max-width: 414px) 100vw, 414px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Two: Add a Translated Column<\/h3>\r\n<p class=\"wp-block-paragraph\">In an empty cell, use the GOOGLETRANSLATE function to generate a translated version of a message:<\/p>\r\n<p>=GOOGLETRANSLATE(&#8220;source cell&#8221;, &#8220;written language&#8221;, &#8220;translation language&#8221;)<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"158\" class=\"wp-image-8738\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-126.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-126.png 355w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-126-300x134.png 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Replace the placeholder text with the actual cell references for your source message and target language.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"361\" height=\"134\" class=\"wp-image-8739\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-127.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-127.png 361w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-127-300x111.png 300w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Click outside the cell to confirm it.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"366\" height=\"207\" class=\"wp-image-8740\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-128.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-128.png 366w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-128-300x170.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Three: Create a Dataset in BigQuery<\/h3>\r\n<p class=\"wp-block-paragraph\">Open the console, then go to BigQuery.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Go to 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\/\">Big Query <\/a>&gt; SQL Instances<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"194\" class=\"wp-image-8741\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-129.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-129.png 355w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-129-300x164.png 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Select your project.<\/p>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"310\" height=\"264\" class=\"wp-image-8742\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-130.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-130.png 310w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-130-300x255.png 300w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/><\/figure>\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=\"366\" height=\"95\" class=\"wp-image-8743\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-131.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-131.png 366w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-131-300x78.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Give it a dataset ID, then 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=\"476\" height=\"426\" class=\"wp-image-8744\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-132.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-132.png 476w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-132-300x268.png 300w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">It now appears listed under your project.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"314\" height=\"275\" class=\"wp-image-8745\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-133.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-133.png 314w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-133-300x263.png 300w\" sizes=\"auto, (max-width: 314px) 100vw, 314px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Four: Create an External Table Linked to the Sheet<\/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 is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-8746\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-134.png\" alt=\"\" width=\"580\" height=\"253\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-134.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-134-300x131.png 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Choose Drive as the source.<\/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-8747\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-135.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-135.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-135-300x68.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Open your Google Sheet and copy its share link.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"96\" class=\"wp-image-8748\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-136.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-136.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-136-300x46.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Paste it into the URI field, and set the file format to Google Sheets.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"628\" height=\"127\" class=\"wp-image-8749\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-137.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-137.png 628w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-137-300x61.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Give the table a name, switch to editing the schema as text, and define the columns to match your sheet, for example:<\/p>\r\n<p>message:STRING<br \/>code:STRING<br \/>translation:STRING<\/p>\r\n<p>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=\"458\" height=\"484\" class=\"wp-image-8750\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-138.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-138.png 458w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-138-284x300.png 284w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/figure>\r\n\r\n\r\n\r\n<h3>Step Five: Query the External Table<\/h3>\r\n<p class=\"wp-block-paragraph\">In the query editor, write a query against the new table and click Run.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"322\" height=\"163\" class=\"wp-image-8751\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-139.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-139.png 322w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-139-300x152.png 300w\" sizes=\"auto, (max-width: 322px) 100vw, 322px\" \/><\/figure>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">The results come back directly from the live data in the Sheet.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"342\" height=\"240\" class=\"wp-image-8752\" src=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-140.png\" alt=\"\" srcset=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-140.png 342w, https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-140-300x211.png 300w\" sizes=\"auto, (max-width: 342px) 100vw, 342px\" \/><\/figure>\r\n<h2>Why This Connection Can Suddenly Stop Working<\/h2>\r\n<p>The single most common problem with a Drive linked external table is an error along the lines of permission denied while getting Drive credentials. This is not usually a BigQuery bug. BigQuery accesses the linked file by impersonating whoever originally set up the connection, so if that person loses access to the file, has it unshared with them, or leaves the organization, every query against the table can fail for everyone, not just that one person.<\/p>\r\n<ul>\r\n<li>Confirm that the account the table depends on still has at least viewer access to the file in Drive.<\/li>\r\n<li>Prefer a shared account, group, or service account for the connection over a single person&#8217;s individual login, so the table&#8217;s access does not depend on one specific employee staying at the company.<\/li>\r\n<li>If you are using an old version of the bq command line tool, version 2.1.12 or earlier, you may also need to add the enable gdrive access flag explicitly.<\/li>\r\n<\/ul>\r\n<h2>Common Mistakes to Avoid<\/h2>\r\n<ul>\r\n<li>Assuming this feature requires a Cloud Storage step. It does not. BigQuery reads Drive hosted CSV, JSON, Avro, and Google Sheets files directly.<\/li>\r\n<li>Building an important table on top of one person&#8217;s personal Drive access without a fallback. Revisit this once the connection is more than a quick test.<\/li>\r\n<li>Writing a formula in Sheets with mismatched or curly quotation marks. Google Sheets needs the same straight, matching quotes around text arguments that most programming languages do.<\/li>\r\n<li>Defining the external table&#8217;s schema in a different column order than the actual sheet. The schema is matched by position, not by header name, so a mismatch here silently shifts every value into the wrong column.<\/li>\r\n<\/ul>\r\n<p>That covers linking a Google Drive file to BigQuery as an external table, and the permission issue most likely to break it later. To go further, explore <a href=\"https:\/\/prwatech.in\/gcp-training-institutes-in-pune\/\"><strong><b>Prwatech&#8217;s Google Cloud training<\/b><\/strong><\/a>\u00a0program, which includes placement assistance.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Querying a Google Drive File Directly From BigQuery BigQuery can create an external table linked directly to a file sitting in Google Drive, most commonly a Google Sheet, without importing or copying the data anywhere. BigQuery reads the file in place each time the table is queried, so any edit made in the Sheet shows [&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,736,732,1402,605,729,699,700,1399,617,683,684,685,611,1400,686,692],"class_list":["post-8733","post","type-post","status-publish","format-standard","hentry","category-bigquery","category-google-cloud-platform","tag-bigquery","tag-bigquery-console","tag-bigquery-documentation","tag-bigquery-in-cloud","tag-bigquery-sql","tag-bigquery-tutorial","tag-gcp","tag-gcp-bigquery","tag-gcp-certification","tag-gcp-cloud-console","tag-gcp-console","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-storage","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>Querying a Google Drive File Directly From BigQuery<\/title>\n<meta name=\"description\" content=\"Link a Google Sheet as a BigQuery external table with no import step, and fix the most common reason this connection breaks later.\" \/>\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\/adding-drive-file-into-bigquery\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Querying a Google Drive File Directly From BigQuery\" \/>\n<meta property=\"og:description\" content=\"Link a Google Sheet as a BigQuery external table with no import step, and fix the most common reason this connection breaks later.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-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-17T10:33:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-18T15:44:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"271\" \/>\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=\"7 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\/adding-drive-file-into-bigquery\/\",\"url\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/\",\"name\":\"Querying a Google Drive File Directly From BigQuery\",\"isPartOf\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.png\",\"datePublished\":\"2026-09-17T10:33:56+00:00\",\"dateModified\":\"2026-09-18T15:44:18+00:00\",\"author\":{\"@id\":\"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3\"},\"description\":\"Link a Google Sheet as a BigQuery external table with no import step, and fix the most common reason this connection breaks later.\",\"breadcrumb\":{\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#primaryimage\",\"url\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.png\",\"contentUrl\":\"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.png\",\"width\":200,\"height\":271},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prwatech.in\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Adding Drive File into 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":"Querying a Google Drive File Directly From BigQuery","description":"Link a Google Sheet as a BigQuery external table with no import step, and fix the most common reason this connection breaks later.","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\/adding-drive-file-into-bigquery\/","og_locale":"en_US","og_type":"article","og_title":"Querying a Google Drive File Directly From BigQuery","og_description":"Link a Google Sheet as a BigQuery external table with no import step, and fix the most common reason this connection breaks later.","og_url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/","og_site_name":"Prwatech","article_publisher":"https:\/\/www.facebook.com\/prwatech.in\/","article_published_time":"2026-09-17T10:33:56+00:00","article_modified_time":"2026-09-18T15:44:18+00:00","og_image":[{"width":200,"height":271,"url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/","url":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/","name":"Querying a Google Drive File Directly From BigQuery","isPartOf":{"@id":"https:\/\/prwatech.in\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#primaryimage"},"image":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#primaryimage"},"thumbnailUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.png","datePublished":"2026-09-17T10:33:56+00:00","dateModified":"2026-09-18T15:44:18+00:00","author":{"@id":"https:\/\/prwatech.in\/blog\/#\/schema\/person\/db90baff7744090b2288bbc98fea87f3"},"description":"Link a Google Sheet as a BigQuery external table with no import step, and fix the most common reason this connection breaks later.","breadcrumb":{"@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#primaryimage","url":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.png","contentUrl":"https:\/\/prwatech.in\/blog\/wp-content\/uploads\/2021\/05\/image-123.png","width":200,"height":271},{"@type":"BreadcrumbList","@id":"https:\/\/prwatech.in\/blog\/google-cloud-platform\/bigquery\/adding-drive-file-into-bigquery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prwatech.in\/blog\/"},{"@type":"ListItem","position":2,"name":"Adding Drive File into 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\/8733","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=8733"}],"version-history":[{"count":6,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8733\/revisions"}],"predecessor-version":[{"id":11784,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/posts\/8733\/revisions\/11784"}],"wp:attachment":[{"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/media?parent=8733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/categories?post=8733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prwatech.in\/blog\/wp-json\/wp\/v2\/tags?post=8733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}