14 lines
302 B
SQL
14 lines
302 B
SQL
|
{{ config(
|
||
|
|
materialized='table',
|
||
|
|
schema='gold'
|
||
|
|
) }}
|
||
|
|
|
||
|
|
SELECT
|
||
|
|
CAST(issued_date AS DATE) AS permit_date,
|
||
|
|
permit_type,
|
||
|
|
permit_status,
|
||
|
|
COUNT(permit_id) AS total_permits,
|
||
|
|
CURRENT_TIMESTAMP AS refreshed_at_gold
|
||
|
|
FROM {{ ref('silver_environmental_permits_clean') }}
|
||
|
|
GROUP BY 1, 2, 3
|