func assertTestSchema(t *testing.T, propertiesYaml string, expectedTestSQL string) {
	schema := &properties.File{}
	require.NoError(t, schema.Unmarshal([]byte(propertiesYaml)), "Unable to parse schema YAML")
	tests, err := schema.DefinedTests()
	require.NoError(t, err)
	require.Len(t, tests, 1, "Only expected 1 test to be generated")
	fileSystem, gc, _ := CompileFromRaw(t, "SELECT 1 as column_a")
	for testName, testContents := range tests {
		file, err := fileSystem.AddTestWithContents(testName, testContents, true)
		require.NoError(t, err, "Unable to add test file")
		require.NoError(t, compiler.ParseFile(file), "Unable to parse test file")
		require.NoError(t, compiler.CompileModel(file, gc, true), "Unable to compile test file")
		assert.Equal(t, expectedTestSQL, file.CompiledContents, "Compiled test doesn't match")
	}
}
Helper function for testing schema tests
package tests
import (
	"testing"
	"github.com/stretchr/testify/assert"
	"github.com/stretchr/testify/require"
	"ddbt/compiler"
	"ddbt/properties"
)
const testTableRef = "`unit_test_project`.`unit_test_dataset`.`target_model`"