{"id":2757,"date":"2023-03-27T06:05:25","date_gmt":"2023-03-27T11:05:25","guid":{"rendered":"https:\/\/www.dpriver.com\/blog\/?p=2757"},"modified":"2023-03-27T06:06:18","modified_gmt":"2023-03-27T11:06:18","slug":"visualize-selected-data-with-sqlflow-rest-api-in-job-mode","status":"publish","type":"post","link":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/","title":{"rendered":"Visualize selected data with SQLFlow REST API in Job mode"},"content":{"rendered":"\n<p><strong><a href=\"https:\/\/www.gudusoft.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Gudu SQLFlow<\/a><\/strong> is an analysis software for analyzing SQL statements and discovering <strong><a href=\"https:\/\/www.dpriver.com\/blog\/2022\/05\/11\/best-data-lineage-tools\/\" target=\"_blank\" rel=\"noreferrer noopener\">data lineage<\/a><\/strong> relationships. It is often used with <a href=\"https:\/\/www.gudusoft.com\/what-is-metadata-management\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>metadata management<\/strong><\/a> tools and is a basic tool for <a href=\"https:\/\/www.gudusoft.com\/challenges-facing-enterprise-data-governance\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>enterprise data governance<\/strong><\/a>. Check <a href=\"https:\/\/www.dpriver.com\/blog\/2022\/08\/20\/introduction-of-gudu-sqlflow\/\" target=\"_blank\" rel=\"noreferrer noopener\">this introduction blog<\/a> if you don\u2019t know much about Gudu SQLFlow.<\/p>\n\n\n\n<p>Gudu SQLFlow can analyze your SQL data and generate report in different formats, including <strong>Json, XML, CSV and image(PNG\/JPEG)<\/strong>. Gudu SQLFlow provides you different choices to visualize your data, <a href=\"https:\/\/docs.gudusoft.com\/3.-api-docs\/using-the-rest-api\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow REST API<\/a> is one of the most commonly used features. Your data analysis result will be generated and returned from SQLFlow server by sending standard parameterized RESTFul Api request.<\/p>\n\n\n\n<p>In this article, we will show you how to create SQLFlow Job and visualize the selected data with SQLFlow REST API.<\/p>\n\n\n\n<p>Let&#8217;s say from database, we have got the following DDL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE VIEW vsal \nAS \n  SELECT a.deptno                  \"Department\", \n         a.num_emp \/ b.total_count \"Employees\", \n         a.sal_sum \/ b.total_sal   \"Salary\" \n  FROM   (SELECT deptno, \n                 Count()  num_emp, \n                 SUM(sal) sal_sum \n          FROM   scott.emp \n          WHERE  city = 'NYC' \n          GROUP  BY deptno) a, \n         (SELECT Count()  total_count, \n                 SUM(sal) total_sal \n          FROM   scott.emp \n          WHERE  city = 'NYC') b \n;\n\nINSERT ALL\n\tWHEN ottl &lt; 100000 THEN\n\t\tINTO small_orders\n\t\t\tVALUES(oid, ottl, sid, cid)\n\tWHEN ottl &gt; 100000 and ottl &lt; 200000 THEN\n\t\tINTO medium_orders\n\t\t\tVALUES(oid, ottl, sid, cid)\n\tWHEN ottl &gt; 200000 THEN\n\t\tinto large_orders\n\t\t\tVALUES(oid, ottl, sid, cid)\n\tWHEN ottl &gt; 290000 THEN\n\t\tINTO special_orders\nSELECT o.order_id oid, o.customer_id cid, o.order_total ottl,\no.sales_rep_id sid, c.credit_limit cl, c.cust_email cem\nFROM orders o, customers c\nWHERE o.customer_id = c.customer_id;\n\ncreate table scott.dept(   \n  deptno     number(2,0),   \n  dname      varchar2(14),   \n  loc        varchar2(13),   \n  constraint pk_dept primary key (deptno)   \n);\n\ncreate table scott.emp(   \n  empno    number(4,0),   \n  ename    varchar2(10),   \n  job      varchar2(9),   \n  mgr      number(4,0),   \n  hiredate date,   \n  sal      number(7,2),   \n  comm     number(7,2),   \n  deptno   number(2,0),   \n  constraint pk_emp primary key (empno),\n  constraint fk_deptno foreign key (deptno) references dept (deptno) \n);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">The API Endpoints<\/h2>\n\n\n\n<p>The related SQLFlow Api to visualize selected data is:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/sqlflow\/generation\/sqlflow\/selectedgraph\/image<\/code><\/pre>\n\n\n\n<p>The <code>selectedgraph\/image<\/code> will take the session Id as the input and it generates the data lineage image based on the given sessionId. Therefore, before invoking the above api to get the selected data, we have to firstly call a SQLFlow endpoint to analyze the database\/SQL file\/ SQL text so that we can <em>select data<\/em> and get the session Id.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create SQLFlow Job<\/h2>\n\n\n\n<p>The following endpoint is to create a SQLFlow:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/sqlflow\/job\/submitUserJob<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"835\" height=\"1024\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327182936-835x1024.png\" alt=\"\" class=\"wp-image-2781\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327182936-835x1024.png 835w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327182936-245x300.png 245w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327182936-768x942.png 768w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327182936.png 902w\" sizes=\"(max-width: 835px) 100vw, 835px\" \/><\/figure>\n\n\n\n<p><strong><em>Hint<\/em><\/strong>:\u00a0<a href=\"https:\/\/www.gudusoft.com\/sqlflow-on-premise-version\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow On-Premise<\/a>\u00a0is used in the above capture, hence token is not required and only userId is given in param. Please refer to\u00a0<a href=\"https:\/\/docs.gudusoft.com\/3.-api-docs\/prerequisites\" target=\"_blank\" rel=\"noreferrer noopener\">this document<\/a>\u00a0to check how to get the userid and the token.<\/p>\n\n\n\n<p>Wait few seconds and If we check our job list, we should have this <em>demoJob2<\/em> in our job success list. You can verify that ethiter go to the SQLFlow interface or use another SQLFlow REST API <code>\/sqlflow\/job\/displayUserJobsSummary<\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"394\" height=\"113\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327183052.png\" alt=\"\" class=\"wp-image-2782\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327183052.png 394w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327183052-300x86.png 300w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/><\/figure>\n\n\n\n<p>Great! After checking the SQLFlow web, we have confirmed the SQLFlow Job is succeeded. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Retrieve Data Session<\/h2>\n\n\n\n<p>Now we have our Job created and we need select our data now. To do that, invoke:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/sqlflow\/job\/displayUserJobGraph<\/code><\/pre>\n\n\n\n<p>Give the Job Id as the input and in the response of the above API, we will have the sessionId:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"876\" height=\"1024\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327185358-876x1024.png\" alt=\"\" class=\"wp-image-2783\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327185358-876x1024.png 876w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327185358-257x300.png 257w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327185358-768x898.png 768w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327185358.png 988w\" sizes=\"(max-width: 876px) 100vw, 876px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Visualize Selected Data<\/h2>\n\n\n\n<p>With the sessionId, now we can invoke <code>\/sqlflow\/generation\/sqlflow\/selectedgraph\/image<\/code> to generate the selected data element.<\/p>\n\n\n\n<p>Let&#8217;s say we want retrieve data lineage related to <em><strong>table<\/strong><\/em> <em><strong>orders<\/strong><\/em>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"902\" src=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327190021-1024x902.png\" alt=\"\" class=\"wp-image-2784\" srcset=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327190021-1024x902.png 1024w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327190021-300x264.png 300w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327190021-768x676.png 768w, https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/\u5fae\u4fe1\u622a\u56fe_20230327190021.png 1196w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Simple give the table name that we want in the request and the data lineage image will be returned. In this example we are not giving the previous job id that we created, you can give that Id if you prefer to use the Job settings when you created the SQLFlow Job for the generated image.<\/p>\n\n\n\n<p>We can also give other filters to select different data such as column, schema etc&#8230; <\/p>\n\n\n\n<p>Check <a href=\"https:\/\/docs.gudusoft.com\/3.-api-docs\/sqlflow-rest-api-reference\/generation-interface\/sqlflow-generation-sqlflow-selectedgraph-image\" target=\"_blank\" rel=\"noreferrer noopener\">this doc<\/a> to get all available parameters for the endpoint.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Online Web Tool<\/h2>\n\n\n\n<p>You can get more information about <a href=\"https:\/\/www.gudusoft.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQLFlow<\/a> with the<a href=\"https:\/\/sqlflow.gudusoft.com\/#\/\" target=\"_blank\" rel=\"noreferrer noopener\"> online demo<\/a>. The online web tool uses SQLFlow API to generate the result. You can also build your own web tool with the help of SQLFlow REST API. Check this fantastic data visualization tool today!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gudu SQLFlow is an analysis software for analyzing SQL statements and discovering data lineage relationships. It is often used with metadata management tools and is a basic tool for enterprise data governance. Check this introduction blog if you don\u2019t know much about Gudu SQLFlow. Gudu SQLFlow can analyze your SQL data and generate report in different formats, including Json, XML, CSV and image(PNG\/JPEG). Gudu SQLFlow provides you different choices to visualize your data, SQLFlow REST API is one of the most commonly used features. Your data analysis result will be generated and returned from SQLFlow server by sending standard parameterized\u2026<\/p>\n","protected":false},"author":6,"featured_media":2761,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[66,93],"tags":[116],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Visualize selected data with SQLFlow REST API in Job mode<\/title>\n<meta name=\"description\" content=\"Visualize my data; Generate data lineage; SQLFlow REST API; Partial data visualization; Data governance &amp; SQLFlow\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Visualize selected data with SQLFlow REST API in Job mode\" \/>\n<meta property=\"og:description\" content=\"Visualize my data; Generate data lineage; SQLFlow REST API; Partial data visualization; Data governance &amp; SQLFlow\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and Data Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-27T11:05:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-27T11:06:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/desk-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"921\" \/>\n\t<meta property=\"og:image:height\" content=\"691\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"leo gu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"leo gu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\",\"name\":\"SQL and Data Blog\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"contentUrl\":\"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png\",\"width\":251,\"height\":72,\"caption\":\"SQL and Data Blog\"},\"image\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\",\"url\":\"https:\/\/www.dpriver.com\/blog\/\",\"name\":\"SQL and Data Blog\",\"description\":\"SQL related blog for database professional\",\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/\",\"url\":\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/\",\"name\":\"Visualize selected data with SQLFlow REST API in Job mode\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#website\"},\"datePublished\":\"2023-03-27T11:05:25+00:00\",\"dateModified\":\"2023-03-27T11:06:18+00:00\",\"description\":\"Visualize my data; Generate data lineage; SQLFlow REST API; Partial data visualization; Data governance & SQLFlow\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dpriver.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Visualize selected data with SQLFlow REST API in Job mode\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/\"},\"author\":{\"name\":\"leo gu\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/9e80d249b6da4e572bd8590b0789bc14\"},\"headline\":\"Visualize selected data with SQLFlow REST API in Job mode\",\"datePublished\":\"2023-03-27T11:05:25+00:00\",\"dateModified\":\"2023-03-27T11:06:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/\"},\"wordCount\":511,\"publisher\":{\"@id\":\"https:\/\/www.dpriver.com\/blog\/#organization\"},\"keywords\":[\"SQLFlow Rest API\"],\"articleSection\":[\"Data Governance\",\"SQLFlow\"],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/9e80d249b6da4e572bd8590b0789bc14\",\"name\":\"leo gu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/24976e2e4ca7dd476652bb26bd09392b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/24976e2e4ca7dd476652bb26bd09392b?s=96&d=mm&r=g\",\"caption\":\"leo gu\"},\"url\":\"https:\/\/www.dpriver.com\/blog\/author\/guyuanhao\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Visualize selected data with SQLFlow REST API in Job mode","description":"Visualize my data; Generate data lineage; SQLFlow REST API; Partial data visualization; Data governance & SQLFlow","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:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/","og_locale":"en_US","og_type":"article","og_title":"Visualize selected data with SQLFlow REST API in Job mode","og_description":"Visualize my data; Generate data lineage; SQLFlow REST API; Partial data visualization; Data governance & SQLFlow","og_url":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/","og_site_name":"SQL and Data Blog","article_published_time":"2023-03-27T11:05:25+00:00","article_modified_time":"2023-03-27T11:06:18+00:00","og_image":[{"width":921,"height":691,"url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2023\/03\/desk-1.jpg","type":"image\/jpeg"}],"author":"leo gu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"leo gu","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/www.dpriver.com\/blog\/#organization","name":"SQL and Data Blog","url":"https:\/\/www.dpriver.com\/blog\/","sameAs":[],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","contentUrl":"https:\/\/www.dpriver.com\/blog\/wp-content\/uploads\/2022\/07\/sqlpp-character.png","width":251,"height":72,"caption":"SQL and Data Blog"},"image":{"@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"WebSite","@id":"https:\/\/www.dpriver.com\/blog\/#website","url":"https:\/\/www.dpriver.com\/blog\/","name":"SQL and Data Blog","description":"SQL related blog for database professional","publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dpriver.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/","url":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/","name":"Visualize selected data with SQLFlow REST API in Job mode","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/#website"},"datePublished":"2023-03-27T11:05:25+00:00","dateModified":"2023-03-27T11:06:18+00:00","description":"Visualize my data; Generate data lineage; SQLFlow REST API; Partial data visualization; Data governance & SQLFlow","breadcrumb":{"@id":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dpriver.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Visualize selected data with SQLFlow REST API in Job mode"}]},{"@type":"Article","@id":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/#article","isPartOf":{"@id":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/"},"author":{"name":"leo gu","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/9e80d249b6da4e572bd8590b0789bc14"},"headline":"Visualize selected data with SQLFlow REST API in Job mode","datePublished":"2023-03-27T11:05:25+00:00","dateModified":"2023-03-27T11:06:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dpriver.com\/blog\/visualize-selected-data-with-sqlflow-rest-api-in-job-mode\/"},"wordCount":511,"publisher":{"@id":"https:\/\/www.dpriver.com\/blog\/#organization"},"keywords":["SQLFlow Rest API"],"articleSection":["Data Governance","SQLFlow"],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/9e80d249b6da4e572bd8590b0789bc14","name":"leo gu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dpriver.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/24976e2e4ca7dd476652bb26bd09392b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/24976e2e4ca7dd476652bb26bd09392b?s=96&d=mm&r=g","caption":"leo gu"},"url":"https:\/\/www.dpriver.com\/blog\/author\/guyuanhao\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2757"}],"collection":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/comments?post=2757"}],"version-history":[{"count":5,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2757\/revisions"}],"predecessor-version":[{"id":2785,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/posts\/2757\/revisions\/2785"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media\/2761"}],"wp:attachment":[{"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/media?parent=2757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/categories?post=2757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dpriver.com\/blog\/wp-json\/wp\/v2\/tags?post=2757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}