Fluid AI Frontier
  • Frontier
    • What is Frontier?
    • Creating your first project
    • Modules
  • Reports & Visualizations
    • Reporting and Visualizing data
      • Charts
      • Reports
  • Processing & Pipelines
    • What is a Pipeline?
    • Individual Pipelines
      • Configure a DB Connection
      • Fetch Data from DB
      • Merge 2 Files
      • Vectorize Your Data
      • Train an ML Model
      • Train AutoML Model
      • Build a Custom Pipeline
      • Push Data to Database
  • Data
    • What is a Data Module?
      • Input Files
        • Explanatory Data Analysis
      • Output Files
      • Database Connections
      • Query Configurations
  • Model Registry & Node Instance
    • What is Model Registry?
    • What is Node Instance
  • EXTRAS
    • Model Versioning
    • Load Notebook
    • Serve Pipeline
    • Scheduler
    • Alerts
Powered by GitBook
On this page
  • Steps to follow
  • Walkthrough
  1. Processing & Pipelines
  2. Individual Pipelines

Fetch Data from DB

PreviousConfigure a DB ConnectionNextMerge 2 Files

Last updated 3 years ago

Steps to follow

  1. From the Processing & Pipelines module select Build Pipelines section.

  2. Click the Fetch Data from DB button, a popup appears.

  3. Frontier allows two option to store the fetched data from database :

    1. Add a new file allows user to create a new file when the file doesn't exist in frontier system.

    2. Modify a pre existing file allows user to update the old file from the new updated file on the database.

  4. Frontier allows two options to fetch data from the database :

    1. Normal Fetch Operation allows user to write normal select queries from the database.

    2. Query in Fetch Operation allows user to combine two or more tables to join them and extract into frontier system. The source key and the file name that has the common key should be given.

  5. After the query is written, the Preview Data button can be used to check if the connection works and will the data get reflected in the Frontier.

  6. Click Save button to save the pipeline, or Save & Execute button to execute the pipeline right away.

Walkthrough

Quick tutorial on Fetcher
https://www.loom.com/share/d08ddc37c590447aa3c54c0506cd29eewww.loom.com