fix(tests): make Athena S3 prefix tests self cleaning to avoid flaky CI reruns #4235

Job	Run time
changes	5s
test-dbt-versions (1.6)	1m 40s
test-dbt-versions (1.10)	1m 37s
test-dbt-versions (1.7)	1m 49s
test-dbt-versions (1.8)	1m 48s
test-dbt-versions (1.9)	1m 34s
test-dbt-versions (1.5)	1m 38s
test-dbt-versions (1.4)	1m 29s
test-dbt-versions (1.3)	1m 52s
test-vscode	0s
doc-tests	40s
cicd-tests-windows	10m 0s
migration-test	1m 27s
style-and-cicd-tests (3.9)	23m 21s
engine-tests-docker (duckdb)	1m 39s
style-and-cicd-tests (3.11)	24m 35s
engine-tests-docker (postgres)	2m 32s
style-and-cicd-tests (3.10)	22m 53s
engine-tests-docker (mysql)	2m 12s
engine-tests-docker (mssql)	1m 59s
engine-tests-docker (trino)	8m 15s
engine-tests-docker (spark)	5m 26s
engine-tests-docker (starrocks)	2m 51s
engine-tests-docker (risingwave)	2m 31s
engine-tests-docker (clickhouse)	2m 46s
style-and-cicd-tests (3.13)	34m 13s
style-and-cicd-tests (3.12)	26m 40s
ui-test	0s
ui-style	0s
test-vscode-e2e	-9s
engine-tests-cloud	-1s
	3h 7m 22s

Navigation Menu