You can enable full SQL ELT optimization when you want to load data from Google Cloud Storage sources to your data warehouse in Google BigQuery. While loading the data to Google BigQuery, you can transform the data as per your data warehouse model and requirements. When you enable full SQL ELT optimization on a mapping task, the mapping logic is pushed to the GCP environment to leverage GCP commands. For more information, see the help for Google BigQuery V2 Connector.
If your use case involves loading data to any other supported cloud data warehouse, see the connector help for the applicable cloud data warehouse.