UoMConversion.sql

#-- Copyright 2022 Google LLC
#--
#-- Licensed under the Apache License, Version 2.0 (the "License");
#-- you may not use this file except in compliance with the License.
#-- You may obtain a copy of the License at
#--
#--     https://www.apache.org/licenses/LICENSE-2.0
#--
#-- Unless required by applicable law or agreed to in writing, software
#-- distributed under the License is distributed on an "AS IS" BASIS,
#-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#-- See the License for the specific language governing permissions and
#-- limitations under the License.

CREATE OR REPLACE TABLE FUNCTION `{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.UoMConversion`(mandt_in STRING, unit_in STRING, unit_out STRING, val_in NUMERIC)
AS
{% if sql_flavour == 'ecc' or sql_flavour == 'union' -%}
{% include './ecc/UoMConversion.sql' -%}
{% endif -%}

{% if sql_flavour == 'union' -%}
UNION ALL
{% endif -%}

{% if sql_flavour == 's4' or sql_flavour == 'union' -%}
{% include './s4/UoMConversion.sql' -%}
{% endif -%}
OPTIONS (description = "This function returns the equivalent value of a quantity in a different unit of measurement, after applying specific conversion factor.")