test(snowflake,bigquery): enable xpassing tests and relax read_csv schema assertion from float64 to numeric

test(snowflake,bigquery): enable xpassing tests and relax read_csv schema assertion from float64 to numeric #6217