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 running dbt seed with nessie catalog #233

Open
1 task done
prd-huy-thai opened this issue Jun 18, 2024 · 1 comment
Open
1 task done

[Bug]: Error running dbt seed with nessie catalog #233

prd-huy-thai opened this issue Jun 18, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@prd-huy-thai
Copy link

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

  1. put csv files into seeds folder
  2. run dbt seed
  3. load data successfully but return ERROR: Version context for table nessie.xxxx.xxxx must be specified using AT SQL syntax

Expected Behavior

Load data successfully and not return error

Steps To Reproduce

  1. put csv files into seeds folder
  2. run dbt seed

Environment

- OS:ubuntu 22.04 LTS
- dbt-dremio: 1.7.0
- Dremio Software:none
- Dremio Cloud:none

Relevant log output

03:11:45  Found 4 models, 3 seeds, 0 sources, 0 exposures, 0 metrics, 440 macros, 0 groups, 0 semantic models
03:11:45  
03:11:46  Concurrency: 1 threads (target='dev')
03:11:46  
03:11:46  1 of 3 START seed file nessie.raw.raw_customers ................................ [RUN]
03:11:56  1 of 3 ERROR loading seed file raw.raw_customers ............................... [ERROR in 9.99s]
03:11:56  2 of 3 START seed file nessie.raw.raw_orders ................................... [RUN]
03:12:10  2 of 3 ERROR loading seed file raw.raw_orders .................................. [ERROR in 13.65s]
03:12:10  3 of 3 START seed file nessie.raw.raw_payments ................................. [RUN]
03:12:24  3 of 3 ERROR loading seed file raw.raw_payments ................................ [ERROR in 13.95s]
03:12:24  
03:12:24  Finished running 3 seeds in 0 hours 0 minutes and 39.07 seconds (39.07s).
03:12:24  
03:12:24  Completed with 3 errors and 0 warnings:
03:12:24  
03:12:24    Runtime Error in seed raw_customers (seeds/raw_customers.csv)
  ERROR: Version context for table nessie.raw.raw_customers must be specified using AT SQL syntax
03:12:24  
03:12:24    Runtime Error in seed raw_orders (seeds/raw_orders.csv)
  ERROR: Version context for table nessie.raw.raw_orders must be specified using AT SQL syntax
03:12:24  
03:12:24    Runtime Error in seed raw_payments (seeds/raw_payments.csv)
  ERROR: Version context for table nessie.raw.raw_payments must be specified using AT SQL syntax
03:12:24  
03:12:24  Done. PASS=0 WARN=0 ERROR=3 SKIP=0 TOTAL=3
@prd-huy-thai prd-huy-thai added the bug Something isn't working label Jun 18, 2024
@vitvara
Copy link

vitvara commented Dec 3, 2024

I’m facing the same issue. Do you have any solutions for it?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Development

No branches or pull requests

2 participants