Comments (9)
hi @maksym-dibrov-solidgate thank you writing this up. I agree that there's something seriously wonky about how dbt-redshift handles transactions after version 1.5
.
The predominant reason we cannot support user's defined transactions is due to an limitation of the redshift driver. see aws/amazon-redshift-python-driver#162. Ultimately, I feel that until that limitation is addressed, we cannot confidently address transactions in dbt without significant additional investment.
In the meantime, I'd be very interested to know how your project is configured that causes it to fail.
Can you share more about how your project is configured such that it fails after one second?
More importantly, can you help me create a minimal reproducible example of the behavior. As in, starting with vanilla jaffle_shop, what's the least I'd have to modify to reproduce the behavior you are seeing?
Last I'm curious if the behavior is different if you specify autocommit: False
in your profiles.yml (more info on autocommit
)
from dbt-redshift.
Related Issues (20)
- [Bug] `dbt debug` duplication of profiles field in output: sslmode, region
- [Bug] Add test for 9682 in core HOT 2
- Add GitHub action to push latest sha release as new semver to internal PyPI HOT 2
- [Unit Testing] Extend TestRedshiftUnitTestingTypes to include complex types
- [Bug] Configuration incorrectly infers hosts to be serverless or not HOT 2
- [Bug] Python driver 2.0.918 causes SSL error. Need to revert back to 2.0.917 HOT 2
- [Bug] hard pin ddtrace version to 2.3
- [Bug] `adapter.get_columns_in_relation` does not work cross database HOT 5
- [Regression] 'RedshiftRelation' object has no attribute 'lower' HOT 1
- [Bug] Full refresh not deleting materialized view with cascade HOT 1
- [Regression] Increased execution times with version 1.7 compared to version 1.3 HOT 2
- [Feature] Datasharing: cross-database support HOT 7
- [Feature] Lazy load `agate`
- Support Batch Metadata Freshness
- [Regression] Error in freshness tests on Redshift external tables (DBT Cloud) HOT 3
- [Feature] Support IAM role and IAM user testing in CI
- [Spike] Debug Redshift CI/CD failures HOT 1
- [SPIKE] Investigate state of transactions HOT 1
- [Feature] use redshift_connector for metadata wherever possible
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-redshift.