Querybook 3.28.0

Please check here for highlight features

What's Changed

• docs: add security advisory info by @czgu in #1094
• fix: notify_user need to accept user not uid by @czgu in #1095
• fix: sidebar search should use relevance instead of alphabetical by @czgu in #1096
• fix: remove python-dev from dockerfile build by @czgu in #1098
• fix: boost table score for exact match when searching table by @jczhong84 in #1097
• Tune exact match boost score of table search by @jczhong84 in #1099
• fix: scheduled docs with latest_partition fail to run by @jczhong84 in #1101
• fix: hasOwnProperty is not a function issue from json-big by @jczhong84 in #1103
• feat: add support of running all cells of a data doc by @jczhong84 in #1102
• feat: add logout event hook by @czgu in #1104
• Add 2022 change logs by @jczhong84 in #1105
• feat: Make exact table search result auto show up by @czgu in #1106
• feat: Add shortcut for toggle ToC, update datadoc short cuts by @czgu in #1107
• fix: Chart date axis bug by @czgu in #1108
• feat: auto add quotes for table/columns by @czgu in #1109
• feat: add websocket logging by @jczhong84 in #1110
• fix: update event_log table schema by @jczhong84 in #1111
• feat: add drag and drop for templated variables by @czgu in #1112
• feat: a bunch of small ui fixes and improvements by @czgu in #1114
• feat: add frontend context logging by @jczhong84 in #1115
• move change log images to docs_website by @jczhong84 in #1117
• feat: validation now works for templated query by @czgu in #1119
• Add some frontend view/click events by @jczhong84 in #1118
• fix: Add disabled indicators to Schedules list by @baumandm in #1122
• feat: Visualize complex Hive column types v2 by @baumandm in #1091
• fix: Extend DataTableColumn type column length by @baumandm in #1121
• chore: update yaml-loader by @jczhong84 in #1124
• [Snyk] Security upgrade qs from 6.10.1 to 6.10.3 by @devinlundberg in #1092
• [Snyk] Security upgrade setuptools from 39.0.1 to 65.5.1 by @devinlundberg in #1113
• fix: remove duplicate volume mount by @jczhong84 in #1126
• chore: version upgrade a few packages by @czgu in #1123
• chore: update richtext editor to hooks by @czgu in #1127
• fix: json-bigint hasOwnProperty undefined issue by @jczhong84 in #1129
• fix: update /event_log api path by @jczhong84 in #1130
• fix: react-table version by @jczhong84 in #1132
• fix: axios error display by @czgu in #1133
• fix: remove timeout for presto explain by @czgu in #1135
• feat: add metastore loader config by @jczhong84 in #1134
• Feat: add enable and list filters for Scheds by @alexVasylenko in #1076
• fix: stay on current env after deleting doc by @lilyli9 in #1138
• chore: refactor DataTableView to hooks by @czgu in #1137
• add axios request timeout option by @jczhong84 in #1139
• chore: Move QueryViewNavigator to hooks by @czgu in #1140
• feat: query engine search scroll by @lilyli9 in #1136
• feat: add search box to hide columns popup by @lilyli9 in #1128
• fix: add safe suppress to sqlformat error by @czgu in #1141
• ui: Update searchbar css by @czgu in #1142
• fix: clicking a readonly text cell causes querybook crash by @jczhong84 in #1148
• fix: Fix Scheduled DataDocs Only toggle by @baumandm in #1149
• feat: add user group db schema support by @jczhong84 in #1144
• fix: sql-formatter by @jczhong84 in #1152
• fix: event logger when current user is None by @jczhong84 in #1153
• fix: number type variable with value 0 by @jczhong84 in #1154
• chore: not notify on query linting exceptions by @jczhong84 in #1155
• feat: support for a general validation message in query editor by @suryabhaskarkarri in #1156
• feat: add message when linter failed to run by @czgu in #1157
• feat: add estimated time for query execution by @czgu in #1158
• fix: unify status code and move user error to 400 by @czgu in #1161
• fix: filter null store values by @lilyli9 in #1163
• feat: toggle run all notifications by @lilyli9 in #1162
• feat: Add ability to cancel dead queries by @czgu in #1159
• fix: Revert "feat: add estimated time for query execution (#1158)" by @czgu in #1166
• refactor: progress ui by @czgu in #1168
• add more configurations for ldap integration by @okayhooni in #1145
• update querybook helm charts by @okayhooni in #1147
• ui: fix overflow for long usernames by @czgu in #1173
• chore: display error message from sql-formatter by @jczhong84 in #1175
• chore: upgrade sql-formatter by @jczhong84 in #1177
• fix: Enable mssql transpiling by @baumandm in #1178
• feat: add descriptive error msgs by @lilyli9 in #1150
• feat: make struct form fields ordered by @czgu in #1181
• feat: add more metadata support by @jczhong84 in #1182
• feat: find the closed color in ColorPalette by @jczhong84 in #1184
• fix: find nearest color by @jczhong84 in #1185
• feat: add button to sort columns in view table UI by @lilyli9 in #1187
• feat: add new metadata type - data element by @jczhong84 in #1191
• fix: add tooltip length by @jczhong84 in #1192
• feat: create data element along with syncing table by @jczhong84 in #1193
• docs: add helm deployment guide by @yongchand in #1183
• feat: display data element description as column description by @jczhong84 in #1195
• fix: check nullish of table property value by @jczhong84 in #1197
• fix: some bug fix related to tag and data element by @jczhong84 in #1199
• fix: remove broadcast from socketio.emit by @jczhong84 in #1202
• docs: update the step by step guide of connecting to a query engine by @jczhong84 in #1201
• fix: column name overlaps with type by @jczhong84 in #1203
• feat: add stats logging by @jczhong84 in #1204
• feat: add configurable timeout for Presto to querybook by @czgu in #1207
• feat: update stats metrics names and add tags by @jczhong84 in #1208
• fix: update data_element table charset to utf8 by @jczhong84 in #1209
• fix: add get_schema_location to metastore loader by @jczhong84 in #1214
• feat: add data elements to ES index by @jczhong84 in #1213
• fix: EntitySelect by @jczhong84 in #1215
• fix: dup table description in table search by @jczhong84 in #1216
• fix: skip empty query cells when run datadoc by @jczhong84 in #1217
• [Snyk]: Security upgrade redis from 4.3.4 to 4.3.6 by @snyk-bot in #1205
• fix: title format check for Snyk by @jczhong84 in #1219
• [Snyk]: Fix for 2 vulnerabilities by @devinlundberg in #1143
• [Snyk]: Security upgrade werkzeug from 2.2.2 to 2.2.3 by @devinlundberg in #1167
• feat: make datadoc table of contents sidebar resizable by @jczhong84 in #1218
• chore: updgrade some packages by @jczhong84 in #1222
• fix: use incr for ws disconnect stats events by @jczhong84 in #1223
• fix: make entity select creatble be false by default by @jczhong84 in #1227
• feat: add data elements to demo by @czgu in #1232
• feat: add data element on the sidebar, show descriptions by @czgu in #1233
• fix: metastoreId can be ill defined by @czgu in #1235
• ui: show full description on hover by @czgu in #1234
• fix: Ensure meta_info is updated when an exception occurs by @baumandm in #1230
• ui: enable remove datadoc from sidebar by @meowcodes in #1241
• feat: tune table search ranking by @jczhong84 in #1248
• ui: long table name fix by @meowcodes in #1246
• Fix: IO Exception on closed file by @najma-kunju in #1237
• ui: show last updated if untitled doc by @meowcodes in #1247
• fix: showing values from a null value by @jczhong84 in #1256
• feat: Generate query title by using LLM by @jczhong84 in #1255
• pass user_id to the ai help functions by @jczhong84 in #1264
• feat: add error handling and use EventSource for AI assistant by @jczhong84 in #1265
• Add monkey patching and api plugin by @jczhong84 in #1266
• upgrade nodejs from v16 to v18 by @jczhong84 in #1267
• add lowercase filter to user_content_analyzer by @jczhong84 in #1268
• fix: Ignore monkey patch/api plugin import error by @jczhong84 in #1269
• feat: Injectable Secrets into the Helm Chart by @hawkesn in #1260
• feat: add query auto fix in AI assistant by @jczhong84 in #1270
• feat: add LLM powered text2sql support by @jczhong84 in #1276
• feat: add context logging for AI features by @jczhong84 in #1277
• fix: delta stream parser by @jczhong84 in #1280
• fix: crash on stream parser error by @jczhong84 in #1281
• Fix: query title disappears when opening a datadoc by @jczhong84 in #1286
• fix: only handle the query generation keydown event when not streaming by @jczhong84 in #1287
• feat: data cell + table comments by @meowcodes in #1279
• fix: some small changes of ai assistant by @jczhong84 in #1290
• fix: add post processing to ai generated content by @jczhong84 in #1291
• ui: strip space from search string by @meowcodes in #1294
• ui: comment ui updates by @meowcodes in #1295
• feat: adopt data element in text2sql prompt by @jczhong84 in #1301
• feat: use proxy user as username to sqlalchemy executor by @jczhong84 in #1303
• Implement query linter suggestions by @kgopal492 in #1306
• fix: UI Tutorial 8-11 now focuses on page components by @jij1949 in #1310
• fix: table warning displaying on wrong table by @jij1949 in #1307
• fix: Board Ownership Transfer did not reassign owner by @jij1949 in #1299
• Update table search boost scores by @kgopal492 in #1313
• Add clickhouse-connect as recommended ClickHouse SQLAlchemy provider by @genzgd in #1312
• fix: init_es.py script not completing due to AttributeError by @vinmh in #1309
• Add query_execution_id and execution_type as properties to QueryExecutorBaseClass by @kgopal492 in #1316
• feat: load table warnings from metastore by @jczhong84 in #1317
• Add Username + Password Authentication for Trino Client (fixes #829) by @rbb17 in #1315
• fix: Migrate to new Nodesource repository by @baumandm in #1318
• feat: refactor ai-assistant plugin and add vector search support by @jczhong84 in #1325
• bump version for ai-assistant and vector store by @jczhong84 in #1326
• docs: add change logs of 20230920 by @jczhong84 in #1327

New Contributors

• @lilyli9 made their first contribution in #1138
• @suryabhaskarkarri made their first contribution in #1156
• @okayhooni made their first contribution in #1145
• @najma-kunju made their first contribution in #1237
• @hawkesn made their first contribution in #1260
• @jij1949 made their first contribution in #1310
• @genzgd made their first contribution in #1312
• @vinmh made their first contribution in #1309
• @rbb17 made their first contribution in #1315

Full Changelog: v3.14.2...v3.28.0