I have 5gb csv file which is in my seed directory. When I run dbt seed command ,process is getting killed.Is there any file size limitation? If yes,then what is the soln?
From the documentation:
Loading CSVs using dbt’s seed functionality is not performant for large files. Consider using a different tool to load these CSVs into your data warehouse.
Generally I regard anything beyond a MB or two beyond the range of what seeds were designed for.