Lucas Ortiz comments

Repositories
Issues
Comments

Results 2 comments of


                                            Lucas Ortiz

SQL Server error 8003 "too many parameters" on large seed with dbt-sqlserver >= 1.4.1

There are two issues here: 1) The [max_batch_size](https://docs.getdbt.com/reference/resource-configs/mssql-configs#seeds) var is not working 2) Even though this workaround worked in your case, it is not the final solution. The size of...

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

The issue is that the default macro creates a `concat` statement, even if it has only one column. As a quick fix, you can create a macro to generate the...