crate.io
Open in
urlscan Pro
2a04:4e42:200::425
Public Scan
Submitted URL: https://d2lys404.na1.hubspotlinks.com/Btc/I7+113/d2lyS404/VWKjN88kb80JN7d0DpFfkq9VW7TctdS4FmDvxN3kz7Fp3lScZV1-WJV7CgLb0W29pPl-5pcln-N2...
Effective URL: https://crate.io/blog/use-cratedb-and-apache-superset-for-open-source-data-warehousing-and-visualization?utm_medi...
Submission: On February 11 via api from IE — Scanned from DE
Effective URL: https://crate.io/blog/use-cratedb-and-apache-superset-for-open-source-data-warehousing-and-visualization?utm_medi...
Submission: On February 11 via api from IE — Scanned from DE
Form analysis 2 forms found in the DOM
POST https://forms.hsforms.com/submissions/v3/public/submit/formsnext/multipart/19927462/cd56051e-10c0-413f-b5a5-67bab9688e9b
<form novalidate="" accept-charset="UTF-8" action="https://forms.hsforms.com/submissions/v3/public/submit/formsnext/multipart/19927462/cd56051e-10c0-413f-b5a5-67bab9688e9b" enctype="multipart/form-data"
id="hsForm_cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" method="POST"
class="hs-form stacked hs-custom-form hs-form-private hsForm_cd56051e-10c0-413f-b5a5-67bab9688e9b hs-form-cd56051e-10c0-413f-b5a5-67bab9688e9b hs-form-cd56051e-10c0-413f-b5a5-67bab9688e9b_34dd628c-c767-4570-b8a3-2f304e10cb7e"
data-form-id="cd56051e-10c0-413f-b5a5-67bab9688e9b" data-portal-id="19927462" target="target_iframe_cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" data-reactid=".hbspt-forms-1" data-hs-cf-bound="true">
<fieldset class="form-columns-2" data-reactid=".hbspt-forms-1.1:$0">
<div class="hs_firstname hs-firstname hs-fieldtype-text field hs-form-field" data-reactid=".hbspt-forms-1.1:$0.1:$firstname"><label id="label-firstname-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" class="" placeholder="Enter your "
for="firstname-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" data-reactid=".hbspt-forms-1.1:$0.1:$firstname.0"><span data-reactid=".hbspt-forms-1.1:$0.1:$firstname.0.0"></span></label>
<legend class="hs-field-desc" style="display:none;" data-reactid=".hbspt-forms-1.1:$0.1:$firstname.1"></legend>
<div class="input" data-reactid=".hbspt-forms-1.1:$0.1:$firstname.$firstname"><input id="firstname-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" class="hs-input" type="text" name="firstname" value="" placeholder="First Name"
autocomplete="given-name" data-reactid=".hbspt-forms-1.1:$0.1:$firstname.$firstname.0" inputmode="text"></div>
</div>
<div class="hs_lastname hs-lastname hs-fieldtype-text field hs-form-field" data-reactid=".hbspt-forms-1.1:$0.1:$lastname"><label id="label-lastname-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" class="" placeholder="Enter your "
for="lastname-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" data-reactid=".hbspt-forms-1.1:$0.1:$lastname.0"><span data-reactid=".hbspt-forms-1.1:$0.1:$lastname.0.0"></span></label>
<legend class="hs-field-desc" style="display:none;" data-reactid=".hbspt-forms-1.1:$0.1:$lastname.1"></legend>
<div class="input" data-reactid=".hbspt-forms-1.1:$0.1:$lastname.$lastname"><input id="lastname-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" class="hs-input" type="text" name="lastname" value="" placeholder="Last Name" autocomplete="family-name"
data-reactid=".hbspt-forms-1.1:$0.1:$lastname.$lastname.0" inputmode="text"></div>
</div>
</fieldset>
<fieldset class="form-columns-1" data-reactid=".hbspt-forms-1.1:$1">
<div class="hs_email hs-email hs-fieldtype-text field hs-form-field" data-reactid=".hbspt-forms-1.1:$1.1:$email"><label id="label-email-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" class="" placeholder="Enter your "
for="email-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" data-reactid=".hbspt-forms-1.1:$1.1:$email.0"><span data-reactid=".hbspt-forms-1.1:$1.1:$email.0.0"></span></label>
<legend class="hs-field-desc" style="display:none;" data-reactid=".hbspt-forms-1.1:$1.1:$email.1"></legend>
<div class="input" data-reactid=".hbspt-forms-1.1:$1.1:$email.$email"><input id="email-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" class="hs-input" type="email" name="email" required="" placeholder="Email Address*" value="" autocomplete="email"
data-reactid=".hbspt-forms-1.1:$1.1:$email.$email.0" inputmode="email"></div>
</div>
</fieldset>
<fieldset class="form-columns-1" data-reactid=".hbspt-forms-1.2">
<div class="legal-consent-container" data-reactid=".hbspt-forms-1.2.0">
<div class="hs-richtext" data-reactid=".hbspt-forms-1.2.0.0">
<p>From time to time, we would like to contact you about our products and services. If you consent to us contacting you for this purpose, please tick the box below.</p>
</div>
<div data-reactid=".hbspt-forms-1.2.0.1:0">
<div class="hs-dependent-field" data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772">
<div class="hs_LEGAL_CONSENT.subscription_type_13036772 hs-LEGAL_CONSENT.subscription_type_13036772 hs-fieldtype-booleancheckbox field hs-form-field"
data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772">
<legend class="hs-field-desc" style="display:none;" data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.1"></legend>
<div class="input" data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772">
<ul class="inputs-list" data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.0">
<li class="hs-form-booleancheckbox" data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.0.0"><label
for="LEGAL_CONSENT.subscription_type_13036772-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" class="hs-form-booleancheckbox-display"
data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.0.0.0"><input
id="LEGAL_CONSENT.subscription_type_13036772-cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" class="hs-input" type="checkbox" name="LEGAL_CONSENT.subscription_type_13036772" value="true"
data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.0.0.0.0"><span
data-reactid=".hbspt-forms-1.2.0.1:0.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.$LEGAL_CONSENT=1subscription_type_13036772.0.0.0.1">
<p>I agree to receive marketing communications from Crate.io.</p>
</span></label></li>
</ul>
</div>
</div>
</div>
<legend class="hs-field-desc checkbox-desc" style="display:none;" data-reactid=".hbspt-forms-1.2.0.1:0.1"></legend>
</div>
<div class="hs-richtext" data-reactid=".hbspt-forms-1.2.0.2">
<p>You can unsubscribe from these communications at any time. For more information, please review our <a href="https://crate.io/legal/privacy-policy/" target="_blank">Privacy Policy.</a></p>
</div>
<div class="hs-richtext" data-reactid=".hbspt-forms-1.2.0.3">
<p>By clicking below, you consent to allow Crate.io to store and process the personal information submitted above to provide you the content requested.</p>
</div>
</div>
</fieldset>
<div class="hs_submit hs-submit" data-reactid=".hbspt-forms-1.5">
<div class="hs-field-desc" style="display:none;" data-reactid=".hbspt-forms-1.5.0"></div>
<div class="actions" data-reactid=".hbspt-forms-1.5.1"><input type="submit" value="Submit" class="hs-button primary large" data-reactid=".hbspt-forms-1.5.1.0"></div>
</div><noscript data-reactid=".hbspt-forms-1.6"></noscript><input name="hs_context" type="hidden"
value="{"rumScriptExecuteTime":1382.1000003814697,"rumServiceResponseTime":1606.5,"rumFormRenderTime":1.2000007629394531,"rumTotalRenderTime":1629.3999996185303,"rumTotalRequestTime":223.30000114440918,"lang":"en","legalConsentOptions":"{\"communicationConsentCheckboxes\":[{\"communicationTypeId\":13036772,\"label\":\"<p>I agree to receive marketing communications from Crate.io.</p>\",\"required\":false}],\"legitimateInterestLegalBasis\":\"LEGITIMATE_INTEREST_PQL\",\"communicationConsentText\":\"<p>From time to time, we would like to contact you about our products and services. If you consent to us contacting you for this purpose, please tick the box below.</p>\",\"processingConsentType\":\"IMPLICIT\",\"processingConsentText\":\"<p>By clicking below, you consent to allow Crate.io to store and process the personal information submitted above to provide you the content requested.</p>\",\"processingConsentCheckboxLabel\":\"I agree to allow Crate.io to store and process my personal data.\",\"privacyPolicyText\":\"<p>You can unsubscribe from these communications at any time. For more information, please review our <a href=\\\"https://crate.io/legal/privacy-policy/\\\" target=\\\"_blank\\\">Privacy Policy.</a></p>\",\"isLegitimateInterest\":false}","embedAtTimestamp":"1644553392152","formDefinitionUpdatedAt":"1638188969365","pageUrl":"https://crate.io/blog/use-cratedb-and-apache-superset-for-open-source-data-warehousing-and-visualization?utm_medium=email&_hsmi=203508553&_hsenc=p2ANqtz-9TaamTm5Wi7KOyzBvrJvpyNiS-0dzC1NJmN6Z4pjbvIybTse_WBRQ6ZYCdrtaSmh-KqE5pTugpSmP2S37aSqakf8l_qYJwlJ6DM98bQJExgdM3wn8&utm_content=203508553&utm_source=hs_email","pageTitle":"Use CrateDB and Apache Superset for Open Source Data Warehousing and Visualization","source":"FormsNext-static-5.450","sourceName":"FormsNext","sourceVersion":"5.450","sourceVersionMajor":"5","sourceVersionMinor":"450","timestamp":1644553392155,"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.80 Safari/537.36","originalEmbedContext":{"portalId":"19927462","formId":"cd56051e-10c0-413f-b5a5-67bab9688e9b","formInstanceId":"6382","pageId":"63035256239","region":"na1","pageName":"Use CrateDB and Apache Superset for Open Source Data Warehousing and Visualization","inlineMessage":true,"rawInlineMessage":"Thanks for submitting the form.","hsFormKey":"c743397cf3d41e8511269f9a29aa4e0a","target":"#hs_form_target_form_197959341","contentType":"blog-post","formsBaseUrl":"/_hcms/forms/","formData":{"cssClass":"hs-form stacked hs-custom-form"}},"canonicalUrl":"https://crate.io/blog/use-cratedb-and-apache-superset-for-open-source-data-warehousing-and-visualization","pageId":"63035256239","pageName":"Use CrateDB and Apache Superset for Open Source Data Warehousing and Visualization","boolCheckBoxFields":"LEGAL_CONSENT.subscription_type_13036772","formInstanceId":"6382","urlParams":{"utm_medium":"email","_hsmi":"203508553","_hsenc":"p2ANqtz-9TaamTm5Wi7KOyzBvrJvpyNiS-0dzC1NJmN6Z4pjbvIybTse_WBRQ6ZYCdrtaSmh-KqE5pTugpSmP2S37aSqakf8l_qYJwlJ6DM98bQJExgdM3wn8","utm_content":"203508553","utm_source":"hs_email"},"renderedFieldsIds":["firstname","lastname","email","LEGAL_CONSENT.subscription_type_13036772"],"rawInlineMessage":"Thanks for submitting the form.","hsFormKey":"c743397cf3d41e8511269f9a29aa4e0a","formTarget":"#hs_form_target_form_197959341","correlationId":"39f96f0f-3466-4f06-8e3b-a055d27c4384","contentType":"blog-post","hutk":"c1efa8a205ec02a622d9db2de1465063","captchaStatus":"NOT_APPLICABLE","isHostedOnHubspot":true}"
data-reactid=".hbspt-forms-1.7"><iframe name="target_iframe_cd56051e-10c0-413f-b5a5-67bab9688e9b_6382" style="display:none;" data-reactid=".hbspt-forms-1.8"></iframe>
</form>POST https://forms.hsforms.com/submissions/v3/public/submit/formsnext/multipart/19927462/76d1441f-eef8-4e8e-950d-9b66bf24bd8e
<form novalidate="" accept-charset="UTF-8" action="https://forms.hsforms.com/submissions/v3/public/submit/formsnext/multipart/19927462/76d1441f-eef8-4e8e-950d-9b66bf24bd8e" enctype="multipart/form-data"
id="hsForm_76d1441f-eef8-4e8e-950d-9b66bf24bd8e_5401" method="POST"
class="hs-form stacked hs-custom-form hs-form-private hsForm_76d1441f-eef8-4e8e-950d-9b66bf24bd8e hs-form-76d1441f-eef8-4e8e-950d-9b66bf24bd8e hs-form-76d1441f-eef8-4e8e-950d-9b66bf24bd8e_aba53b38-b52d-4b47-b9b8-34b3345689d9"
data-form-id="76d1441f-eef8-4e8e-950d-9b66bf24bd8e" data-portal-id="19927462" target="target_iframe_76d1441f-eef8-4e8e-950d-9b66bf24bd8e_5401" data-reactid=".hbspt-forms-0" data-hs-cf-bound="true">
<div class="hs_email hs-email hs-fieldtype-text field hs-form-field" data-reactid=".hbspt-forms-0.1:$0"><label id="label-email-76d1441f-eef8-4e8e-950d-9b66bf24bd8e_5401" class="" placeholder="Enter your "
for="email-76d1441f-eef8-4e8e-950d-9b66bf24bd8e_5401" data-reactid=".hbspt-forms-0.1:$0.0"><span data-reactid=".hbspt-forms-0.1:$0.0.0"></span></label>
<legend class="hs-field-desc" style="display:none;" data-reactid=".hbspt-forms-0.1:$0.1"></legend>
<div class="input" data-reactid=".hbspt-forms-0.1:$0.$email"><input id="email-76d1441f-eef8-4e8e-950d-9b66bf24bd8e_5401" class="hs-input" type="email" name="email" required="" placeholder="Your email address*" value="" autocomplete="email"
data-reactid=".hbspt-forms-0.1:$0.$email.0" inputmode="email"></div>
</div><noscript data-reactid=".hbspt-forms-0.2"></noscript>
<div class="hs_submit hs-submit" data-reactid=".hbspt-forms-0.5">
<div class="hs-field-desc" style="display:none;" data-reactid=".hbspt-forms-0.5.0"></div>
<div class="actions" data-reactid=".hbspt-forms-0.5.1"><input type="submit" value="Subscribe" class="hs-button primary large" data-reactid=".hbspt-forms-0.5.1.0"></div>
</div><noscript data-reactid=".hbspt-forms-0.6"></noscript><input name="hs_context" type="hidden"
value="{"rumScriptExecuteTime":1382.1000003814697,"rumServiceResponseTime":1606.1999988555908,"rumFormRenderTime":2.299999237060547,"rumTotalRenderTime":1609.2999992370605,"rumTotalRequestTime":205,"lang":"en","embedType":"REGULAR","renderRawHtml":"true","embedAtTimestamp":"1644553392152","formDefinitionUpdatedAt":"1637246540258","pageUrl":"https://crate.io/blog/use-cratedb-and-apache-superset-for-open-source-data-warehousing-and-visualization?utm_medium=email&_hsmi=203508553&_hsenc=p2ANqtz-9TaamTm5Wi7KOyzBvrJvpyNiS-0dzC1NJmN6Z4pjbvIybTse_WBRQ6ZYCdrtaSmh-KqE5pTugpSmP2S37aSqakf8l_qYJwlJ6DM98bQJExgdM3wn8&utm_content=203508553&utm_source=hs_email","pageTitle":"Use CrateDB and Apache Superset for Open Source Data Warehousing and Visualization","source":"FormsNext-static-5.450","sourceName":"FormsNext","sourceVersion":"5.450","sourceVersionMajor":"5","sourceVersionMinor":"450","timestamp":1644553392152,"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.80 Safari/537.36","originalEmbedContext":{"portalId":"19927462","formId":"76d1441f-eef8-4e8e-950d-9b66bf24bd8e","formInstanceId":"5401","pageId":"63035256239","region":"na1","pageName":"Use CrateDB and Apache Superset for Open Source Data Warehousing and Visualization","target":"#hs_form_target_form_56148974","contentType":"blog-post","formsBaseUrl":"/_hcms/forms/","formData":{"cssClass":"hs-form stacked hs-custom-form"}},"canonicalUrl":"https://crate.io/blog/use-cratedb-and-apache-superset-for-open-source-data-warehousing-and-visualization","pageId":"63035256239","pageName":"Use CrateDB and Apache Superset for Open Source Data Warehousing and Visualization","formInstanceId":"5401","urlParams":{"utm_medium":"email","_hsmi":"203508553","_hsenc":"p2ANqtz-9TaamTm5Wi7KOyzBvrJvpyNiS-0dzC1NJmN6Z4pjbvIybTse_WBRQ6ZYCdrtaSmh-KqE5pTugpSmP2S37aSqakf8l_qYJwlJ6DM98bQJExgdM3wn8","utm_content":"203508553","utm_source":"hs_email"},"renderedFieldsIds":["email"],"formTarget":"#hs_form_target_form_56148974","correlationId":"b3916724-1251-4cf8-9161-558c8328d739","contentType":"blog-post","hutk":"c1efa8a205ec02a622d9db2de1465063","captchaStatus":"NOT_APPLICABLE","isHostedOnHubspot":true}"
data-reactid=".hbspt-forms-0.7"><iframe name="target_iframe_76d1441f-eef8-4e8e-950d-9b66bf24bd8e_5401" style="display:none;" data-reactid=".hbspt-forms-0.8"></iframe>
</form>Text Content
This website stores cookies on your computer. These cookies are used to collect information about how you interact with our website and allow us to remember you. We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors both on this website and other media. To find out more about the cookies we use, see our Privacy Policy If you decline, your information won’t be tracked when you visit this website. A single cookie will be used in your browser to remember your preference not to be tracked. Settings Accept Decline Skip to content * Products * CrateDB Overview * CrateDB Cloud * CrateDB Edge * CrateDB On-Premises * CrateOM * Pricing * Get CrateDB * Customers * Success Stories * Use Cases * Industries * Compare * Company * About * Jobs * Partners * Newsroom * Newsletter * Events * Contact us * Resources * Documentation * Get Started * Videos * Webinars * White Papers * Community * Blog Login Get CrateDB Login Get CrateDB USE CRATEDB AND APACHE SUPERSET FOR OPEN SOURCE DATA WAREHOUSING AND VISUALIZATION 2022-01-03 , by Marija Selakovic Apache Superset is an easy-to-use open-source business intelligence (BI) application that offers a rich set of customizable data visualizations. With Superset, you can explore, filter, and organize your data. You can also create and share custom monitoring and analytics dashboards. CrateDB is a distributed SQL database that makes it simple to capture, store, and analyze massive amounts of operational data in real-time. In this post, I'll show you how to get started with CrateDB and Apache Superset. And by the end of this post, you should have your very first Superset visualizations running on top of CrateDB data. Note: The following instructions are done on macOS, and should be easily adaptable for Linux. It uses CrateDB 4.6.6 and Apache Superset 1.3.2. SETUP CRATEDB Get CrateDB set up with a single command: bash -c "$(curl -L https://try.crate.io/)" This command downloads CrateDB and runs it from the tarball. If you'd like to install CrateDB permanently, or you are using Windows, check out our collection of one-step install guides. If you're using the command above, it should pop open the CrateDB admin UI for you automatically once it has finished. Otherwise, head over to http://localhost:4200/ in your browser. You should see CrateDB Admin UI as illustrated below: GET DATA As the fresh CrateDB installation does not have any data, we are going to import some of the existing datasets. We choose to import the Twitter sentiment corpus that consists of more than 5,000 tweets classified concerning one of four different topics. The full corpus of data can be found here. Before data import, we need to create a new table in CrateDB with the following schema: Finally, we import Twitter sentiment corpus with COPY FROM statement that copies data from a file into a table: COPY doc.tweets FROM 'file:///path_to_file/full-corpus.csv' RETURN SUMMARY; Once the data is imported, select the Tables icon from the left-hand navigation in Admin UI, and then select the tweets table. You should end up here: http://localhost:4200/#/tables/doc/tweets To inspect some of the data samples, click on the Query Table button. The output of the SELECT statement should look as follows: Great! At this point, the CrateDB is up and running with data that can be further analyzed. In this article, we will show you how to graph a pie chart to illustrate the numerical proportion of tweets per different topic and how to visualize sentiment data for each topic in a bar graph. INSTALL APACHE SUPERSET The fastest way to set up Apache Superset is to use Docker and Docker Compose on a Linux or macOS computer. In this article, we will show how to install and use Apache Superset on macOS, and to find out how to use it with other operating systems please follow the official documentation. Before continuing, make sure that you have installed Docker for Mac. The first step is to clone Superset’s repository with the following command: git clone https://github.com/apache/superset.git After the superset directory has been downloaded, we need to extend the list of requirements with a Python database driver for CrateDB. To do this, create the requirements-local.txt file and add a new line to it: echo "crate[sqlalchemy]==0.26.0" >> ./docker/requirements-local.txt Now, run the docker-compose command from the superset directory: docker-compose -f docker-compose-non-dev.yml up The command will spin several docker containers. After the logging output from the containers slows, you can start exploring Apache Superset on your local machine. RUN SUPERSET To access Superset, visit http://localhost:8088 in your browser: Log in with the default username and password: * username: admin * password: admin Afterward, you should see the starting page of Apache Superset: The Superset app Docker container also loads several datasets and dashboards that can be used as a starting point for learning different visualization options. CONNECT TO CRATEDB To connect Apache Superset with CrateDB select Data → Databases from the top navigation menu: Click on the Database button in the top right-hand corner of the screen. This will open a new window for choosing a database to connect to. Among the list of databases choose CrateDB. In the same form, fill out the following information: * Database: CrateDB * SQLAlchemy URI: crate://crate@host.docker.internal:4200 Like so: Then, click the Test Connection button. You should be presented with a modal popup window saying "Connection looks good!". To finally connect, click Connect button. CrateDB database connection will appear in the list of databases: The next step is to import a new dataset: go to Data → Dataset from the top navigation menu and click on the Dataset button in the top right corner. To add data from the tweets table, select the following: * Database: CrateDB * Schema: doc * Table Schema: tweets Click Add button and the data will appear in the list of data sources. CREATE DASHBOARD Before creating individual charts, let’s first create a new dashboard that will be used to display charts together. This can be done by choosing Dashboards from the navigation bar and clicking on the Dashboard button in the top right corner. This will open the following window: Name the dashboard Twitter Sentiment as illustrated and click on the Save button. CREATE A PIE CHART The first chart we are going to create is a pie chart. Choose Charts from the navigation menu and click on the Chart button in the top right corner. This opens a new window for choosing Chart type as illustrated below. As a dataset choose tweets, as a chart type choose pie chart, and then click on Create New Chart. The window opens a form for specifying the query that extracts data to be visualized. The query can be specified either graphically or in the SQL format. For example, if we want to show proportions of tweets per topic, we will specify the query like the following: * First, we need to group tweets by the topic * Second, we specify the metric we want to show: in our case, it is the number of tweets. The corresponding SQL metric is defined as COUNT(tweetid) * Finally, we leave the filter empty as we want to take into account all tweets The resulting chart shows the proportion of each topic to the total number of tweets. Click on the Save button above the query form, choose the chart name and add to the Twitter Sentiment dashboard as follows: Now if you open the Twitter Sentiment dashboard, the created pie chart will show up. CREATE A BARCHART Now, let’s illustrate the sentiment per topic. This time, we choose a bar chart with the query as illustrated below: * We choose the number of tweets as a metric, e.g., COUNT(tweetid) * Then, we group data by topic (series = topic). * Finally, we break each group by sentiment, to show for each topic how many tweets are classified as positive, negative, neutral, and irrelevant (breakdowns = sentiment) Next, save the graph to the Twitter Sentiment dashboard. The dashboard now contains two charts as shown below: For our dataset, we can observe that Google has the highest number of positive tweets and the lowest number of negative tweets. On the other hand, about Apple, there are more negative tweets than for other topics. Interestingly, most of the tweets for all topics are classified as neutral. WRAP UP Apache Superset is an open-source cloud-native application that allows easy visualization of massive amounts of data. CrateDB is a distributed SQL database that makes data storage and analysis simple and at scale. Together, they provide a powerful open-source platform for data warehousing and business intelligence. This post illustrated how to make the first start with CrateDB and Apache Superset, specifically: 1. How to get CrateDB up-and-running 2. Importing interesting data from a filesystem 3. How to install Apache Superset via docker-compose 4. Setting up a connection to CrateDB 5. Creation of a dashboard and two different types of charts Questions? Looking for help? Get in touch! NEWSLETTER STAY UP TO DATE Sign up here to keep informed about CrateDB product news, events, how-to articles, and community update. From time to time, we would like to contact you about our products and services. If you consent to us contacting you for this purpose, please tick the box below. * I agree to receive marketing communications from Crate.io. You can unsubscribe from these communications at any time. For more information, please review our Privacy Policy. By clicking below, you consent to allow Crate.io to store and process the personal information submitted above to provide you the content requested. * Share * * * * * Go to top HomeBlogUse CrateDB PRODUCT * CrateDB Overview * CrateDB Cloud * CrateDB Edge * CrateDB On-Premises * CrateOM * Compare * Pricing * Download * CrateDB Cloud Login CUSTOMERS * Success Stories * Use Cases * Industries RESOURCES * Blog * Content Library * Videos * Webinars * White Papers DEVELOPERS * Get Started * Reference * How-To Guides * Support * SQL 99 Docs * Community * Github * Contribute COMPANY * About us * Jobs * Events * Newsletter * Partners * Press * Security * Contact FOLLOW US Follow us on Twitter Follow us on LinkedIn Follow us on Facebook Follow us on YouTube Follow us on GitHub * Legal * Privacy Policy * Imprint © 2022 Crate.io. All rights reserved. SUBSCRIBE TO THE CRATE.IO NEWSLETTER NOW We respect your privacy and data. Your information will not be shared with third parties. You can unsubscribe from this newsletter at any time.