Hub

354 results

Filter
Filter by tag
Database
SQLite
Data access Education ETL Csv Read Table Import
  1. 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. 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
    2
    mlauber71
  3. 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
  4. 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
  5. 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
  6. 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
  7. Workflow
    Simple Visualization
    TheGuideBook Data Access CSV
    +16
    The Iris dataset contains information about sepal and petal dimensions of three species of Iris flower. For exercise purposes, th…
    knime > Academic Alliance > Guide to Intelligent Data Science > Example Workflows > Chapter4 > 01_Simple_Visualization
    1
    knime
  8. 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
  9. 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. 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
  11. 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…
    woebketr > IT4015 woebketr Projects > IT4015 Labs > IT4015 Lab 1 > L1DW Course workflows > Exercises > 08 Database Data Manipulation
    0
    woebketr
  12. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    Exercise for reading data from a database
    woebketr > IT4015 woebketr Projects > IT4015 Labs > IT4015 Lab 1 > L1DW Course workflows > Exercises > 02 Accessing Databases
    0
    woebketr
  13. 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…
    branqwynn > IT 4015 Nguyenb8 Projects > IT 4015 Labs > IT 4015 Lab 1 > L1DW Course Workflows > Exercises > 08 Database Data Manipulation
    0
    branqwynn
  14. Workflow
    Simple Visualization
    TheGuideBook Data Access CSV
    +16
    The Iris dataset contains information about sepal and petal dimensions of three species of Iris flower. For exercise purposes, th…
    vascoasv > Public > 01_Simple_Visualization_v
    0
    vascoasv
  15. Workflow
    Database Binning
    Database Sqlite Binning
    This workflow demonstrates the different database binner nodes that allow you to create new binning columns for numerical columns…
    haoran > Public > 01_Data_Access > 02_Databases > 04_Binning_in_Databases
    0
    haoran
  16. Workflow
    02 Accessing Databases
    Data access Sqlite Database
    An exercise for reading data from a database.
    branqwynn > IT 4015 Nguyenb8 Projects > IT 4015 Labs > IT 4015 Lab 1 > Lab 1 Workflows > Workflows > 02 Accessing Databases
    0
    branqwynn
  17. 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…
    froilan_sia > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 02 Accessing Databases - Solution
    0
    froilan_sia
  18. Workflow
    05_Read_Data_from_Database
    E-learning Database Sqlite
    +1
    E-learning course exercise. Access data on a SQLite database and read it into a local KNIME data table.
    stervis > Public > E-Learning > L1-DS KNIME Analytics Platform for Data Scientists - Basics > Exercises > 05_Read_Data_from_Database
    0
    stervis
  19. 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,…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter2 > Exercises > Exercise3
    0
    rs1
  20. 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…
    hariish > Public > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 02 Accessing Databases - Solution
    0
    hariish