Querybook Files

Please check here for highlight features

What's Changed

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

New Contributors

• @lilyli9 made their first contribution in https://github.com/pinterest/querybook/pull/1138
• @suryabhaskarkarri made their first contribution in https://github.com/pinterest/querybook/pull/1156
• @okayhooni made their first contribution in https://github.com/pinterest/querybook/pull/1145
• @najma-kunju made their first contribution in https://github.com/pinterest/querybook/pull/1237
• @hawkesn made their first contribution in https://github.com/pinterest/querybook/pull/1260
• @jij1949 made their first contribution in https://github.com/pinterest/querybook/pull/1310
• @genzgd made their first contribution in https://github.com/pinterest/querybook/pull/1312
• @vinmh made their first contribution in https://github.com/pinterest/querybook/pull/1309
• @rbb17 made their first contribution in https://github.com/pinterest/querybook/pull/1315

Full Changelog: https://github.com/pinterest/querybook/compare/v3.14.2...v3.28.0