Comments (3)
I believe the culprit is get_node_representation
.
Spark's profile.yml
config requires the user to specify schema
. A user can optionally also specify database
, which is meaningless, because schema == database in Spark. I confirmed that I see this issue when I specify only schema
in my profile, and the leading period disappears when I also specify database
with the same value as schema
. This is a bit surprising, since we set database = schema
as a _post_init
on the credentials object.
I'm not sure if there's a way to override get_node_representation
for Spark, since it's a class method on ModelRunner
, not BaseAdapter
.
This leads me to think there could be more serious functional issues related to the database
model configs that I haven't had a chance to test yet.
from dbt-spark.
After more testing, I confirmed this is not an issue with the profile configs, but with relations themselves. Given a profile that sets schema: my_schema_name
, this error disappears if I set the following in dbt_project.yml
:
models:
my_project:
database: my_schema_name
At the same time, if I set it to be something else entirely:
models:
my_project:
database: not_the_same
dbt will print out
1 of 15 START table model not_the_same.my_schema_name.table_model..... [RUN]
But it will actually just attempt to create a table located at the namespace my_schema_name.table_model
.
I'm going to open a separate issue laying out how I think we should reconcile custom schemas and databases, likely for 0.17.0.
from dbt-spark.
Fixed by dbt#2450. We should enjoy nicer-looking output in 0.17.0
from dbt-spark.
Related Issues (20)
- [ADAP-999] [Feature] add support for Apache Paimon format HOT 1
- [ADAP-1012] Support for new agate data type in Spark
- [ADAP-1018] [Feature] Remove Databricks test profiles from integration tests HOT 2
- [ADAP-1019] [Bug] Table already exists, you need to drop it first in incremental models HOT 1
- [ADAP-1038] [Tests] Add tests for --empty flag
- [ADAP-1048] [Bug] Replacing existing table using incremental model HOT 1
- [ADAP-1071] [Bug] `latest` and `1.x.latest` tags for ghcr Docker releases are stale HOT 1
- [ADAP-1074] [Implementation] Remove `invalid_insert_overwrite_delta_msg` message
- [ADAP-1085] [Bug] When using iceberg format, dbt docs generate is unable to populate the columns information HOT 1
- [ADAP-1093] [Feature] Run integration tests against all supported python versions
- [Feature] Support HTTP transport protocol for Thrift method
- [Feature] Support OCI Dataflow as a backend for dbt-spark
- `dbt-core` Dockerfile does not work for `dbt-spark` due to `PyHive` HOT 2
- [Bug] CI is broken on `main` due to dependency resolution and timeout issues HOT 1
- [Feature] Spike on supporting Py3.12
- [Bug] The tblproperties are not applied when using Python Model to create a table HOT 1
- [Issue] sasl as a dependency HOT 3
- [Feature] Livy connection support for Spark SQL models
- [Unit Testing] Add functional tests for unit testing: HOT 1
- [Bug] dbt docs generate does not include Data Type (data stored in iceberg format) HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbt-spark.