{"id":29221,"date":"2021-07-30T07:51:13","date_gmt":"2021-07-30T06:51:13","guid":{"rendered":"https:\/\/multisite.korebots.com\/?p=29221"},"modified":"2023-03-14T11:23:17","modified_gmt":"2023-03-14T11:23:17","slug":"data-table","status":"publish","type":"post","link":"https:\/\/developer.kore.ai\/v10-1\/docs\/bots\/advanced-topics\/data-table\/","title":{"rendered":"Data Table"},"content":{"rendered":"<section class=\"l-section wpb_row height_auto\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row type_default valign_top\"><div class=\"vc_col-sm-12 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>You can create a data table and share it with virtual assistants, apps and process assistants.<\/p>\n<p>Step to create a new table:<\/p>\n<ol>\n<li>Go to the <strong>Data <\/strong>tab in the Home page and select the <strong>Data Tables<\/strong> option and click <strong>Create Data Table<\/strong>.<a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145051\/create_table.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1886\" height=\"859\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145051\/create_table.png\" alt=\"\" class=\"alignnone size-medium wp-image-52250\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145051\/create_table.png 1886w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145051\/create_table-300x137.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145051\/create_table-1024x466.png 1024w\" sizes=\"auto, (max-width: 1886px) 100vw, 1886px\" \/><\/a><\/li>\n<li>Alternatively, click <strong>New Table<\/strong> to create a new data table..<a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145910\/create_table1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1043\" height=\"234\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145910\/create_table1.png\" alt=\"\" class=\"alignnone size-medium wp-image-52253\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145910\/create_table1.png 1043w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145910\/create_table1-300x67.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122145910\/create_table1-1024x230.png 1024w\" sizes=\"auto, (max-width: 1043px) 100vw, 1043px\" \/><\/a><\/li>\n<li>In the  New Table page, enter the following details:\n<ul>\n<li><strong>Name <\/strong>of the Data Table.<\/li>\n<li><strong>Description <\/strong>of the Data Table.<\/li>\n<li><strong>Columns<\/strong> to be included in the Table.<\/li>\n<li><strong>Indexes<\/strong> for the Table.<\/li>\n<li><strong>Bot Assignments<\/strong> to let virtual assistants access data in this table.<\/li>\n<li><strong>App Assignments<\/strong> to let apps access data in this table.<\/li>\n<li><strong>Process Assignments<\/strong> to let a process app access data in this table.<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122150957\/create_table2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1523\" height=\"835\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122150957\/create_table2.png\" alt=\"\" class=\"alignnone size-medium wp-image-52256\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122150957\/create_table2.png 1523w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122150957\/create_table2-300x164.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122150957\/create_table2-1024x561.png 1024w\" sizes=\"auto, (max-width: 1523px) 100vw, 1523px\" \/><\/a><\/li>\n<li>Click <strong>Create<\/strong>.<\/li>\n<\/ol>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h2><span class=\"ez-toc-section\" id=\"Columns\">Columns<\/span><\/h2>\n<p>The second step in defining a Data Table is to add columns required in the table.<\/p>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125146\/data_cols.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28016\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125146\/data_cols.png\" alt=\"\" width=\"1081\" height=\"427\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125146\/data_cols.png 1081w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125146\/data_cols-300x119.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125146\/data_cols-1024x404.png 1024w\" sizes=\"auto, (max-width: 1081px) 100vw, 1081px\" \/><\/a><\/p>\n<ul>\n<li><strong>Name<\/strong> of the column (<a href=\"#reserve-words\">see here<\/a> for reserve words which cannot be used as the name of a column);<\/li>\n<li><strong>Type<\/strong> of the data that can be stored in this column. It can be:\n<ul>\n<li>string;<\/li>\n<li>date; or<\/li>\n<li>number.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Required<\/strong> flag to mark the column as mandatory.<\/li>\n<li><strong>Encrypted<\/strong> flag to secure the data in this column.<\/li>\n<li><strong>Reference Column<\/strong> to create a dependency with a column from another table i.e. to add a foreign key constraint. This would ensure that the value entered for this column exists in the referenced table column.<\/li>\n<li><strong>Max Length<\/strong> to limit the maximum length for the column values.<\/li>\n<li><strong>Default Values<\/strong> to be taken in case the value is missing while adding a row.<\/li>\n<\/ul>\n<p>By default, the platform defines the following columns:<\/p>\n<ul>\n<li><strong>sys_Id<\/strong>: A platform generated unique identifier for each row in the table.<\/li>\n<li><strong>Created_On<\/strong>: Timestamp when this table was created.<\/li>\n<li><strong>Updated_On<\/strong>: Timestamp when this table was updated.<\/li>\n<li><strong>Created_By<\/strong>: User id of the developer who created this table.<\/li>\n<li><strong>Updated_By<\/strong>: User id of the developer who last updated this table.<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h2><span class=\"ez-toc-section\" id=\"Index\">Index<\/span><\/h2>\n<p>For an improved performance during Data search and retrieval, you can define Indices for your Data Table.<\/p>\n<p>This includes:<\/p>\n<ul>\n<li><strong>Index Name<\/strong> for reference.<\/li>\n<li><strong>Is Unique<\/strong> flag to define if the index is expected to contain unique values.<\/li>\n<li><strong>Column &amp; Sort Order<\/strong> &#8211; List of columns to be included in the index; you can select multiple columns and specify the sort order (ascending or descending) for each of the selected columns.<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125225\/data_index.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28018\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125225\/data_index.png\" alt=\"\" width=\"1075\" height=\"433\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125225\/data_index.png 1075w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125225\/data_index-300x121.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125225\/data_index-1024x412.png 1024w\" sizes=\"auto, (max-width: 1075px) 100vw, 1075px\" \/><\/a><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h2><span class=\"ez-toc-section\" id=\"Assignments\">Assignments<\/span><\/h2>\n<p>You can define the assignments for each of the data tables as follows:<\/p>\n<ul>\n<li><strong>Assign bots:<\/strong>\n<ul>\n<li>Assign bots with Read, Write, and Delete permissions. You can select the bots from the list presented, these will be the list of bots owned by you and shared with you.<\/li>\n<li>Only the assigned bots will be allowed to access the data from the data table using the Service Nodes in the Dialog Tasks of that bot.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Assign apps:<\/strong>\n<ul>\n<li>Assign apps with Read, Write, and Delete permissions.<\/li>\n<li>You can select from the list or create a new app.<\/li>\n<li>The data table CRUD APIs will be restricted to access only the tables that are assigned to the app.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Assign process apps:<\/strong>\n<ul>\n<li>Assign process apps with Read, Write, and Delete permissions. You can select the process apps from the list presented, these will be the list of process apps owned by you and shared with you.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125342\/data_assign.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28020\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125342\/data_assign.png\" alt=\"\" width=\"1068\" height=\"420\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125342\/data_assign.png 1068w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125342\/data_assign-300x118.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125342\/data_assign-1024x403.png 1024w\" sizes=\"auto, (max-width: 1068px) 100vw, 1068px\" \/><\/a><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h2><span class=\"ez-toc-section\" id=\"Import_Export\">Import &amp; Export<\/span><\/h2>\n<p>You can export and import Data Table definitions as JSON format files.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Export_a_Data_Table\">Export a Data Table<\/span><\/h3>\n<p>Steps:<\/p>\n<ol>\n<li>Hover over the table definition that you want to Export<\/li>\n<li>Click the more (ellipses) icon and select\u00a0<strong>Export Definition<\/strong><\/li>\n<li>A JSON file is generated and downloaded.<br \/>\n<a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125413\/data_options.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28022\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125413\/data_options.png\" alt=\"\" width=\"1119\" height=\"289\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125413\/data_options.png 1119w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125413\/data_options-300x77.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125413\/data_options-1024x264.png 1024w\" sizes=\"auto, (max-width: 1119px) 100vw, 1119px\" \/><\/a><\/li>\n<\/ol>\n<h3><span class=\"ez-toc-section\" id=\"Import_a_Data_Table\">Import a Data Table<\/span><\/h3>\n<p>Steps:<\/p>\n<ol>\n<li>Click the\u00a0<strong>down arrow<\/strong> next to the New Table button.<\/li>\n<li>Select the\u00a0<strong>Import Table Definition<\/strong> option.<\/li>\n<li>Enter a\u00a0<strong>Table Name<\/strong> and select the JSON file containing the table definition.<\/li>\n<li>Click\u00a0<strong>Import.<\/strong><br \/>\n<a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125525\/data_import.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28024\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125525\/data_import.png\" alt=\"\" width=\"1129\" height=\"261\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125525\/data_import.png 1129w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125525\/data_import-300x69.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125525\/data_import-1024x237.png 1024w\" sizes=\"auto, (max-width: 1129px) 100vw, 1129px\" \/><\/a><\/li>\n<\/ol>\n<p><strong>Sample Data Definition in the JSON file<\/strong><\/p>\n<pre>{\"name\":\"customertable\",\r\n \"description\":\"Table containing customer details\",\r\n \"indexes\":[],\r\n \"schemaDef\":[{\"name\":\"CustEmail\",\r\n               \"type\":\"string\",\r\n               \"isRequired\":false,\r\n               \"isEncrypted\":false,\r\n               \"reference\":{},\r\n               \"maxLength\":\"\",\r\n               \"default\":\"\"},\r\n\t      {\"name\":\"CustType\",\r\n               \"type\":\"string\",\r\n               \"isRequired\":false,\r\n               \"isEncrypted\":false,\r\n               \"reference\":{},\r\n               \"maxLength\":\"\",\r\n               \"default\":\"Preferred\"},\r\n\t      {\"name\":\"Address\",\r\n               \"type\":\"string\",\r\n               \"isRequired\":false,\r\n               \"isEncrypted\":false,\r\n               \"reference\":{},\r\n               \"maxLength\":\"\",\r\n               \"default\":\"\"},\r\n\t      {\"name\":\"CustName\",\r\n               \"type\":\"string\",\r\n               \"isRequired\":true,\r\n               \"isEncrypted\":false,\r\n               \"reference\":{},\r\n               \"maxLength\":\"\",\r\n               \"default\":\"\"},\r\n\t      {\"name\":\"CustId\",\r\n               \"type\":\"number\",\r\n               \"isRequired\":true,\r\n               \"isEncrypted\":true,\r\n               \"reference\":{},\r\n               \"maxLength\":\"5\",\r\n               \"default\":\"\"},\r\n\t      {\"name\":\"sys_Id\",\"type\":\"string\",\"isRequired\":true,\"readOnly\":true},\r\n\t      {\"name\":\"Created_On\",\"type\":\"date\",\"isRequired\":true,\"readOnly\":true},\r\n\t      {\"name\":\"Updated_On\",\"type\":\"date\",\"isRequired\":true,\"readOnly\":true},\r\n\t      {\"name\":\"Created_By\",\"type\":\"string\",\"isRequired\":true,\"readOnly\":true},\r\n\t      {\"name\":\"Updated_By\",\"type\":\"string\",\"isRequired\":true,\"readOnly\":true}]}<\/pre>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h2><span class=\"ez-toc-section\" id=\"Change_Table_Owner\">Change Table Owner<\/span><\/h2>\n<p>The table owner can transfer the ownership to another user to let them manage the table\u2019s definition and app assignments. An account administrator can also change the table owner.<\/p>\n<p>Steps to change the table owner:<\/p>\n<ol>\n<li>Hover over the data table for which you want to change owner.<\/li>\n<li>Click the more (ellipses) icon and select\u00a0<strong>Change Owner<\/strong> option.<a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122152708\/change_table_owner.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1895\" height=\"802\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122152708\/change_table_owner.png\" alt=\"\" class=\"alignnone size-medium wp-image-52260\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122152708\/change_table_owner.png 1895w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122152708\/change_table_owner-300x127.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122152708\/change_table_owner-1024x433.png 1024w\" sizes=\"auto, (max-width: 1895px) 100vw, 1895px\" \/><\/a><\/li>\n<li>In the Change Table Owner dialog, select the new owner from the list and click <strong>Proceed<\/strong>.<a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122153114\/change_table_owner2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"658\" height=\"549\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122153114\/change_table_owner2.png\" alt=\"\" class=\"alignnone size-medium wp-image-52263\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122153114\/change_table_owner2.png 658w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20230122153114\/change_table_owner2-300x250.png 300w\" sizes=\"auto, (max-width: 658px) 100vw, 658px\" \/><\/a><\/li>\n<li>Review the related tables associated with this table which may have changes in ownership.<\/li>\n<li>Once the ownership changes, a successful completion message will appear.<\/li>\n<li>Once the Ownership is changed, all related tables and views ownership is also transferred to the new owner. The table is moved to the new owner, and all the app assignments of these tables are lost.<br \/>\nThe Related tables and views refer to any associated table or view to a particular table based on the foreign key relations or view definitions. Following are the examples:<\/p>\n<ul>\n<li><strong>View 1<\/strong> is based on <strong>Table A<\/strong> and <strong>Table B<\/strong>.<\/li>\n<li><strong>View 2<\/strong> is based on <strong>Table A <\/strong>and <strong>Table C<\/strong>.<\/li>\n<li><strong>View 3<\/strong> is based on <strong>Table D<\/strong>.<\/li>\n<li><strong>Table E<\/strong> is not used in any <strong>View<\/strong>.<\/li>\n<li><strong>Table F<\/strong> column is referenced to a column in <strong>Table A<\/strong>.<\/li>\n<\/ul>\n<p><strong>Scenario 1<\/strong>: Change Owner action on <strong>Table A<\/strong> indicates that the ownership of <strong>Table B<\/strong>, <strong>Table C<\/strong>, <strong>Table F<\/strong>, <strong>View 1<\/strong>, and <strong>View 2<\/strong> is transferred.<\/p>\n<p><strong>Scenario 2<\/strong>: Change Owner action on <strong>Table F<\/strong> indicates that the ownership of <strong>Table A<\/strong>, <strong>Table B<\/strong>, <strong>Table C<\/strong>, <strong>View 1<\/strong>, and <strong>View 2<\/strong> is transferred.<\/li>\n<\/ol>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h2><span class=\"ez-toc-section\" id=\"Share_Data_Tables\">Share Data Tables<\/span><\/h2>\n<p>The Kore.ai XO Platform allows you to share Data Tables by assigning them to bots, process apps, or apps.<\/p>\n<p><strong>Note<\/strong>: In the <strong>Shared Tables<\/strong> tab, you can view only the tables shared with a user who has permission to view. When you share the data tables with users, they cannot edit or update the table or view definitions.<\/p>\n<p>The bot or process developers can see the data table definitions using a <a href=\"https:\/\/developer.kore.ai\/v10-1\/docs\/bots\/bot-builder-tool\/dialog-task\/data-as-service\/\"><strong>Service node<\/strong><\/a>.<\/p>\n<ul>\n<li>From the Data Service Request Definition, users can select the Get Data action and click Test to view metadata. For more information, read the <a href=\"https:\/\/developer.kore.ai\/v10-1\/docs\/bots\/bot-builder-tool\/dialog-task\/data-as-service\/#Get_Data\">Get Data<\/a> section in Data as a Service post.<\/li>\n<li>Users can also see all column names while configuring Add Data or Update Data actions. For more information, read the <a href=\"https:\/\/developer.kore.ai\/v10-1\/docs\/bots\/bot-builder-tool\/dialog-task\/data-as-service\/#Add_Data\">Add Data<\/a> section in the Data as a Service post.<\/li>\n<ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div>\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h2 id=\"reserve-words\"><span class=\"ez-toc-section\" id=\"Reserve_Words\">Reserve Words<\/span><\/h2>\n<p>Following is the list of words that are reserved and cannot be used as the names for a column:<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"g-cols wpb_row  type_default valign_top vc_inner \"><div class=\"vc_col-sm-4 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<ul>\n<li>ACCESS<\/li>\n<li>ADD<\/li>\n<li>ALL<\/li>\n<li>ALTER<\/li>\n<li>AND<\/li>\n<li>ANY<\/li>\n<li>AS<\/li>\n<li>ASC<\/li>\n<li>AUDIT<\/li>\n<li>BETWEEN<\/li>\n<li>BY<\/li>\n<li>CHAR\\<\/li>\n<li>CHECK<\/li>\n<li>CLUSTER<\/li>\n<li>COLUMN<\/li>\n<li>COMMENT<\/li>\n<li>COMPRESS<\/li>\n<li>CONNECT<\/li>\n<li>CREATE<\/li>\n<li>CURRENT<\/li>\n<li>DATE<\/li>\n<li>DECIMAL<\/li>\n<li>DEFAULT<\/li>\n<li>DELETE<\/li>\n<li>DESC<\/li>\n<li>DISTINCT<\/li>\n<li>DROP<\/li>\n<li>ELSE<\/li>\n<li>EXCLUSIVE<\/li>\n<li>EXISTS<\/li>\n<li>FILE<\/li>\n<li>FLOAT<\/li>\n<li>FOR<\/li>\n<li>FROM<\/li>\n<li>GRANT<\/li>\n<li>GROUP<\/li>\n<li>HAVING<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><div class=\"vc_col-sm-4 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<ul>\n<li>IDENTIFIED<\/li>\n<li>IMMEDIATE<\/li>\n<li>IN<\/li>\n<li>INCREMENT<\/li>\n<li>INDEX<\/li>\n<li>INITIAL<\/li>\n<li>INSERT<\/li>\n<li>INTEGER<\/li>\n<li>INTERSECT<\/li>\n<li>INTO<\/li>\n<li>IS<\/li>\n<li>LEVEL<\/li>\n<li>LIKE<\/li>\n<li>LOCK<\/li>\n<li>LONG<\/li>\n<li>MAXEXTENTS<\/li>\n<li>MINUS<\/li>\n<li>MLSLABEL<\/li>\n<li>MODE<\/li>\n<li>MODIFY<\/li>\n<li>NOAUDIT<\/li>\n<li>NOCOMPRESS<\/li>\n<li>NOT<\/li>\n<li>NOWAIT<\/li>\n<li>NULL<\/li>\n<li>NUMBER<\/li>\n<li>OF<\/li>\n<li>ONLINE<\/li>\n<li>ON<\/li>\n<li>OFFLINE<\/li>\n<li>OPTION<\/li>\n<li>ON<\/li>\n<li>ORDER<\/li>\n<li>PCTFREE<\/li>\n<li>PRIOR<\/li>\n<li>PRIVILEGES<\/li>\n<li>PUBLIC<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><div class=\"vc_col-sm-4 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<ul>\n<li>RAW<\/li>\n<li>RENAME<\/li>\n<li>RESOURCE<\/li>\n<li>REVOKE<\/li>\n<li>ROW<\/li>\n<li>ROWID<\/li>\n<li>RONUM<\/li>\n<li>ROWS<\/li>\n<li>SELECT<\/li>\n<li>SESSION<\/li>\n<li>SET<\/li>\n<li>SHARE<\/li>\n<li>SIZE<\/li>\n<li>SMALLINT<\/li>\n<li>START<\/li>\n<li>SUCCESSFUL<\/li>\n<li>SYNONYM<\/li>\n<li>SYSDATE<\/li>\n<li>TABLE<\/li>\n<li>THEN<\/li>\n<li>TO<\/li>\n<li>TRIGGER<\/li>\n<li>UID<\/li>\n<li>UNION<\/li>\n<li>UNIQUE<\/li>\n<li>UPDATE<\/li>\n<li>USER<\/li>\n<li>VALIDATE<\/li>\n<li>VALUES<\/li>\n<li>VARCHAR<\/li>\n<li>VARCHAR2<\/li>\n<li>VIEW<\/li>\n<li>WHENEVER<\/li>\n<li>WHERE<\/li>\n<li>WITH<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><\/div><div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"You can create a data table and share it with virtual assistants, apps and process assistants. Step to create a new table: Go to the Data tab in the Home page and select the Data Tables option and click Create Data Table. Alternatively, click New Table to create a new data table.. In the New...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-29221","post","type-post","status-publish","format-standard","hentry","category-advanced-topics"],"_links":{"self":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/29221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/comments?post=29221"}],"version-history":[{"count":10,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/29221\/revisions"}],"predecessor-version":[{"id":55898,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/29221\/revisions\/55898"}],"wp:attachment":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/media?parent=29221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/categories?post=29221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/tags?post=29221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}