Unit testing on relations with a float column broken?

[mattsmith123]

I'm attempting to write dbt unit tests on a relation with a float column. dbt wants to create fixture data by querying the table schema from the adapter and then using that to generate select statements with TRY_CAST calls to coerce the fixture data from the unit test YAML to the relation's type.

The tricky part is that the adapter returns float and because TRY_CAST is technically a DML operation Athena expects real.

Are there any work arounds for this?

[mattsmith123]

Note: I was able to work around this by using a sql based fixture