Source
SnowConvert AI - BigQuery Issues
SnowConvert AI for Google BigQuery currently supports assessment and translation for TABLES and VIEWS. Although SnowConvert AI can recognize other types of statements, they are not fully supported.
SnowConvert AI - Redshift - Conditions
A BETWEEN condition tests expressions for inclusion in a range of values, using the keywords BETWEEN and AND.