get_profile does not work based on source #99
Description
-- depends_on: {{ source("fivetran_salesforce","opportunity") }}
{% if execute %}
{{ dbt_profiler.get_profile(relation=source("fivetran_salesforce","opportunity")) }}
{% endif %}
fails with this error:
Database Error in model profile_opportunity (models\profile_opportunity.sql)
syntax error at or near ")" in context "column_profiles as (
)"
compiled code:
create table
dev.profiles_salesfoce.profile_opportunity__dbt_tmp
as (
-- depends_on: rawdata.fivetran_salesforce.opportunity
with source_data as (
select
*
from rawdata.fivetran_salesforce.opportunity
),
column_profiles as (
)
select
column_name,
data_type,
row_count,
not_null_proportion,
distinct_proportion,
distinct_count,
is_unique,
min,
max,
avg,
median,
std_dev_population,
std_dev_sample,
profiled_at
from column_profiles
order by _column_position asc
);