Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Search

510 results

Filter
SQLite
Database Data access ETL Education Table Csv Read Import
  1. Go to item
    Workflow
    Database - Simple IO
    Database Io Sqlite
    This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME worflow. It uses the file-based "sqlite" d…
    knime > Examples > 01_Data_Access > 02_Databases > 01_Database_Simple_IO_Example
    2
    knime
  2. Go to item
    Workflow
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
    Database Sql Hive
    +11
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark) KNIME as a powerful data anaylytics platfo…
    mlauber71 > Public > _db_sql_bigdata_hive_spark_meta_collection
    1
    mlauber71
  3. Go to item
    Workflow
    Identify tables in you database(s) and loop over them and store the data in a CSV file
    Sql Sqlite Loop
    +2
    Identify tables in you database(s) and loop over them and store the data in a CSV file
    mlauber71 > Public > kn_example_db_loop_multiple_tables
    1
    mlauber71
  4. Go to item
    Workflow
    Play around with SQLite and Date and Time functions
    Sql Date Time
    +2
    Play around with SQLite and Date and Time functions
    mlauber71 > Public > kn_example_db_sqlite_timestamp
    1
    mlauber71
  5. Go to item
    Workflow
    Create a SQLite table with R (and manipulate data)
    Sqlite R Database
    Create a SQLite table with R (and manipulate data) You can do all the stuff you want in R and then put the results into SQLite by…
    mlauber71 > Public > kn_example_r_sqlite_multiple_tables_40
    1
    mlauber71
  6. Go to item
    Workflow
    KNIME and SQLite - simple example (4.0 New DB nodes)
    DB Sqlite R
    +2
    this demonstrates the use of a local SQLite database where you can store data and keep the variable type and perform database ope…
    mlauber71 > Public > sqlite_knime_40 > t_001_sqlite_knime_40_db_nodes
    1
    mlauber71
  7. Go to item
    Workflow
    Chapter 2 / Exercise 3
    SQLite Books Exercise
    +3
    The goal of this exercise is to practice with the Parameterized DB Query Reader node for looping purpose. Extract make, nr_doors,…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter2 > Exercises > Exercise3
    1
    jeany
  8. Go to item
    Workflow
    Fetch Data from Database
    Life Sciences Database SQLite
    This example workflow shows how to retrieve data from SQLite database. Specifically, it shows how to select columns from a table …
    knime > Workflow Snippets > Fetch_Data_from_Database
    1
    knime
  9. Go to item
    Workflow
    Database - Simple IO
    Database Io Sqlite
    This workflow demonstrates using DB Query Reader and DB Writer nodes in a simple KNIME worflow. It uses the file-based "sqlite" d…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 4_Examples > 01_Database_Simple_IO_Example
    1
    knime
  10. Go to item
    Workflow
    02 Accessing Databases - Solution
    Data access Sqlite
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The connector node to use here is the SQLite Connec…
    shumemo > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 02 Accessing Databases - Solution
    0
    shumemo
  11. Go to item
    Workflow
    08 Database Data Manipulation
    Sqlite Database
    Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data directly on the da…
    mcmas1999 > Assignments > Lab 01 > Project 1 - mickelma > 08 Database Data Manipulation
    0
    mcmas1999
  12. Go to item
    Workflow
    02 Accessing Databases
    Data access Sqlite
    Exercise for reading data from a database
    felipec15 > Public > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 02 Accessing Databases
    0
    felipec15
  13. Go to item
    Workflow
    02 Accessing Databases - Solution
    Data access Sqlite
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The connector node to use here is the SQLite Connec…
    elzamc > Public > MICAH ELZA L1-DS KNIME Analytics Platform for Data Scientists - Basics > Solutions > 02 Accessing Databases - Solution
    0
    elzamc
  14. Go to item
    Workflow
    08 Database Data Manipulation
    Sqlite Database
    Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data directly on the da…
    deborah_santos > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 08 Database Data Manipulation
    0
    deborah_santos
  15. Go to item
    Workflow
    02 Database Data Manipulation - Solution
    Database SQLite
    Solution to an exercise for database data manipulation. Write a local data table into a database. Aggregate, join, and filter the…
    fuschiefox > IT 4015 snavelmy Projects > IT 4015 Project 4 > extra_data > extra 02 Database Data Manipulation - Solution
    0
    fuschiefox
  16. Go to item
    Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    kellej6 > IT4015 Applied Business Intelligence > Lab 1 > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 02 Accessing Databases
    0
    kellej6
  17. Go to item
    Workflow
    02 Accessing Databases - Solution
    Data access Sqlite Database
    Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The overall life expectancy in the world is 72.6 ye…
    kellej6 > IT4015 Applied Business Intelligence > Lab 1 > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 02 Accessing Databases - Solution
    0
    kellej6
  18. Go to item
    Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    jose_neto > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 02 Accessing Databases
    0
    jose_neto
  19. Go to item
    Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    km_tan > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 02 Accessing Databases
    0
    km_tan
  20. Go to item
    Workflow
    08 Database Data Manipulation
    Sqlite Database
    Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data directly on the da…
    jalvear > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 08 Database Data Manipulation
    0
    jalvear

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits