Alison (she/her)

LA crime dataset link doesn't work

1

https://data.lacity.org/api/views/y8tr-7khq/rows.json?accessType=DOWNLOAD

Add View Test Examples

2

Hi, I'm looking for examples of view tests with rspec-rails. I'm currently replicating the example code here: https://relishapp.com/rspec/rspec-rails/v/3-3/docs/view-specs/view-spec but my tests still won't pass. Would love to see more in...

lack of database dialect difference support in test_expect_column_values_to_be_in_type_list

3

Hi, this is esoteric, but I ran scheduling software for 2 years and time zones will forever be my nemesis. From what I can tell, the `dbt_expectations.expect_column_values_to_be_in_type_list` test will cause...

Update to remove apt-key deprecation warning

1

When using the `CI.Dockerfile` [versioned link](https://github.com/dbt-msft/dbt-sqlserver/blob/49f9ff09a04264429995dfd3ad43b57901972239/devops/CI.Dockerfile), running the curl command to get the Microsoft key in order to install the Microsoft ODBC Driver provides a warning that apt-key is being...

Overriding other libraries usage of casting with `::` to avoid Incorrect syntax near '::' error

2

SQL Server doesn't support `::` casting. `dbt_utils` `default__current_timestamp()` uses `::` to perform the cast. I think this adapter, dbt-sqlserver, should adjust to support this case and any others lurking in...

One thing I found while troubleshooting other things is that `SERVER=company-sql-dev` won't work but `SERVER=1.1.1.1` will, when `company-sql-dev` is the named version of the server with the IP address `1.1.1.1`....

[ADAP-979] [Bug] Database Error: Only user perm tables supported in producer views

12

### Is this a new bug in dbt-redshift? - [X] I believe this is a new bug in dbt-redshift - [X] I have searched the existing issues, and I could...