Regarding LoolMl

[Surapureddys]

How to translate Lookml code from snowflake to Bigquery 

[a_shah]

Hi @Surapureddys 

The LookML code is not any database specific. It gets converted to the target database specific based on what is selected while configuring the dialect setting under database connection. You can easily switch between any databases as far as Looker is compatible based on the below link.

https://cloud.google.com/looker/docs/connecting-to-your-db#dialect

https://cloud.google.com/looker/docs/dialects

You can easily switch between dialects provided the structure is same and it is supported by Looker.

~Ashish 

[Dawid]

The only exception is if you used any native SQL in the field references, derived tables, joins, and so on. Then you can use this Snowflake migration translation guide for SQL: https://cloud.google.com/bigquery/docs/migration/snowflake-sql