WITH data AS (
SELECT COUNT(*) AS cnt FROM `env0-data-warehouse`.`env0_dbt_dev`.`entities_environments`
)
SELECT
`ta_1`.`iac_version` AS `ca_1`,
`ta_2`.`type` AS `ca_2`,
COUNT(`ta_1`.`id`) AS `ca_3`,
d.cnt AS total_count
FROM `env0-data-warehouse`.`env0_dbt_dev`.`entities_environments` AS `ta_1`
JOIN `env0-data-warehouse`.`env0_dbt_dev`.`entities_blueprints` AS `ta_2`
ON `ta_1`.`blueprint_id` = `ta_2`.`id`,
data d
WHERE NOT(`ta_1`.`iac_version` IS NULL)
GROUP BY
`ca_1`,
`ca_2`,
d.cnt
WITH data AS (
SELECT COUNT(*) AS cnt FROM `env0-data-warehouse`.`env0_dbt_dev`.`entities_environments`
)
SELECT
`ta_1`.`iac_version` AS `ca_1`,
`ta_2`.`type` AS `ca_2`,
COUNT(`ta_1`.`id`) AS `ca_3`,
d.cnt AS total_count
FROM `env0-data-warehouse`.`env0_dbt_dev`.`entities_environments` AS `ta_1`
JOIN `env0-data-warehouse`.`env0_dbt_dev`.`entities_blueprints` AS `ta_2`
ON `ta_1`.`blueprint_id` = `ta_2`.`id`,
data d
WHERE NOT(`ta_1`.`iac_version` IS NULL)
GROUP BY
`ca_1`,
`ca_2`,
d.cnt