Visualization Code Example for SQL Scripts - Teradata AppCenter

Teradata® AppCenter User Guide

Product
Teradata AppCenter
Release Number
1.8
Published
May 2019
Language
English (United States)
Last Update
2019-10-16
dita:mapPath
nlh1545080689918.ditamap
dita:ditavalPath
boe1555608925945.ditaval
dita:id
B035-1111
lifecycle
previous
Product Category
Analytical Ecosystem

The code for each visualization type must include --name= type, where type can be anything, followed by the SQL. For example:

--name=bar1
select original_service, complete from appcenter_user.sdabc;

--name=line1
select original_service, complete from appcenter_user.sdabc;

--name=wordcloud1
select original_service as term, complete as tf_idf from appcenter_user.sdabc;

--name=bar2
select original_service, reduced_volume from appcenter_user.sdabc;

--name=line2
select original_service, reduced_volume from appcenter_user.sdabc;

--name=wordcloud2
select original_service as term, reduced_volume as tf_idf from appcenter_user.sdabc;

--name=bar3
select original_service, percent_reduced_volume from appcenter_user.sdabc;

--name=line3
select original_service, percent_reduced_volume from appcenter_user.sdabc;

--name=wordcloud3
select original_service as term, percent_reduced_volume as tf_idf from appcenter_user.sdabc;

--name=line3
select original_service, percent_reduced_volume from appcenter_user.sdabc;

--name=wordcloud3
select original_service as term, percent_reduced_volume as tf_idf from appcenter_user.sdabc;