Joshua Kravitz

Genentech ID mismatch

1

For those not using the provided python code to load the data, note that the file `tcga_subtypes_id_map.csv` maps a genentech ID to a patient ID of 2397, even though that...

Fix concat macro when fields list is of length 1.

11

This pull request fixes the issue described [here](https://github.com/dbt-labs/dbt-utils/issues/827). Should this macro handle the case where `fields|length == 0`, or is that case handled upstream?

Support Bracketed Literals (SQL Server)

3

**Describe the bug** When referencing a linked server in [openquery](https://learn.microsoft.com/en-us/sql/t-sql/functions/openquery-transact-sql?view=sql-server-ver16) in SQL Server, sqlfmt incorrectly formats linked server names that are in brackets (with uncommon characters). In my case, the...

CREATE VIEW

2

**Describe the bug** When I prepend `create view MyView as` to a query, sqlfmt no longer formats the file. **To Reproduce** ``` CREATE VIEW myview AS SELECT * FROM mytable...

I have dbt_utils and tsql_utils installed. On one of my model's columns, I have the following test: ```yaml - name: MyColumn tests: - not_null - accepted_values: values: ["Opt1", "Opt2", "Opt3",...

`generate_surrogate_key` fails on SQL Server with one field

4

The culprit line is here: https://github.com/dbt-labs/dbt-utils/blob/6ba7b660b1d1b4e3b41cb0cf6c3c0e4a70ae54e4/macros/sql/generate_surrogate_key.sql#L27C35-L27C35 ```sql select a, b, c, d, {{ dbt_utils.generate_surrogate_key(["a"]) }} from my_table ``` results in error ```bash ('42000', '[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL...

"called `Option::unwrap()` on a `None` value" on mismatch between Prisma and database schema

7

Hi Prisma Team! My Prisma Client just crashed. Perhaps related to #10586? This is coming up repeatedly and really making it difficult to work with prisma... This is the report:...

Switching to grpc crashes search code

4

When I run the code on the REST API on port 6333, the below code works fine. ```python (matches, _) = client.scroll( collection_name="database_mock_df_flat", scroll_filter={ # type: ignore "must": [{"key": "CDS_ids",...

Server freezing on large data uploads

4

Large uploads cause server to freeze, perhaps due to read-lock issues. ## Current Behavior When uploading large collections using the [python qdrant client](https://github.com/qdrant/qdrant-client), the upload generally freezes before finishing. When...

**Is your feature request related to a problem? Please describe.** When using Cosine similarity, qdrant normalizes vectors. But, we sometimes need the unnormalized vector to run on-the-fly inference. **Describe the...