Getting a list of test SQL strings

[teej]

I'm working on improving the Snowflake dialect in sqlglot. I've used an existing codebase of Snowflake SQL to check for parsing errors in sqlglot. I am now looking for a quick way to do the opposite: generate a large body of SQL that sqlglot thinks is valid in Snowflake, and check to see if Snowflake can successfully parse it.

Other than the list of expressions in identity.sql, I'm curious if there's a simple way to take all existing test cases and transpile them to Snowflake so I can attempt to verify them.

[tobymao]

all existing test cases? i’m not sure if there’s an easy way to do that.

you can override validate all helper function to generate snowflake