Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Error creating sql incremental model dbt_artifacts.invocations #409

Open
fatemehramezani opened this issue Nov 28, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@fatemehramezani
Copy link

fatemehramezani commented Nov 28, 2023

Overview

I found out it is possible to use run artifacts to get the used tables in source yaml file. But I got an error in creating the model.

How to reproduce

I want to get the list of used tables which are defined in _stg_sources.yml file. Therefore, I call the job like this:

dbt run --select dbt_artifacts

which is defined like this in dbt_project.yaml:

dbt_artifacts:
   +enabled: false
   sources:
     +enabled: true
     +schema: "artifacts"

It says create just sources and ignore the rest but it fails because of
image

All catalogs/schema in Databricks should be dropped and let dbt_artifacts to create its schema which out dependency to any other schema/catalog.

Expected behaviour

It should just build sources model and not the other models like dbt_artifacts.invocations or dbt_artifacts.seeds
If not then it should not fail because of dbt_artifacts.invocations

Screenshots

image

Environment

Results of running dbt --version:

# Add the results here
# dbt Cloud

Please paste the contents of your packages.yml file here:

packages:
  - package: brooklyn-data/dbt_artifacts
    version: 2.6.1
@fatemehramezani fatemehramezani added the bug Something isn't working label Nov 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant