{"id":115633,"date":"2021-10-22T17:05:18","date_gmt":"2021-10-22T08:05:18","guid":{"rendered":"https:\/\/support.questetra.com\/?p=115633"},"modified":"2026-04-14T15:19:07","modified_gmt":"2026-04-14T06:19:07","slug":"bigquery-add-data","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/","title":{"rendered":"Adding Data to BigQuery Automatically"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/advanced-banner-en.png?ssl=1\" alt=\"\" class=\"wp-image-89195\"\/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">In this article I will explain an automatic process relating to Google Big Query.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">BigQuery is a product provided by Google Cloud Platform, which is a service that can store big data and analyze it at ultra-high speed. It is used by many companies that utilize big data.<\/p>\n\n\n\n<ul class=\"has-very-light-gray-background-color has-background wp-block-list\"><li>This automatic step does not work on the free trial version of Google Cloud Platform (registration of billing method is required)<\/li><li>This article is written for those who are already using BigQuery<\/li><li>For more information on BigQuery, see the <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/quickstarts?authuser=4\">BigQuery documentation<\/a><\/li><\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">About the Auto-step that works with Google BigQuery<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">First, I will briefly explain the auto-step [<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-bigquery-data-insert\/\">Google BigQuery: Insert New Data<\/a>].<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Google BigQuery: Insert New Data<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">It inserts a new data row into a table in BigQuery. The table to be added is specified by the Project ID, Dataset ID, and Table ID. You can specify up to 7 fields for the table schema. You can also specify a suffix to create a template table.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"954\" height=\"1136\" data-attachment-id=\"115752\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-config-en.png?fit=954%2C1136&amp;ssl=1\" data-orig-size=\"954,1136\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-config-en.png?fit=529%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-config-en.png?resize=954%2C1136&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115752\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-config-en.png?w=954&amp;ssl=1 954w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-config-en.png?resize=265%2C315&amp;ssl=1 265w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-config-en.png?resize=529%2C630&amp;ssl=1 529w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-config-en.png?resize=768%2C915&amp;ssl=1 768w\" sizes=\"auto, (max-width: 954px) 100vw, 954px\" \/><figcaption>[Google BigQuery: Insert New Data] settings screen<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"integration\">BigQuery and Questetra integration settings<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">I will explain how to set up integration between Questetra and BigQuery.<\/p>\n\n\n\n<ul class=\"has-very-light-gray-background-color has-background wp-block-list\"><li>The System Administrator privilege is required to set up HTTP Authorization settings<\/li><li>The registered HTTP Authorization settings are also shared with other Apps on the same workflow platform<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">After placing the aforementioned automatic Step in the workflow App editing screen in Questetra, open its properties screen. When you click the [Set up Settings] button below the C1: OAuth2 settings item in Google BigQuery: Insert New Data, the HTTP Authorization Setting Google BigQuery API settings screen will open.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Click [Add] on the screen and specify a name of your choice. (Arbitrary string: It\u2019s better to give a name that is easy to understand later.)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1067\" height=\"418\" data-attachment-id=\"115755\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-oasuth_add-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_add-en.png?fit=1067%2C418&amp;ssl=1\" data-orig-size=\"1067,418\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-oasuth_add-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_add-en.png?fit=1024%2C401&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_add-en.png?resize=1067%2C418&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115755\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_add-en.png?w=1067&amp;ssl=1 1067w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_add-en.png?resize=600%2C235&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_add-en.png?resize=1024%2C401&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_add-en.png?resize=768%2C301&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Click [Get Token] in the added setting to move to the Google authentication screen.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1262\" height=\"197\" data-attachment-id=\"115757\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-oasuth_token-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_token-en.png?fit=1262%2C197&amp;ssl=1\" data-orig-size=\"1262,197\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-oasuth_token-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_token-en.png?fit=1024%2C160&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_token-en.png?resize=1262%2C197&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115757\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_token-en.png?w=1262&amp;ssl=1 1262w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_token-en.png?resize=600%2C94&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_token-en.png?resize=1024%2C160&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_token-en.png?resize=768%2C120&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Sign in with the account whose inbox is to be monitored and allow the request.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"490\" height=\"826\" data-attachment-id=\"115760\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-oasuth_permission-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_permission-en.png?fit=490%2C826&amp;ssl=1\" data-orig-size=\"490,826\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-oasuth_permission-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_permission-en.png?fit=374%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_permission-en.png?resize=490%2C826&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115760\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_permission-en.png?w=490&amp;ssl=1 490w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_permission-en.png?resize=187%2C315&amp;ssl=1 187w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-oasuth_permission-en.png?resize=374%2C630&amp;ssl=1 374w\" sizes=\"auto, (max-width: 490px) 100vw, 490px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">You now have obtained a token for OAuth2 authentication with BigQuery. You can confirm it has worked by checking the  \u201c\u25cb (refresh token)\u201d indicator above the [Get Token] button.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Go back to the Google BigQuery: Insert New Data settings and select the setting name that was added in C1: OAuth2 settings.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Create a BigQuery table<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Create a table in BigQuery that accepts data from Questetra BPM Suite.<\/p>\n\n\n\n<ul class=\"has-very-light-gray-background-color has-background wp-block-list\"><li>In case you want to test the operation, create a new project and use it<ul><li>You will need to register a billing account for the project<\/li><li>BigQuery charges according to usage<ul><li><a rel=\"noreferrer noopener\" href=\"https:\/\/cloud.google.com\/bigquery?authuser=4#section-11\" target=\"_blank\">BigQuery Pricing<\/a><\/li><li>There is also a <a rel=\"noreferrer noopener\" href=\"https:\/\/cloud.google.com\/bigquery\/pricing?authuser=2#free-tier\" target=\"_blank\">free tier<\/a>, so if you use a small amount, you will not be charged<\/li><li>The project you created along this article is also subject to storage, so delete it if you do not need it after the test is completed.<\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/cloud.google.com\/billing\/docs\/how-to\/modify-project#confirm_billing_is_enabled_on_a_project\" target=\"_blank\">Enable, disable, or change billing for a project <\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Create a dataset in the project. Open the properties of the created dataset and create a table.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select [Empty Table] in the source, and specify the table name. Add fields to the schema one by one. The fields will be the columns in the table. Specify the Name, Type, and Mode respectively. Select the Type according to the Data-type of the data to be added from Questetra BPM Suite. [Google BigQuery: Insert New Data] supports STRING, BYTES, INTEGER, FLOAT, NUMERIC, BIGNUMERIC, BOOLEAN, TIMESTAMP, DATE, TIME and DATETIME. Select either NULLABLE or REQUIRED as the mode. You can set up to 7 fields.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"745\" height=\"863\" data-attachment-id=\"115763\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-table_create-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_create-en.png?fit=745%2C863&amp;ssl=1\" data-orig-size=\"745,863\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-table_create-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_create-en.png?fit=544%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_create-en.png?resize=745%2C863&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115763\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_create-en.png?w=745&amp;ssl=1 745w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_create-en.png?resize=272%2C315&amp;ssl=1 272w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_create-en.png?resize=544%2C630&amp;ssl=1 544w\" sizes=\"auto, (max-width: 745px) 100vw, 745px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">After specifying all the required items, click [Create table]. The table name you created will appear below the dataset displayed in Explorer. Open the created table and check the Project ID, Dataset ID, and Table ID in the [Details] tab. All of them are listed in the Table ID section. (Similar to the path notation, it is displayed <em>Project ID: Dataset ID. Table ID<\/em>.) Make a note of each of them as you will need them later in the [Google BigQuery: Insert New Data] settings.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1067\" height=\"723\" data-attachment-id=\"115766\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-table_settins-detail-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-detail-en.png?fit=1067%2C723&amp;ssl=1\" data-orig-size=\"1067,723\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-table_settins-detail-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-detail-en.png?fit=930%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-detail-en.png?resize=1067%2C723&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115766\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-detail-en.png?w=1067&amp;ssl=1 1067w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-detail-en.png?resize=465%2C315&amp;ssl=1 465w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-detail-en.png?resize=930%2C630&amp;ssl=1 930w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-detail-en.png?resize=768%2C520&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption>Table Details screen<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Similarly, open the [Schema] tab and make a note of the character string displayed in each row in the Field name column.  [Google BigQuery: Insert New Data] will add values by targeting these character strings.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1067\" height=\"723\" data-attachment-id=\"115769\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-table_settins-schema-en-1\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-schema-en-1.png?fit=1067%2C723&amp;ssl=1\" data-orig-size=\"1067,723\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-table_settins-schema-en-1\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-schema-en-1.png?fit=930%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-schema-en-1.png?resize=1067%2C723&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115769\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-schema-en-1.png?w=1067&amp;ssl=1 1067w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-schema-en-1.png?resize=465%2C315&amp;ssl=1 465w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-schema-en-1.png?resize=930%2C630&amp;ssl=1 930w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-table_settins-schema-en-1.png?resize=768%2C520&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption>Table Schema screen<\/figcaption><\/figure><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator is-style-default\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Example App<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Below is the Workflow Diagram of an example App using the auto-step.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1079\" height=\"143\" data-attachment-id=\"115771\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-workflow-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-workflow-en.png?fit=1079%2C143&amp;ssl=1\" data-orig-size=\"1079,143\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-workflow-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-workflow-en.png?fit=1024%2C136&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-workflow-en.png?resize=1079%2C143&#038;ssl=1\" alt=\"\" class=\"wp-image-115771\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-workflow-en.png?w=1079&amp;ssl=1 1079w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-workflow-en.png?resize=600%2C80&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-workflow-en.png?resize=1024%2C136&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-workflow-en.png?resize=768%2C102&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">This App is just for seeing how the values specified in the Input Step will be added to the BigQuery table. When using it in actual business, data will be accumulated in BigQuery simply by installing the Google BigQuery: Insert New Data step icon in the workflow where customer information is input, such as Inquiry Handling or Webform Application Reception.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In addition, in the Convert data (Update Data) step, an example that converts a String-type (multiple lines) value to single line data and an example of specifying the current date for the Date-type are described.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Workflow App settings<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to add the Google BigQuery: Insert New Data step icon to an existing App, set it using the Data Items that have already been defined. Specify the Field Name of the BigQuery table and set the inserting value to reference the workflow Data Item.<br>However, the format of the data to be added must satisfy the BigQuery specification. (Multi-line character strings are not allowed, etc.) Please convert to an appropriate format such as by using the [<a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-data-assignment\/\">Update Data<\/a>] step icon. Please refer to the following documents for details.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/\" target=\"_blank\" rel=\"noreferrer noopener\">BigQuery Documents<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">Data Item settings<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">The Data Item settings in this example are as follows.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Data Item Name<\/strong><\/td><td><strong>Data-type<\/strong><\/td><td><strong>Required<\/strong><\/td><td><strong>[Input] Step<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><tr><td><strong>Title<\/strong><\/td><td>No<\/td><td>No<\/td><td>Editable<\/td><td>The title of the Process<\/td><\/tr><tr><td><strong>Name<\/strong><\/td><td>String-type (single line)<\/td><td>No<\/td><td>Editable<\/td><td><\/td><\/tr><tr><td><strong>Company<\/strong><\/td><td>String-type (single line)<\/td><td>No<\/td><td>Editable<\/td><td><\/td><\/tr><tr><td><strong>Added date<\/strong><\/td><td>Date-type (Y\/M\/D)<\/td><td>No<\/td><td>Editable<\/td><td>The current date is set in the preceding [Update Data] step.<\/td><\/tr><tr><td><strong>Gender<\/strong><\/td><td>Select-type (radio button)<\/td><td>No<\/td><td>Editable<\/td><td>Two choices with display label Male and Female<br>The Choice ID are respectively M, F <\/td><\/tr><tr><td><strong>Age<\/strong><\/td><td>Select-type (radio button)<\/td><td>No<\/td><td>Editable<\/td><td>6 choices with the following both for the Display labels and Choice IDs<br>&#8220;20s&#8221; \u201d30s\u201d \u201d40s\u201d \u201d50s\u201d \u201d60s\u201d &#8220;70s+&#8221;<br><\/td><\/tr><tr><td><strong>Address<\/strong><\/td><td>String-type (multiple lines)<\/td><td>No<\/td><td>Editable<\/td><td>Value including line breaks, such as a postal address<\/td><\/tr><tr><td><strong>Address (single-lilne) <\/strong><\/td><td>String-type (single line)<\/td><td>No<\/td><td>No display<\/td><td>Stores the value that line breaks removed from multiple lines data by the [Update Data] step<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">Append to Table (Google BigQuery: Insert New Data) settings<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Settings in Google BigQuery: Insert New Data are as follows.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Config name<\/strong><\/td><td><strong>Required<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><tr><td><strong>C1: OAuth2 Setting<\/strong><\/td><td>Yes<\/td><td>Specify the HTTP Authorization Setting name for connecting to Google BigQuery APIs. You need to get the OAuth2 token in advance with the setting name to be specified. (Refer to \u201c<a href=\"#integration\">BigQuery and Questetra integration settings<\/a>&#8220;)<\/td><\/tr><tr><td><strong>C2: Project ID<\/strong><\/td><td>Yes <\/td><td>Specify the Project ID you noted in &#8220;Create a BigQuery table&#8221;<\/td><\/tr><tr><td><strong>C3: Dataset ID<\/strong><\/td><td>Yes<\/td><td>Specify the Dataset ID you noted in &#8220;Create a BigQuery table&#8221;<\/td><\/tr><tr><td><strong>C4: Table ID<\/strong><\/td><td>Yes<\/td><td>Specify the Table ID you noted in &#8220;Create a BigQuery table&#8221;<\/td><\/tr><tr><td><strong>C5: Template Suffix<\/strong><\/td><td>No<\/td><td>Specify only when using a Template Table *<\/td><\/tr><tr><td><strong>C6F: Field 1<\/strong><\/td><td>No<\/td><td>The Field name of (the target) table schema<br> (e.g.  <em>Name<\/em>)<\/td><\/tr><tr><td><strong>C6V: Value 1<\/strong><\/td><td>No<\/td><td>Reference expression to the Data Item that stores the value to be added<br> (e.g.  <code><em>{#q_Name}<\/em><\/code>)<\/td><\/tr><tr><td><strong>C7F: Field<\/strong> <strong>2 <\/strong><\/td><td>No<\/td><td> The  Field name of (the target) table schema<br> (e.g.  <em>Company<\/em>)<\/td><\/tr><tr><td><strong>C7V:  <strong>Value <\/strong> 2<\/strong><\/td><td>No<\/td><td>Reference expression to the Data Item that stores the value to be added<br> (e.g.  <code><em>{#q_Company}<\/em><\/code>)<\/td><\/tr><tr><td><strong>C8F: Field<\/strong> <strong>3<\/strong><\/td><td>No<\/td><td> The Field name of (the target) table schema<br> (e.g.  <em>Add_date<\/em>)<\/td><\/tr><tr><td><strong>C8V:  <strong>Value <\/strong> 3<\/strong><\/td><td>No<\/td><td>Reference expression to the Data Item that stores the value to be added<br> (e.g.  <code><em>{#q_Added_date}<\/em><\/code>)<\/td><\/tr><tr><td><strong>C9F:  <strong>Field<\/strong>  4<\/strong><\/td><td>No<\/td><td> The Field name of (the target) table schema<br> (e.g.  <em>Gender<\/em>)<\/td><\/tr><tr><td><strong>C9V:  <strong>Value <\/strong> 4<\/strong><\/td><td>No<\/td><td>Reference expression to the Data Item that stores the value to be added<br>  (e.g.  <code><em>{#q_Gender?.![value]}<\/em><\/code>      reference to the Choice ID)<\/td><\/tr><tr><td><strong>C10F:  <strong>Field<\/strong>  5<\/strong><\/td><td>No<\/td><td> The Field name of (the target) table schema<br> (e.g.  <em>Age<\/em>)<\/td><\/tr><tr><td><strong>C10V:  <strong>Value <\/strong> 5<\/strong><\/td><td>No<\/td><td>Reference expression to the Data Item that stores the value to be added<br>  (e.g.  <code><em>{#q_Age}<\/em><\/code>)<\/td><\/tr><tr><td><strong>C11F:  <strong>Field<\/strong>  6<\/strong><\/td><td>No<\/td><td> The Field name of (the target) table schema<br>  (e.g.  <em>Address<\/em>) <\/td><\/tr><tr><td><strong>C11V:  <strong>Value <\/strong> 6<\/strong><\/td><td>No<\/td><td>Reference expression to the Data Item that stores the value to be added<br> (e.g.  <code><em>{#q_Address_single_lilne}<\/em><\/code>)<\/td><\/tr><tr><td><strong>C12F:  <strong>Field<\/strong>  7<\/strong><\/td><td>No<\/td><td>&#8211;<\/td><\/tr><tr><td><strong>C12V:  <strong>Value <\/strong> 7<\/strong><\/td><td>No<\/td><td>&#8211;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">* Template table is a mechanism for creating a table with the same schema. For example, you can create separate tables for each gender that stores the data. (If you specify &#8220;Gender&#8221; as the suffix, C5 will be <code><em>_#{#q_Gender}<\/em><\/code>)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Template suffix value<br>For templateSuffix (or &#8211;template_suffix) value, only alphanumerics and underscores (_) must be included. The maximum number of concatenated characters for a Table name and a Table Suffixes is 1,024.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/cloud.google.com\/bigquery\/streaming-data-into-bigquery#template-tables\">Creating tables automatically using template tables<\/a><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">Convert Data (Update Data) settings<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">If necessary, set up a Convert data Step to convert the input data into a format that can be registered in BigQuery table. In this example, it is assumed that 1) String-type multiple-line data is converted into a String-type single-line Data Item by removing line breaks, and 2) the current date is set to the Date-type Data Item (to register the actual addition date instead of the initial value of the Date-type (Process start date).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Settings are as follows.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>Data Item to be set value<\/strong><\/td><td><strong>Value or expression<\/strong><\/td><\/tr><tr><td><strong>Address (single-lilne)<\/strong><\/td><td><code><em>#{#joiner.splitJoin(#q_Address, ' ')}<\/em><\/code><br>(Remove line breaks from <em>#q_Address<\/em>, the String-type multiple-line data (separate by a single-byte space and concatenate))<\/td><\/tr><tr><td><strong>Added date<\/strong><\/td><td><code><em>#now<br><\/em><\/code>(Insert current date)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When executed, the data will be added to BigQuery as the following image. (An example using table suffix)<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1067\" height=\"499\" data-attachment-id=\"115773\" data-permalink=\"https:\/\/support.questetra.com\/en\/developer-blog\/bigquery-add-data\/attachment\/bigquery-result-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-result-en.png?fit=1067%2C499&amp;ssl=1\" data-orig-size=\"1067,499\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"bigquery-result-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-result-en.png?fit=1024%2C479&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-result-en.png?resize=1067%2C499&#038;ssl=1\" alt=\"\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\" class=\"wp-image-115773\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-result-en.png?w=1067&amp;ssl=1 1067w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-result-en.png?resize=600%2C281&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-result-en.png?resize=1024%2C479&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/bigquery-result-en.png?resize=768%2C359&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure><\/div>\n\n\n\n<hr class=\"wp-block-separator is-style-wide\"\/>\n","protected":false},"excerpt":{"rendered":"<p>Describes the auto-step for adding data to Google BigQuery tables.<\/p>\n","protected":false},"author":3,"featured_media":115780,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[296],"tags":[3162],"class_list":["post-115633","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog","tag-google-workspace"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Hirotaka NISHI","author_link":"https:\/\/support.questetra.com\/en\/author\/nishiquestetra\/"},"uagb_comment_info":1,"uagb_excerpt":"Describes the auto-step for adding data to Google BigQuery tables.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-u53","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":111337,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/service-task-google-bigquery-data-insert\/","url_meta":{"origin":115633,"position":0},"title":"Google BigQuery: Insert New Data","author":"Shiho Tatsumi","date":"2024-12-12","format":false,"excerpt":"Inserts a new data row to a table in BigQuery.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":111329,"url":"https:\/\/support.questetra.com\/ja\/bpmn-icons\/service-task-google-bigquery-data-insert\/","url_meta":{"origin":115633,"position":1},"title":"Google BigQuery: \u30c7\u30fc\u30bf\u8ffd\u52a0","author":"Shiho Tatsumi","date":"2024-12-12","format":false,"excerpt":"BigQuery \u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092\uff11\u884c\u8ffd\u52a0\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;BPMN\u30a2\u30a4\u30b3\u30f3&quot;","block_context":{"text":"BPMN\u30a2\u30a4\u30b3\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/bpmn-icon-google-bigquery.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":115353,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/bigquery-add-data\/","url_meta":{"origin":115633,"position":2},"title":"BigQuery \u306b\u81ea\u52d5\u3067\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3059\u308b","author":"Hirotaka NISHI","date":"2021-10-22","format":false,"excerpt":"Google BigQuery \u306e\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18\u3059\u308b\u81ea\u52d5\u5de5\u7a0b\u306b\u3064\u3044\u3066\u8aac\u660e\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;Questetra Developers Blog&quot;","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/10\/eye-catch-bigquery.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":113992,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1320\/","url_meta":{"origin":115633,"position":3},"title":"Ver.13.2 2021-10-10  Added Auto-step for Data Linkage to Google BigQuery","author":"Hirotaka NISHI","date":"2021-09-27","format":false,"excerpt":"You will be able to link data to Google BigQuery. In addition, the integration with Google Sheets will be strengthened, and the form Javascript API will be available for some data types.","rel":"","context":"In &quot;Version Info&quot;","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/version-1320-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/version-1320-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/version-1320-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/version-1320-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/version-1320-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":77545,"url":"https:\/\/support.questetra.com\/en\/templates\/entrusted-delivery-flow-20140127\/","url_meta":{"origin":115633,"position":4},"title":"Entrusted-Delivery Flow","author":"Hirotaka NISHI","date":"2020-12-24","format":false,"excerpt":"Manages orders from acceptance to delivery. Item information etc. are input at the Step of [1. Order Info] and the Issue is started after the Step of [2. Delivery Date Check]. The \u201cdelivery date\u201d is automatically registered in Google Calendar. If multiple deals are progressing in parallel, you can list\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-entrusted-delivery-flow-20140127-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-entrusted-delivery-flow-20140127-209-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-entrusted-delivery-flow-20140127-209-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-entrusted-delivery-flow-20140127-209-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-entrusted-delivery-flow-20140127-209-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":77695,"url":"https:\/\/support.questetra.com\/en\/templates\/approval-flow-budget-control-20160920\/","url_meta":{"origin":115633,"position":5},"title":"Approval Flow-Budget Control","author":"Hirotaka NISHI","date":"2022-01-17","format":false,"excerpt":"A Proposal-approval flow that automatically records the approved spending in a Google Sheet. When a new Issue is entered at the [1. Submit plan draft] Step, the \u201cBudget Consumption Log\u201d (Google sheet) is referred to, and the total expenditure so far is calculated automatically. At the Step of [2. Decision],\u2026","rel":"","context":"In &quot;Workflow Apps&quot;","block_context":{"text":"Workflow Apps","link":"https:\/\/support.questetra.com\/en\/category\/templates\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/eye-catch-approval-flow-budget-control-20160920-220-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/115633","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=115633"}],"version-history":[{"count":21,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/115633\/revisions"}],"predecessor-version":[{"id":120901,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/115633\/revisions\/120901"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/115780"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=115633"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=115633"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=115633"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}