Abhishek Singh

Results 24 comments of Abhishek Singh

Hi @sandhein Thank you for detailed report. My concern is that dropping of indexes and constraints is included in **renaming of relation** which is not expected. Ideally, truncate or dropping...

Hi @sandhein Just checking to see if you had a chance to explore [dbt_constraints](https://github.com/Snowflake-Labs/dbt_constraints) and if it solves your usecase?

@sandhein We could simply skip constraint creation if it already exists. Let me know if this works ? ``` {% macro primary_key(this, column) %} {% set index_name = 'PK_'+ this.name...

@sandhein I actually opened this thread to let you know that I had not forgotten about the issue and was thinking about a solution. And then I read your comment....

@Mirko-T `rows_affected` is set using `cursor.rowcount` as seen [here](https://github.com/oracle/dbt-oracle/blob/main/dbt/adapters/oracle/connections.py#L221) Documentation for `cursor.rowcount` states the following: > This read-only attribute specifies the number of rows that have currently been fetched from...

The new log line is local to my development branch. I added it for debugging to verify the value that is set in [AdapterResponse](https://github.com/oracle/dbt-oracle/blob/main/dbt/adapters/oracle/connections.py#L221)

@Mirko-T Let me publish the debug log to a new git branch. You should be able to `pip install` pointing to the git branch

@Mirko-T You can install the code using the following command. The only change is a new log statement to print `cursor.rowcount` ``` pip install git+https://github.com/oracle/dbt-oracle.git@debug/rowcount ```

@Mirko-T Did you add `--debug` option to dbt command ? I re-installed from the branch and tested it again ``` 16:54:11.103799 [debug] [Thread-2 ]: oracle adapter: SQL status: OK in...

@Mirko-T What is the installation output of the following command ? ``` pip install git+https://github.com/oracle/dbt-oracle.git@debug/rowcount ``` And the following ? ``` which dbt ``` Are you working with a python...