Hub

19 results

Filter
Filter by tag
SQL
SQLite
Database E-learning Education Db Loop H2
  1. Workflow
    KNIME, Python and SQL with local SQLite database
    SQL SQLite Python
    +1
    KNIME, Python and SQL with local SQLite database Some examples how to interact with a (local) SQLite database with SQL commands v…
    mlauber71 > Public > kn_example_db_sqlite_python_sql
    0
    mlauber71
  2. Workflow
    Titanic KNIME Beispiel (deutsch) - SQL Datenbanken mit KNIME
    Knime Titanic Einführung
    +6
    Titanic: Machine Learning from Disaster https://www.kaggle.com/c/titanic Einführung in KNIME (deutsch) - https://hub.knime.com/ml…
    mlauber71 > Public > knime_einfuehrung_beispiel_titanic > m_150_sql_database_titanic
    0
    mlauber71
  3. Workflow
    An example of combining SQL database, loop and case switch
    Case Switch Loop
    +2
    An example of combining SQL database, loop and case switch there are 10 chunks in the database. some of them have fault=1 lines s…
    mlauber71 > Public > kn_example_switch_case_store_file_sql
    0
    mlauber71
  4. 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
  5. 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
  6. Workflow
    Load tables from SQLite "Northwind" DB into H2 and make all columns lower case
    Sql Sqlite Northwind
    +3
    Load tables from SQLite "Northwind" DB into H2 and make all columns lower case
    mlauber71 > Public > kn_example_db_bigdata_nodes > m_000_db_prepare_northwind_db
    0
    mlauber71
  7. Workflow
    Prepare the Northwind database into a consistant H2 db to provide a database environment to play with
    H2 SQLIte Northwind
    +3
    These tables are included in the local database
    mlauber71 > Public > kn_example_db_h2_prepare_northwind_db_small > m_001_prepare_northwind_db_h2
    0
    mlauber71
  8. Workflow
    Construct a Right Join with SQLite
    Sql Sqlite Join
    +2
    I built a workflow that does that also to play around with SQLite and to see what it could do. I have two databases that both hav…
    mlauber71 > Public > kn_example_db_sqlite_right_joiner_loop
    0
    mlauber71
  9. Workflow
    SQLite - Window function and Rank to detect duplicates - also using automatic ID and TimeStamps
    Sql SQLite Window
    +4
    SQLite - Window function and Rank to detect duplicates - also using automatic ID and TimeStamps https://forum.knime.com/t/concept…
    mlauber71 > Public > kn_example_db_sqlite_window_rank_timestamp
    0
    mlauber71
  10. Workflow
    Play around with SQLite and Date and Time functions
    Sql Date Time
    +2
    Play around with SQLite and Date and Time functions
    deganza > Public > KNIME_Solutions_for_real_applications > c2.1_Data_Access_with_KNIME_SQL_and_Co > Data Access - 03 Databases example
    0
    deganza
  11. Workflow
    DB SQLite - switch datase source based on a case when selection
    SQLite SQL Database
    +1
    DB SQLite - switch datase source based on a case when selection
    mlauber71 > Public > kn_example_db_sqlite_switch_query
    0
    mlauber71
  12. Workflow
    KNIME and SQLite - simple example (3.7 Legacy DB nodes)
    Sqlite Sql Db
    +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_37 > t_001_sqlite_knime_37_db_legacy
    0
    mlauber71
  13. 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
  14. Workflow
    02_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME …
    burdhasp > Public > Exercises - L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Solutions > 02_Database_Data_Manipulation - Solution
    0
    burdhasp
  15. Workflow
    02_Database_Data_Manipulation
    E-learning Database SQLite
    +2
    E-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME data table.
    stervis > Public > E-Learning > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 02_Database_Data_Manipulation
    0
    stervis
  16. Workflow
    02_Database_Data_Manipulation
    E-learning Database SQLite
    +2
    E-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME data table.
    burdhasp > Public > Exercises - L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Exercises > 02_Database_Data_Manipulation
    0
    burdhasp
  17. Workflow
    02_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME …
    stervis > Public > E-Learning > L2-DS KNIME Analytics Platform for Data Scientists - Advanced > Solutions > 02_Database_Data_Manipulation - Solution
    0
    stervis
  18. Workflow
    15_Database_Data_Manipulation - Solution
    E-learning Database SQLite
    +2
    Solution to an e-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME …
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Solutions > 15_Database_Data_Manipulation - Solution
    0
    stervis
  19. Workflow
    15_Database_Data_Manipulation
    E-learning Database SQLite
    +2
    E-learning course exercise. Filter a database table directly on the database. Read the filtered data into a KNIME data table.
    stervis > Public > E-Learning > L1-DW KNIME Analytics Platform for Data Wranglers - Basics > Exercises > 15_Database_Data_Manipulation
    0
    stervis