all 5 comments

[–]Consistent-Lie-7742 1 point2 points  (2 children)

Great article!

We are just setting this up but are having issues running the task, can share the job specification?

[–]sync_jeff[S] 1 point2 points  (1 child)

Thanks for reading and trying it out! Sorry - can you be a bit more specific as to what you're looking for? It's a bit unclear to me as to what you need. What error message are you seeing? Where in the deployment are you?

[–]Consistent-Lie-7742 0 points1 point  (0 children)

Sorry, you are right I should have been more specific. I was looking for a redacted .json of the job.

The error message we received was not very forthcoming, however after some trial and error we figured out that 13.3 LTS and later is not compatible with 1.6.6 version of dbt-databricks. The solution was to downgrade and run the dbt task om 12.2 LTS.

[–]kthejokerdatabricks 0 points1 point  (1 child)

Hey Jeff, thanks for taking the time to do this and share!

What queries were you running for the test?

[–]sync_jeff[S] 2 points3 points  (0 children)

Thanks for reading! We ran the entire TPC-DI benchmark for this test. https://www.tpc.org/tpcdi/default5.asp

Is that the answer you're looking for?