• Type: New Feature
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.4.0
    • Component/s: Pipelines, UI
    • Labels:
    • Release Notes:
      Adding ability to fetch schema from jdbc in Database plugin inside Hydrator
    • Rank:


      This is an implementation only task. We need to make sure we call the right backend endpoints to get the schema for JDBC sources.

      There will be design changes required, attaching first mock for design update.

      As a user, I want to specify a JDBC source and query it within a selected database plugin so that I may automatically populate the output schema.

      From within the Node Configuration panel of a Database plugin,
      1. User enters all required data.
      2a. User enters query into 'Import SQL' box.
      2b. User may manually expand the input box to accommodate long query strings.
      3. User clicks 'Get Schema' button.
      4a. 'Import SQL' dialogue box appears.
      4b. Query is fully displayed in box.
      4c. User clicks 'Execute' to run the query.
      4d. Schema appears in box.
      4e. Name, translation of 'Database Type' into 'Hydrator Type,' and Null for each is displayed.
      4f. User may click 'Cancel' to cancel the action.
      4g. User may click 'Apply' to apply the schema to the Database configuration.
      5a. 'Schema Applied.' confirmation message appears as a green success-message bar beneath the navigation.
      5b. This message will disappear after X seconds.
      5c. User may "X' out this message, as well.
      5d. Schema is applied as the 'Output Schema' of the configuration panel.


          Issue Links



              • Assignee:
                edwin Edwin Elia
                brady Brady Ajay
              • Votes:
                0 Vote for this issue
                2 Start watching this issue


                • Created: