[CT-1016] [Bug] test tmp files aren't cleaned up when running /tests/functional/simple_seed

[iknox-fa]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

After running tests/functional/simple_seed/ a file is found at tests/functional/simple_seed/data/tmp.csv`

Expected Behavior

Running tests doesn't litter the repo with unwanted files.

Steps To Reproduce

/dbt-core/.tox/py-integration/bin/python -m pytest tests/functional/simple_seed
Check to see if file exists at tests/functional/simple_seed/data/tmp.csv

Relevant log output

No response

Environment

- OS:
- Python:
- dbt:

Which database adapter are you using with dbt?

No response

Additional Context

No response

[jtcohen6]

Resolution: add a cleanup step to TestSeedSpecificFormats to remove the auto-generated 20k seed file at the end of the test. pytest should make this very easy.

dbt-core/tests/functional/simple_seed/test_seed.py

Lines 271 to 275 in 348769f

	return {
	"big_seed.csv": big_seed,
	"seed.with.dots.csv": dotted_seed,
	"seed_unicode.csv": seed_unicode,
	}

becomes

 yield { 
     "big_seed.csv": big_seed, 
     "seed.with.dots.csv": dotted_seed, 
     "seed_unicode.csv": seed_unicode, 
 } 
# now remove big_seed.csv

[iknox-fa]

Resolved by #5749