Hi Team, We are facing one issue.. We are running ...
# community-support
m
Hi Team, We are facing one issue.. We are running one model in the turbo ci, but it is failing with error - On debugging it is found that actual model is working fine, but command is failing. Looks like it is failing with one of the elementary step. Can anyone help here? TIA. @Maayan Salom
Copy code
SQL compilation error:
INSERT statement's target must be a table
m
Hey @Mandar , This usually happens when an Elementary table is missing from the target schema. Can you please try running
dbt run --select elementary --target <target>
with target being the same one of the Turbo CI?
m
Thanks @Maayan Salom I will run following commands-
Copy code
dbt run --select elementary --target CI-UK
dbt run --models incremental_cloning --target CI-UK
m
Did it work @Mandar
?
m
Yes @Maayan Salom, It is working as expected.
Thanks a lot
Hey Team, I am getting an error while running edr monitor. Can someone know how can we fix it? error-
Copy code
Encountered an error while running operation: Database Error
SQL compilation error: error line 46 at position 16
invalid identifier 'ALERTS_IN_TIME_LIMIT.FRESHNESS_ERROR_AFTER'
command-
Copy code
edr monitor --suppression-interval 24 --slack-token $EDR_SEND_REPORT_SLACK_TOKEN --slack-channel-name kyx-domain-data-alerts
I am getting one more error in another workspace-
command- edr monitor --suppression-interval 24 --slack-token $EDR_SEND_REPORT_SLACK_TOKEN --slack-channel-name mam-domain-data-alerts
Here, I have dbt version-1.3.2(KYX) error-
suppression-interval parameter is not available
m
Hey @Mandar, I answered the first issue in the other thread you opened. About the error
suppression-interval parameter is not available
I see 2 options - you are running edr in an old version (this param was introduced in 0.9.1) or the Slack token isn't picked up by the CLI, and so the param is invalid.