fix(schema-compiler): hierarchies to respect prefix value (#9239) #3653

Job	Run time
latest-tag-sha	19s
Build native Linux 20 x86_64-unknown-linux-gnu Python fallback	3m 6s
build	6m 55s
tests (20.x, athena-export-bucket-s3)	18m 47s
tests (20.x, bigquery-export-bucket-gcs)	8m 8s
tests (20.x, clickhouse)	5m 51s
tests (20.x, clickhouse-export-bucket-s3)	5m 21s
tests (20.x, databricks-jdbc)	6m 8s
tests (20.x, databricks-jdbc-export-bucket-s3)	7m 33s
tests (20.x, databricks-jdbc-export-bucket-azure)	6m 24s
tests (20.x, mssql)	5m 44s
tests (20.x, mysql)	5m 15s
tests (20.x, postgres)	5m 12s
tests (20.x, redshift)	6m 28s
tests (20.x, redshift-export-bucket-s3)	5m 48s
tests (20.x, snowflake)	5m 33s
tests (20.x, snowflake-export-bucket-s3)	5m 38s
tests (20.x, snowflake-export-bucket-azure)	5m 38s
tests (20.x, snowflake-export-bucket-azure-via-storage-integration)	5m 39s
tests (20.x, snowflake-export-bucket-gcs)	5m 41s
	2h 5m 8s

Provide feedback