The Analytics Canvas BigQuery SQL builder for GA4 is available in Beta within Analytics Canvas Online. Once fully released, the Desktop application will have this connector. Until then, there is an easy way for users to make a query in Canvas Online and execute it behind your firewall and on your local machine using Analytics Canvas Desktop and Server. This video shows you how!
The video refers to this article for using Date parameters in BigQuery SQL:
analyticscanvas.com/knowledge...