fix: Interpret s3tables warehouse as table_location not metadata loca… #6543

Job	Run time
build_with_no_default_features (macos-latest)	2m 22s
build_with_no_default_features (windows-latest)	4m 13s
build_with_no_default_features (ubuntu-latest)	1m 43s
Tests (default)	7m 56s
check (macos-latest)	3m 4s
Verify MSRV	3m 0s
build (windows-latest)	7m 59s
check (ubuntu-latest)	2m 44s
Tests (doc)	4m 45s
build (macos-latest)	8m 13s
build (ubuntu-latest)	7m 26s
	53m 25s

Provide feedback