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’, ‘ [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.
Like you said it is a DB limitation, it seems SQL Server doesn’t support more than 2100 values in
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
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?