Anders

icon indicating a website link https://anders.omg.lol/ icon indicating an email [email protected]

icon company dbt Labs icon location Richmond, VA icon location the world is everything that is the case

Results 150 comments of Anders

Error while using the generate_surrogate_key macro with one field. The concat function requires 2 to 254 arguments

@lucaslortiz do you mind opening a PR that modifies this repo's `sqlserver__generate_surrogate_key`?

schema creation within `schema_test` sequence?

## why anders is avoiding temp tables in the test materialization so up front. the reason I'm not taking the the temp table route is: 1. temp tables are weird...

introspecting hangup during `dbt run` sequence steps

as an update, @drewbanin helpfully shared that adding something like below to the beginning of `run_test()` in the `spec_file.py` (around line 749) will at least print out the temporary location...

Update Changelog

linking https://github.com/dbt-labs/dbt-adapters/issues/178 as what screwed up the integration tests

[ADAP-949] [Bug] dbt docs generate timeout

re-opening per @dongchris's request in Slack. looking at #902, perhaps the BQ client has a baked in 600 second timeout if a timeout larger than 600 is provided?

[ADAP-949] [Bug] dbt docs generate timeout

This is related to #263 and #577. There actually may be a path to solve this with the recent update to the BQ python client library

[ADAP-781] [Feature] Add an option to use INFORMATION_SCHEMA for partition info retrieval

implementing #914 surfaced that some partition info is not available in the INFO SCHEMA, namely the partitions associated with a materialized view [Internal Slack thread](https://dbt-labs.slack.com/archives/C034EV1RH4Z/p1696526644206879). @wazi55 provided a workaround using...

[ADAP-882] [Feature] Allow base64-service-account-json key auth

@dbeatty10 I support this. In fact, I'd love to mainstream key handling into the default implementation. imo, a single implementation reduces risk. Happy to accept a PR adding support for...

[CT-3521] [Feature] Remove `REFRESH` from `snowflake_refresh_snowpipe`

hey @clementmg-getaround @olperri is my understanding here correct? > `REFRESH` should not be used in conjunction with Snowpipe, even when `AUTO_REFRESH=FALSE` Rather than remove the SQL statement about `REFRESH` I...

Add table expiry

any progress on this @thomas-vl?