[Proposal] - SQL Querying #6075
Assignees
Labels
Comments
|
The mocks still have timeranges associated with them, whereas the currently implementation removed them. Are there any future plans to reintroduce timepicker and to have it work w/ SQL queries? |
7 tasks
kavilla
added a commit
that referenced
this issue
Jul 16, 2024
### Description Introduces the addition of a new core plugin called `Query Enhancements` This plugin seems to be focused on enhancing query capabilities, particularly in areas like PPL (Piped Processing Language), SQL, and natural language query assistance. #### Plugin Configuration and Setup The plugin is set up with the necessary configuration files: - src/plugins/query_enhancements/opensearch_dashboards.json: Defines the plugin's metadata and dependencies. - src/plugins/query_enhancements/common/config.ts: Contains the configuration schema for the plugin. - src/plugins/query_enhancements/public/plugin.tsx: The main plugin file that sets up the public-facing part of the plugin. - src/plugins/query_enhancements/server/plugin.ts: The server-side setup for the plugin. #### Query Assist Feature A significant part of the plugin is dedicated to a "Query Assist" feature: - src/plugins/query_enhancements/public/query_assist/: This directory contains components, hooks, and utilities for the Query Assist feature. - src/plugins/query_enhancements/public/query_assist/components/query_assist_bar.tsx: A React component for the Query Assist bar. - src/plugins/query_enhancements/server/routes/query_assist/: Server-side routing for Query Assist functionality. #### Search Interceptors The plugin introduces several search interceptors: - src/plugins/query_enhancements/public/search/ppl_search_interceptor.ts - src/plugins/query_enhancements/public/search/sql_search_interceptor.ts - src/plugins/query_enhancements/public/search/sql_async_search_interceptor.ts These interceptors likely modify or enhance the search functionality for different query languages. #### Data Source Connection There's a new feature for data source connections: - src/plugins/query_enhancements/public/data_source_connection/: This directory contains components and services for managing data source connections. #### Server-side Search Strategies The plugin implements server-side search strategies for different query types: - src/plugins/query_enhancements/server/search/ppl_search_strategy.ts - src/plugins/query_enhancements/server/search/sql_search_strategy.ts - src/plugins/query_enhancements/server/search/sql_async_search_strategy.ts #### Modifications to Existing Files There are some modifications to existing files outside the new plugin directory: - src/plugins/data/public/index.ts: Exports new types and interfaces. - src/plugins/data/public/ui/index.ts: Exports new UI components. - src/plugins/data/public/ui/query_editor/index.tsx: Modifies the QueryEditor component. #### Testing The plugin includes a comprehensive test setup: - src/plugins/query_enhancements/test/: Contains Jest configuration and setup files for testing. #### Acknowledgements Contains work by @sejli @joshuali925 @Swiddis @paulstn @mengweieric Thx @ashwin-pc for the description summary ### Issues Related #6072 #6074 #6075 Commits include: * init Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * fixing bugs and removing target Signed-off-by: Sean Li <lnse@amazon.com> * add target and build to .gitignore Signed-off-by: Sean Li <lnse@amazon.com> * Remove SQL Async and Query Assist Going for the light weight solution for 2.15. So took out what wasn't required deliverable. However, I created a branch `feature/discover-next` which has the state where all the features where added so we can port it over post 2.15. Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * adding fix for PPL queries Signed-off-by: Sean Li <lnse@amazon.com> * Clean up files and add helper functions Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * final touches Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * [Discover-next] add query assist to query enhancements plugin (#6895) it adds query assist specific logic in query enhancements plugin to show a UI above the PPL search bar if user has configured PPL agent. Issues Resolved: #6820 * add query assist to query enhancements Signed-off-by: Joshua Li <joshuali925@gmail.com> * align language to uppercase Signed-off-by: Joshua Li <joshuali925@gmail.com> * pick PR 6167 Signed-off-by: Joshua Li <joshuali925@gmail.com> * use useState hooks for query assist There is a bug in data explorer `AppContainer` where memorized `DiscoverCanvas` gets unmounted after `setQuery`. PR 6167 works around it by memorizing `AppContainer`. As query assist is no longer being unmounted, we can use proper hooks to persist state now. Signed-off-by: Joshua Li <joshuali925@gmail.com> * Revert "pick PR 6167" This reverts commit acb0d41. Wait for official 6167 to merge to avoid conflict Signed-off-by: Joshua Li <joshuali925@gmail.com> * address comments for PR 6894 Signed-off-by: Joshua Li <joshuali925@gmail.com> --------- Signed-off-by: Joshua Li <joshuali925@gmail.com> (cherry picked from commit 016e0f2) * [Discover-next] Address comments for search bar extensions and query assist (#6933) * pass dependencies to isEnabled func Signed-off-by: Joshua Li <joshuali925@gmail.com> * add lazy and memo to search bar extensions Signed-off-by: Joshua Li <joshuali925@gmail.com> * move ppl specific string out from query assist Signed-off-by: Joshua Li <joshuali925@gmail.com> * prevent setstate after hook unmounts Signed-off-by: Joshua Li <joshuali925@gmail.com> * add max-height to search bar extensions Signed-off-by: Joshua Li <joshuali925@gmail.com> * prevent setstate after component unmounts Signed-off-by: Joshua Li <joshuali925@gmail.com> * move ml-commons API to common/index.ts Signed-off-by: Joshua Li <joshuali925@gmail.com> * improve i18n and accessibility usages Signed-off-by: Joshua Li <joshuali925@gmail.com> * add hard-coded suggestions for sample data indices Signed-off-by: Joshua Li <joshuali925@gmail.com> --------- Signed-off-by: Joshua Li <joshuali925@gmail.com> (cherry picked from commit 4aade0f) * [Discover-next] Support data sources for query assist (#6972) * disable query assist for non-default datasource Signed-off-by: Joshua Li <joshuali925@gmail.com> * disable query assist input when loading Signed-off-by: Joshua Li <joshuali925@gmail.com> * support MDS for query assist Signed-off-by: Joshua Li <joshuali925@gmail.com> * add unit tests for agents Signed-off-by: Joshua Li <joshuali925@gmail.com> * Revert "add unit tests for agents" This reverts commit 983514e. The test configs are not yet setup in query_enhancements plugins. Signed-off-by: Joshua Li <joshuali925@gmail.com> --------- Signed-off-by: Joshua Li <joshuali925@gmail.com> (cherry picked from commit 328e08e) * add query assist banner Signed-off-by: Joshua Li <joshuali925@gmail.com> * implement banner rendering logic Signed-off-by: Joshua Li <joshuali925@gmail.com> * pick opensearch-project/dashboards-observability/pull/1896 Signed-off-by: Joshua Li <joshuali925@gmail.com> * Conditionally render the data source select config Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * restore no space Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * add basic tests Signed-off-by: Joshua Li <joshuali925@gmail.com> * add index selector This is a temporary solution given that in discover the index pattern selector will be removed. Before datasource and dataset selectors are added, query assist will rely on this index pattern selector to determine which index user wants to query. Signed-off-by: Joshua Li <joshuali925@gmail.com> * MDS working with PPL and SQL Utilizing the work from MDS to make PPL and SQL calls to a remote cluster. Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * rename logo to mark Signed-off-by: Joshua Li <joshuali925@gmail.com> * extract supported languages to config Signed-off-by: Joshua Li <joshuali925@gmail.com> * Add missing license headers Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * initial implementation for async queries Signed-off-by: Sean Li <lnse@amazon.com> * remove queryId and sessionId from facet Signed-off-by: Sean Li <lnse@amazon.com> * fix: Update call out tests with intl wrapper Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * maintenance: Add and apply lint command Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * changing to observables Signed-off-by: Sean Li <lnse@amazon.com> * search interceptor and cleanup Signed-off-by: Sean Li <lnse@amazon.com> * moving polling class into plugin Signed-off-by: Sean Li <lnse@amazon.com> * Some minor clean ups plus lint Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * test: Add mock-heavy tests for sql search strategy Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * test: add GH workflows Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * More clean ups Add some props interfaces and consolidated some of the facets Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * chore: apply auto-lints to plugin Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * Not done Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * working Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * working and styled Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * add connection service Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * Update public/types.ts Co-authored-by: Joshua Li <joshuali925@gmail.com> * Update public/plugin.tsx Co-authored-by: Joshua Li <joshuali925@gmail.com> * Update public/plugin.tsx Co-authored-by: Joshua Li <joshuali925@gmail.com> * fix linter Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * add more tests for query assist (#31) add more tests for query assist update eslint config to make it work increase index selector width Signed-off-by: Joshua Li <joshuali925@gmail.com> * fix!: remove dataSource key in get connection response The `Connection` type does not have the extra `dataSource` object around response, and most of the time code references connection over dataSource. remove the redundent object to make response consistent with type. Signed-off-by: Joshua Li <joshuali925@gmail.com> * change isEnabled to an observable based on selected connection Signed-off-by: Joshua Li <joshuali925@gmail.com> * protect duplicated calls Signed-off-by: Joshua Li <joshuali925@gmail.com> * [build] import via start services Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * Changeset file for PR #7212 created/updated * foobar Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * updating imports still in progress Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * Update more imports Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * fix setting of state Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * fixes bugs Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * Update test Signed-off-by: Kawika Avilla <kavilla414@gmail.com> --------- Signed-off-by: Kawika Avilla <kavilla414@gmail.com> Signed-off-by: Sean Li <lnse@amazon.com> Signed-off-by: Joshua Li <joshuali925@gmail.com> Signed-off-by: Simeon Widdis <sawiddis@amazon.com> Co-authored-by: Sean Li <lnse@amazon.com> Co-authored-by: Joshua Li <joshuali925@gmail.com> Co-authored-by: Simeon Widdis <sawiddis@amazon.com> Co-authored-by: opensearch-changeset-bot[bot] <154024398+opensearch-changeset-bot[bot]@users.noreply.github.com> Signed-off-by: Kawika Avilla <kavilla414@gmail.com>
sejli
pushed a commit
to sejli/OpenSearch-Dashboards
that referenced
this issue
Jul 23, 2024
…earch-project#7212) Introduces the addition of a new core plugin called `Query Enhancements` This plugin seems to be focused on enhancing query capabilities, particularly in areas like PPL (Piped Processing Language), SQL, and natural language query assistance. The plugin is set up with the necessary configuration files: - src/plugins/query_enhancements/opensearch_dashboards.json: Defines the plugin's metadata and dependencies. - src/plugins/query_enhancements/common/config.ts: Contains the configuration schema for the plugin. - src/plugins/query_enhancements/public/plugin.tsx: The main plugin file that sets up the public-facing part of the plugin. - src/plugins/query_enhancements/server/plugin.ts: The server-side setup for the plugin. A significant part of the plugin is dedicated to a "Query Assist" feature: - src/plugins/query_enhancements/public/query_assist/: This directory contains components, hooks, and utilities for the Query Assist feature. - src/plugins/query_enhancements/public/query_assist/components/query_assist_bar.tsx: A React component for the Query Assist bar. - src/plugins/query_enhancements/server/routes/query_assist/: Server-side routing for Query Assist functionality. The plugin introduces several search interceptors: - src/plugins/query_enhancements/public/search/ppl_search_interceptor.ts - src/plugins/query_enhancements/public/search/sql_search_interceptor.ts - src/plugins/query_enhancements/public/search/sql_async_search_interceptor.ts These interceptors likely modify or enhance the search functionality for different query languages. There's a new feature for data source connections: - src/plugins/query_enhancements/public/data_source_connection/: This directory contains components and services for managing data source connections. The plugin implements server-side search strategies for different query types: - src/plugins/query_enhancements/server/search/ppl_search_strategy.ts - src/plugins/query_enhancements/server/search/sql_search_strategy.ts - src/plugins/query_enhancements/server/search/sql_async_search_strategy.ts There are some modifications to existing files outside the new plugin directory: - src/plugins/data/public/index.ts: Exports new types and interfaces. - src/plugins/data/public/ui/index.ts: Exports new UI components. - src/plugins/data/public/ui/query_editor/index.tsx: Modifies the QueryEditor component. The plugin includes a comprehensive test setup: - src/plugins/query_enhancements/test/: Contains Jest configuration and setup files for testing. Contains work by @sejli @joshuali925 @Swiddis @paulstn @mengweieric Thx @ashwin-pc for the description summary opensearch-project#6072 opensearch-project#6074 opensearch-project#6075 Commits include: * init Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * fixing bugs and removing target Signed-off-by: Sean Li <lnse@amazon.com> * add target and build to .gitignore Signed-off-by: Sean Li <lnse@amazon.com> * Remove SQL Async and Query Assist Going for the light weight solution for 2.15. So took out what wasn't required deliverable. However, I created a branch `feature/discover-next` which has the state where all the features where added so we can port it over post 2.15. Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * adding fix for PPL queries Signed-off-by: Sean Li <lnse@amazon.com> * Clean up files and add helper functions Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * final touches Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * [Discover-next] add query assist to query enhancements plugin (opensearch-project#6895) it adds query assist specific logic in query enhancements plugin to show a UI above the PPL search bar if user has configured PPL agent. Issues Resolved: opensearch-project#6820 * add query assist to query enhancements Signed-off-by: Joshua Li <joshuali925@gmail.com> * align language to uppercase Signed-off-by: Joshua Li <joshuali925@gmail.com> * pick PR 6167 Signed-off-by: Joshua Li <joshuali925@gmail.com> * use useState hooks for query assist There is a bug in data explorer `AppContainer` where memorized `DiscoverCanvas` gets unmounted after `setQuery`. PR 6167 works around it by memorizing `AppContainer`. As query assist is no longer being unmounted, we can use proper hooks to persist state now. Signed-off-by: Joshua Li <joshuali925@gmail.com> * Revert "pick PR 6167" This reverts commit acb0d41. Wait for official 6167 to merge to avoid conflict Signed-off-by: Joshua Li <joshuali925@gmail.com> * address comments for PR 6894 Signed-off-by: Joshua Li <joshuali925@gmail.com> --------- Signed-off-by: Joshua Li <joshuali925@gmail.com> (cherry picked from commit 016e0f2) * [Discover-next] Address comments for search bar extensions and query assist (opensearch-project#6933) * pass dependencies to isEnabled func Signed-off-by: Joshua Li <joshuali925@gmail.com> * add lazy and memo to search bar extensions Signed-off-by: Joshua Li <joshuali925@gmail.com> * move ppl specific string out from query assist Signed-off-by: Joshua Li <joshuali925@gmail.com> * prevent setstate after hook unmounts Signed-off-by: Joshua Li <joshuali925@gmail.com> * add max-height to search bar extensions Signed-off-by: Joshua Li <joshuali925@gmail.com> * prevent setstate after component unmounts Signed-off-by: Joshua Li <joshuali925@gmail.com> * move ml-commons API to common/index.ts Signed-off-by: Joshua Li <joshuali925@gmail.com> * improve i18n and accessibility usages Signed-off-by: Joshua Li <joshuali925@gmail.com> * add hard-coded suggestions for sample data indices Signed-off-by: Joshua Li <joshuali925@gmail.com> --------- Signed-off-by: Joshua Li <joshuali925@gmail.com> (cherry picked from commit 4aade0f) * [Discover-next] Support data sources for query assist (opensearch-project#6972) * disable query assist for non-default datasource Signed-off-by: Joshua Li <joshuali925@gmail.com> * disable query assist input when loading Signed-off-by: Joshua Li <joshuali925@gmail.com> * support MDS for query assist Signed-off-by: Joshua Li <joshuali925@gmail.com> * add unit tests for agents Signed-off-by: Joshua Li <joshuali925@gmail.com> * Revert "add unit tests for agents" This reverts commit 983514e. The test configs are not yet setup in query_enhancements plugins. Signed-off-by: Joshua Li <joshuali925@gmail.com> --------- Signed-off-by: Joshua Li <joshuali925@gmail.com> (cherry picked from commit 328e08e) * add query assist banner Signed-off-by: Joshua Li <joshuali925@gmail.com> * implement banner rendering logic Signed-off-by: Joshua Li <joshuali925@gmail.com> * pick opensearch-project/dashboards-observability/pull/1896 Signed-off-by: Joshua Li <joshuali925@gmail.com> * Conditionally render the data source select config Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * restore no space Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * add basic tests Signed-off-by: Joshua Li <joshuali925@gmail.com> * add index selector This is a temporary solution given that in discover the index pattern selector will be removed. Before datasource and dataset selectors are added, query assist will rely on this index pattern selector to determine which index user wants to query. Signed-off-by: Joshua Li <joshuali925@gmail.com> * MDS working with PPL and SQL Utilizing the work from MDS to make PPL and SQL calls to a remote cluster. Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * rename logo to mark Signed-off-by: Joshua Li <joshuali925@gmail.com> * extract supported languages to config Signed-off-by: Joshua Li <joshuali925@gmail.com> * Add missing license headers Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * initial implementation for async queries Signed-off-by: Sean Li <lnse@amazon.com> * remove queryId and sessionId from facet Signed-off-by: Sean Li <lnse@amazon.com> * fix: Update call out tests with intl wrapper Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * maintenance: Add and apply lint command Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * changing to observables Signed-off-by: Sean Li <lnse@amazon.com> * search interceptor and cleanup Signed-off-by: Sean Li <lnse@amazon.com> * moving polling class into plugin Signed-off-by: Sean Li <lnse@amazon.com> * Some minor clean ups plus lint Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * test: Add mock-heavy tests for sql search strategy Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * test: add GH workflows Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * More clean ups Add some props interfaces and consolidated some of the facets Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * chore: apply auto-lints to plugin Signed-off-by: Simeon Widdis <sawiddis@amazon.com> * Not done Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * working Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * working and styled Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * add connection service Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * Update public/types.ts Co-authored-by: Joshua Li <joshuali925@gmail.com> * Update public/plugin.tsx Co-authored-by: Joshua Li <joshuali925@gmail.com> * Update public/plugin.tsx Co-authored-by: Joshua Li <joshuali925@gmail.com> * fix linter Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * add more tests for query assist (opensearch-project#31) add more tests for query assist update eslint config to make it work increase index selector width Signed-off-by: Joshua Li <joshuali925@gmail.com> * fix!: remove dataSource key in get connection response The `Connection` type does not have the extra `dataSource` object around response, and most of the time code references connection over dataSource. remove the redundent object to make response consistent with type. Signed-off-by: Joshua Li <joshuali925@gmail.com> * change isEnabled to an observable based on selected connection Signed-off-by: Joshua Li <joshuali925@gmail.com> * protect duplicated calls Signed-off-by: Joshua Li <joshuali925@gmail.com> * [build] import via start services Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * Changeset file for PR opensearch-project#7212 created/updated * foobar Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * updating imports still in progress Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * Update more imports Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * fix setting of state Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * fixes bugs Signed-off-by: Kawika Avilla <kavilla414@gmail.com> * Update test Signed-off-by: Kawika Avilla <kavilla414@gmail.com> --------- Signed-off-by: Kawika Avilla <kavilla414@gmail.com> Signed-off-by: Sean Li <lnse@amazon.com> Signed-off-by: Joshua Li <joshuali925@gmail.com> Signed-off-by: Simeon Widdis <sawiddis@amazon.com> Co-authored-by: Sean Li <lnse@amazon.com> Co-authored-by: Joshua Li <joshuali925@gmail.com> Co-authored-by: Simeon Widdis <sawiddis@amazon.com> Co-authored-by: opensearch-changeset-bot[bot] <154024398+opensearch-changeset-bot[bot]@users.noreply.github.com> Signed-off-by: Kawika Avilla <kavilla414@gmail.com> (cherry picked from commit 9194d83) Signed-off-by: Sean Li <lnse@amazon.com>
Merged
7 tasks
ruanyl
pushed a commit
that referenced
this issue
Jul 23, 2024
#7400) Introduces the addition of a new core plugin called `Query Enhancements` This plugin seems to be focused on enhancing query capabilities, particularly in areas like PPL (Piped Processing Language), SQL, and natural language query assistance. The plugin is set up with the necessary configuration files: - src/plugins/query_enhancements/opensearch_dashboards.json: Defines the plugin's metadata and dependencies. - src/plugins/query_enhancements/common/config.ts: Contains the configuration schema for the plugin. - src/plugins/query_enhancements/public/plugin.tsx: The main plugin file that sets up the public-facing part of the plugin. - src/plugins/query_enhancements/server/plugin.ts: The server-side setup for the plugin. A significant part of the plugin is dedicated to a "Query Assist" feature: - src/plugins/query_enhancements/public/query_assist/: This directory contains components, hooks, and utilities for the Query Assist feature. - src/plugins/query_enhancements/public/query_assist/components/query_assist_bar.tsx: A React component for the Query Assist bar. - src/plugins/query_enhancements/server/routes/query_assist/: Server-side routing for Query Assist functionality. The plugin introduces several search interceptors: - src/plugins/query_enhancements/public/search/ppl_search_interceptor.ts - src/plugins/query_enhancements/public/search/sql_search_interceptor.ts - src/plugins/query_enhancements/public/search/sql_async_search_interceptor.ts These interceptors likely modify or enhance the search functionality for different query languages. There's a new feature for data source connections: - src/plugins/query_enhancements/public/data_source_connection/: This directory contains components and services for managing data source connections. The plugin implements server-side search strategies for different query types: - src/plugins/query_enhancements/server/search/ppl_search_strategy.ts - src/plugins/query_enhancements/server/search/sql_search_strategy.ts - src/plugins/query_enhancements/server/search/sql_async_search_strategy.ts There are some modifications to existing files outside the new plugin directory: - src/plugins/data/public/index.ts: Exports new types and interfaces. - src/plugins/data/public/ui/index.ts: Exports new UI components. - src/plugins/data/public/ui/query_editor/index.tsx: Modifies the QueryEditor component. The plugin includes a comprehensive test setup: - src/plugins/query_enhancements/test/: Contains Jest configuration and setup files for testing. Contains work by @sejli @joshuali925 @Swiddis @paulstn @mengweieric Thx @ashwin-pc for the description summary #6072 #6074 #6075 Commits include: * init * fixing bugs and removing target * add target and build to .gitignore * Remove SQL Async and Query Assist Going for the light weight solution for 2.15. So took out what wasn't required deliverable. However, I created a branch `feature/discover-next` which has the state where all the features where added so we can port it over post 2.15. * adding fix for PPL queries * Clean up files and add helper functions * final touches * [Discover-next] add query assist to query enhancements plugin (#6895) it adds query assist specific logic in query enhancements plugin to show a UI above the PPL search bar if user has configured PPL agent. Issues Resolved: #6820 * add query assist to query enhancements * align language to uppercase * pick PR 6167 * use useState hooks for query assist There is a bug in data explorer `AppContainer` where memorized `DiscoverCanvas` gets unmounted after `setQuery`. PR 6167 works around it by memorizing `AppContainer`. As query assist is no longer being unmounted, we can use proper hooks to persist state now. * Revert "pick PR 6167" This reverts commit acb0d41. Wait for official 6167 to merge to avoid conflict * address comments for PR 6894 --------- (cherry picked from commit 016e0f2) * [Discover-next] Address comments for search bar extensions and query assist (#6933) * pass dependencies to isEnabled func * add lazy and memo to search bar extensions * move ppl specific string out from query assist * prevent setstate after hook unmounts * add max-height to search bar extensions * prevent setstate after component unmounts * move ml-commons API to common/index.ts * improve i18n and accessibility usages * add hard-coded suggestions for sample data indices --------- (cherry picked from commit 4aade0f) * [Discover-next] Support data sources for query assist (#6972) * disable query assist for non-default datasource * disable query assist input when loading * support MDS for query assist * add unit tests for agents * Revert "add unit tests for agents" This reverts commit 983514e. The test configs are not yet setup in query_enhancements plugins. --------- (cherry picked from commit 328e08e) * add query assist banner * implement banner rendering logic * pick opensearch-project/dashboards-observability/pull/1896 * Conditionally render the data source select config * restore no space * add basic tests * add index selector This is a temporary solution given that in discover the index pattern selector will be removed. Before datasource and dataset selectors are added, query assist will rely on this index pattern selector to determine which index user wants to query. * MDS working with PPL and SQL Utilizing the work from MDS to make PPL and SQL calls to a remote cluster. * rename logo to mark * extract supported languages to config * Add missing license headers * initial implementation for async queries * remove queryId and sessionId from facet * fix: Update call out tests with intl wrapper * maintenance: Add and apply lint command * changing to observables * search interceptor and cleanup * moving polling class into plugin * Some minor clean ups plus lint * test: Add mock-heavy tests for sql search strategy * test: add GH workflows * More clean ups Add some props interfaces and consolidated some of the facets * chore: apply auto-lints to plugin * Not done * working * working and styled * add connection service * Update public/types.ts * Update public/plugin.tsx * Update public/plugin.tsx * fix linter * add more tests for query assist (#31) add more tests for query assist update eslint config to make it work increase index selector width * fix!: remove dataSource key in get connection response The `Connection` type does not have the extra `dataSource` object around response, and most of the time code references connection over dataSource. remove the redundent object to make response consistent with type. * change isEnabled to an observable based on selected connection * protect duplicated calls * [build] import via start services * Changeset file for PR #7212 created/updated * foobar * updating imports still in progress * Update more imports * fix setting of state * fixes bugs * Update test --------- (cherry picked from commit 9194d83) Signed-off-by: Kawika Avilla <kavilla414@gmail.com> Signed-off-by: Sean Li <lnse@amazon.com> Co-authored-by: Kawika Avilla <kavilla414@gmail.com>
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Overview
The following proposal aims to show an experience where a user can query their data in Discover through SQL
SQL Querying
Allow users to query federated data sources with SQL and have access to autocomplete as well as syntax highlighting to help them craft queries. If users have an integration on the table the auto-suggest recommendations should propose sample queries provided by the integration. Users can resize the query input window based on their needs - the area is scrollable.
The text was updated successfully, but these errors were encountered: