Error while processing seed -'The incoming request has too many parameters'

Help
1

I am trying to create a seed file with 128 rows and 20 columns in dbt project. I am getting below DB error while seed creation.

Database Error :
06:06:59 (‘42000’, ‘[42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. (8003) (SQLExecDirectW)’)

Requesting help on this.

2

Like you said it is a DB limitation, it seems SQL Server doesn’t support more than 2100 values in in statement.

You could divide it into 2 seeds and use a model to union them in your project

If you can’t divide it, and if it rarely changes, you can load the csv manually into your DW and use it as a source

3

Thanks @brunoszdl for the response🙂.

I am able to solve this issue by dividing seed file. But wondering if there is any other possible way to solve this-without dividing and manually loading seed file?