Compilation Error in rpc request (from remote system.sql) Required var 'start_date' not found in config

[QingSun88]

When compile ‘base_ga4__events.sql’, it shows “Compilation Error in rpc request (from remote system.sql) Required var 'start_date' not found in config”. But actually I have set the var ‘start_date’ when I change required variables in dbt_project.yml (frequency: “streaming”) under the main file tree.

But when I run this model again, it shows success without error and create this table in my BigQuery.

So should I do anything to fix this error? Or just let it here?

[adamribaudo-velir]

I haven't run into this error, personally. Without being able to reproduce it, I think it will be hard to provide guidance. Can you provide any steps that consistently reproduce this issue?

And can you confirm that you're editing your project's dbt_project.yml and not the package's dbt_project.yml?

[QingSun88]

Yes, I confirm that I edit my project's dbt_project.yml. steps: add package to packages.yml →change required variables in project's dbt_project.yml file→run ‘dbt deps’ → run ‘dbt seed’ -->run models →add optional variables in project's dbt_project.yml --> complete models (some success, some fails for rpc request error)

[adamribaudo-velir]

Can you share the compiled SQL for the models that fail?

Get Outlook for Androidhttps://aka.ms/AAb9ysg

---

From: Qing Sun @.> Sent: Friday, March 31, 2023 8:35:02 AM To: Velir/dbt-ga4 @.> Cc: Adam Ribaudo @.>; Comment @.> Subject: Re: [Velir/dbt-ga4] Compilation Error in rpc request (from remote system.sql) Required var 'start_date' not found in config (Issue #159)

Yes, I confirm that I edit my project's dbt_project.yml. steps: add package to packages.yml →change required variables in project's dbt_project.yml file→run ‘dbt deps’ → run ‘dbt seed’ -->run models →add optional variables in project's dbt_project.yml --> complete models (some success, some fails for rpc request error)

— Reply to this email directly, view it on GitHubhttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FVelir%2Fdbt-ga4%2Fissues%2F159%23issuecomment-1491861477&data=05%7C01%7Cadam.ribaudo%40velir.com%7Cec06246570584fee8c4d08db31e45a3d%7C750f89c4532d43399fd9b605eca241c8%7C1%7C0%7C638158629057832761%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=aqcREpCJphINTb64hYcLtPzUd8VFYgzN54sDaOQmcks%3D&reserved=0, or unsubscribehttps://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FARCCAAGJD533VWCT76IBSULW63FPNANCNFSM6AAAAAAWGUYYKY&data=05%7C01%7Cadam.ribaudo%40velir.com%7Cec06246570584fee8c4d08db31e45a3d%7C750f89c4532d43399fd9b605eca241c8%7C1%7C0%7C638158629057832761%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=x02PwM8feUWfm7oNqYL55wan4uVrJWO9Yl1zmyHjsUI%3D&reserved=0. You are receiving this because you commented.Message ID: @.***>

[QingSun88]

This is the compiled code of 'base_ga4__events.sql'

This is the compiled code of 'stg_ga4__events.sql':

[yanchengcho]

run into this error too !

[adamribaudo-velir]

@yanchengcho @QingSun88 have you tried the latest releases and is this still an issue?