[Creating dimensions] The solutions in the lab seem to use SQL Server SQL dialect, but when I tried testing out the new dimensions in an explore in the Kitchen Table sandbox, I got errors. The database in the Kitchen Table sandbox is a Google

The solutions in the lab seem to use SQL Server SQL dialect, but when I tried testing out the new dimensions in an explore in the Kitchen Table sandbox, I got errors. The database in the Kitchen Table sandbox is a Google BigQuery database. For example: DATEDIFF should be DATE_DIFF, and the interval parameter should thus be the 3rd one instead of the 1st.