Icon

01_​Collecting_​data_​from_​Twitter

Twitter Data Collection

This workflow is designed to collect and store a sample of tweets on a particular search term. With each execution of the workflow, tweets are collected, favorite and retweet numbers are updated in existing records in a SQLite Database and new tweets are written to that same table.

Twitter Data CollectionThis workflow is designed to collect and store a sample of tweets on a particular search term. With each execution of the workflow,tweets are collected, favorite and retweet numbers are updated in existing records in a SQLite Database and new tweets are writtento that same table.For longitudinal data collection, the workflow may be periodically executed manually, run via command line using the batch executoror optimally scheduled for regular execution via the KNIME Server (https://www.knime.org/knime-server). The Twitter API Connector requires API keys andaccess tokens to execute successfully. Togenerate these you will need to go to your twitteraccount at dev.twitter.com and register yourapplication under "My Applications". The API keyshould be immediately available and accesstokens may be generated and revoked as needed.Both should be available from the API Keys tab ofthe page for your application. Enter API Key here(see node descriptionfor details)Enter searchterms hereRemove UpdatedExtra ColumnsConnect to DBFavoriate/RetweetsWrite new tweets Twitter APIConnector Twitter Search Row Filter Column Filter SQLite Connector DB Update DB Writer Twitter Data CollectionThis workflow is designed to collect and store a sample of tweets on a particular search term. With each execution of the workflow,tweets are collected, favorite and retweet numbers are updated in existing records in a SQLite Database and new tweets are writtento that same table.For longitudinal data collection, the workflow may be periodically executed manually, run via command line using the batch executoror optimally scheduled for regular execution via the KNIME Server (https://www.knime.org/knime-server). The Twitter API Connector requires API keys andaccess tokens to execute successfully. Togenerate these you will need to go to your twitteraccount at dev.twitter.com and register yourapplication under "My Applications". The API keyshould be immediately available and accesstokens may be generated and revoked as needed.Both should be available from the API Keys tab ofthe page for your application. Enter API Key here(see node descriptionfor details)Enter searchterms hereRemove UpdatedExtra ColumnsConnect to DBFavoriate/RetweetsWrite new tweetsTwitter APIConnector Twitter Search Row Filter Column Filter SQLite Connector DB Update DB Writer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: knime
Created at: 2014-09-11
On NodePit since: 2025-03-21
Last update: 2026-01-06
Created with KNIME version: v4.5.0
Tags: TwitterNLPtext processingNatural Language Processinggraph analysisnetwork analysissocial mediaPracticing Data Science

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!