60 Commits

Author SHA1 Message Date
FishtownBuildBot
54999b260f Cleanup main after cutting new 1.9.latest branch (#1255)
* Clean up changelog on main

* Bumping version to 1.10.0a1

* Code quality cleanup
2024-12-02 02:53:45 +00:00
Github Build Bot
139f5c3e25 Bumping version to 1.9.0b1 and generate changelog 2024-10-01 19:30:33 +00:00
FishtownBuildBot
c1f7acff8b Cleanup main after cutting new 1.8.latest branch (#1015)
* Clean up changelog on main

* Bumping version to 1.9.0a1

* Code quality cleanup

* Manually fix changelog backlinks.

* alter code to jog the release.

---------

Co-authored-by: Mila Page <67295367+VersusFacit@users.noreply.github.com>
Co-authored-by: Mila Page <versusfacit@users.noreply.github.com>
2024-05-07 09:20:14 -07:00
Github Build Bot
b265484b2d Bumping version to 1.8.0b3 and generate changelog 2024-04-17 16:02:05 +00:00
Github Build Bot
6ba882df33 Bumping version to 1.8.0b2 and generate changelog 2024-04-03 19:03:22 +00:00
Github Build Bot
7bfbcf690b Bumping version to 1.8.0b1 and generate changelog 2024-03-02 01:08:48 +00:00
FishtownBuildBot
cf854b5c1c Cleanup main after cutting new 1.7.latest branch (#804)
* Clean up changelog on main

* Bumping version to 1.8.0a1

* Code quality cleanup
2023-10-12 12:03:16 -05:00
Github Build Bot
336bd9f06a Bumping version to v1.7.0b2 and generate changelog 2023-09-15 16:25:24 +00:00
Github Build Bot
6f12f1af0b Bumping version to 1.7.0b1 and generate changelog 2023-08-17 21:48:56 +00:00
FishtownBuildBot
7ae6f9af30 Cleanup main after cutting new 1.6.latest branch (#693)
* Clean up changelog on main

* Bumping version to 1.7.0a1

* pre-commit

* changie merge

* add 1.6 to 0.0.md

* re trigger tests

---------

Co-authored-by: Matthew McKnight <matthew.mcknight@dbtlabs.com>
Co-authored-by: Matthew McKnight <91097623+McKnight-42@users.noreply.github.com>
2023-07-18 12:00:17 -05:00
Github Build Bot
e9a471db50 Bumping version to v1.6.0b3 and generate changelog 2023-06-08 22:40:42 +00:00
Matthew McKnight
b87ccc952c adding link to 1.5 release notes (#627)
* update RELEASE_BRANCH env

* adding link to 1.5 release notes

* run changie merge
2023-05-31 14:29:10 -04:00
Github Build Bot
7836cc76c9 Bumping version to 1.6.0b2 and generate changelog 2023-05-25 20:25:04 +00:00
Github Build Bot
4fa49768b8 Bumping version to 1.6.0b1 and generate changelog 2023-05-12 19:09:25 +00:00
github-actions[bot]
88f71395c1 [create-pull-request] automated change (#570)
Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
2023-04-18 11:36:44 -04:00
FishtownBuildBot
8341bdf53c Cleanup main after cutting new 1.5.latest branch (#565)
* Bumping version to 1.5.0rc1

* Clean up changelog on main

* run pre-commit to fix spacing issues

* update RELEASE_BRANCH env

---------

Co-authored-by: Matthew McKnight <matthew.mcknight@dbtlabs.com>
2023-04-14 15:52:27 -05:00
Github Build Bot
39bea56fb3 Bumping version to 1.5.0b4 and generate changelog 2023-03-30 20:01:59 +00:00
Github Build Bot
eba8c3cae9 Bumping version to 1.5.0b3 and generate changelog 2023-03-16 19:59:13 +00:00
Github Build Bot
0a3cf62508 Bumping version to 1.5.0b2 and generate changelog 2023-03-02 19:27:29 +00:00
Github Build Bot
09f5e8289a Bumping version to 1.5.0b1 and generate changelog 2023-02-22 21:03:17 +00:00
github-actions[bot]
0acfd33d62 Bumping version to 1.5.0a1 and generate changelog (#391)
* Bumping version to 1.5.0a1 and generate CHANGELOG

* update changelog for 1.5.0a1

Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
Co-authored-by: Emily Rockman <emily.rockman@dbtlabs.com>
2023-01-12 11:03:42 -08:00
github-actions[bot]
56f55f5006 Bumping version to 1.4.0b1 and generate changelog (#358)
* Bumping version to 1.4.0b1 and generate CHANGELOG

* Update 1.4.0-b1.md

* Update CHANGELOG.md

Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
Co-authored-by: Emily Rockman <emily.rockman@dbtlabs.com>
2022-12-15 12:32:58 -06:00
github-actions[bot]
c69e213376 Bumping version to 1.4.0a1 and generate changelog (#282)
* Bumping version to 1.4.0a1 and generate CHANGELOG

* Update changelog

Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
Co-authored-by: Leah Antkiewicz <leah.antkiewicz@fishtownanalytics.com>
2022-09-29 09:17:14 -04:00
github-actions[bot]
7bab1a2ba6 Bumping version to 1.3.0b2 and generate CHANGELOG (#243)
Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
2022-08-29 12:57:30 -04:00
Matthew McKnight
8c8a9c29d8 [Feature] add Changie to dbt-snowflake (#212)
* start adding changie cross over work, todo: convert current/previous changelog to changie style

* minor additions

* removed docs from kind type as only applies to dbt-core

* eof pre-commit changes

* create NO-ISSUE issue to point to in rare cases, link to dbt-core readme instead of duplicating

* create NO-ISSUE issue to point to in rare cases, link to dbt-core readme instead of duplicating

* move current changelog to 1.3.0.md reformat CHANGELOG.md

* update to main

* minor spacing change

* changelog reformat for all but one log which I am still trying to track down and prove we need in the dbt-snowflake changelog.

* swap to new reusable gha and change changelog message to include adapter contributing guide

* add changelog using new resuable gha

* remove older changelog entries, add previous releases to changelog.md

* eof fix

* rename file

* fix file

* did a changie merge to test, tried playing around with turning 0.0.0.md to footer.tpl.md

* reformatting to pre-merge state

* point to main

* typo fix

* run changie batch command

* eof fix

* add a changelog for changie addition to snowflake and rerun changie batch command

* eof fix

* move changelog

* eof fix

* run changie merge
2022-08-03 13:27:09 -05:00
github-actions[bot]
59f8cf04b5 Bumping version to 1.3.0b1 (#217)
* Bumping version to 1.3.0b1

* Update CHANGELOG.md

* Fix whitespace

Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
Co-authored-by: leahwicz <60146280+leahwicz@users.noreply.github.com>
2022-07-29 12:56:25 -04:00
Chenyu Li
c0b9274d24 python model beta version (#182)
support table and incremental materialization.
Co-authored-by: Jeremy Cohen <jeremy@dbtlabs.com>
Co-authored-by: Drew Banin <drew@dbtlabs.com>
2022-07-28 12:42:14 -07:00
Gerda Shank
f4f444e851 Support dbt-core incremental refactor (#196) 2022-07-25 11:53:55 -04:00
Matthew McKnight
d165385914 Ct 716 add materialization -- file reformat (#192)
* minor update

* 6/27 eod update

* adding standardize_grants_dict for snowlfake

* models are building but never seeing revoke statements

* updating snowflake implementation of apply_grants after pairing with jeremey and doug earlier today.

* post morning feedback updates

* remove _get_role and revert to filter based on OWNERSHIP

* ping original core dev-requirements pointer and note for post mergers in core to swap back to

* typo in dev-requirements.txt

* pre-commit fixes

* add test to functional tests

* adding in test envs and passing locally, augmented new envs in github on snowflake to match correctly

* add end line in file

* add envs to integration.yml

* fix typing issue

* nit file formatting

* push up addition of more tests pr

* incorporating message changes for snowflake specific error

* Account for refactor in dbt-labs/dbt-core@c763601

* Run test cases with copy_grants True, too

* test against ct-660 branch

* test against ct-660 branch

* change dev-requirments to point to main dbt-core and test

* add changelog

* minor file reformat

* changelog

* pre-commit fixes

* changelog reformat

Co-authored-by: Jeremy Cohen <jeremy@dbtlabs.com>
2022-07-13 15:49:54 -05:00
github-actions[bot]
981fe99981 Bumping version to 1.3.0a1 (#191)
* Bumping version to 1.3.0a1

* Remove whitespace

* Update CHANGELOG.md

Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
Co-authored-by: leahwicz <60146280+leahwicz@users.noreply.github.com>
2022-07-12 14:33:04 -04:00
Matthew McKnight
d53c327e20 Ct 716 add materialization (#178)
* minor update

* 6/27 eod update

* adding standardize_grants_dict for snowlfake

* models are building but never seeing revoke statements

* updating snowflake implementation of apply_grants after pairing with jeremey and doug earlier today.

* post morning feedback updates

* remove _get_role and revert to filter based on OWNERSHIP

* ping original core dev-requirements pointer and note for post mergers in core to swap back to

* typo in dev-requirements.txt

* pre-commit fixes

* add test to functional tests

* adding in test envs and passing locally, augmented new envs in github on snowflake to match correctly

* add end line in file

* add envs to integration.yml

* fix typing issue

* nit file formatting

* push up addition of more tests pr

* incorporating message changes for snowflake specific error

* Account for refactor in dbt-labs/dbt-core@c763601

* Run test cases with copy_grants True, too

* test against ct-660 branch

* test against ct-660 branch

* change dev-requirments to point to main dbt-core and test

* add changelog

Co-authored-by: Jeremy Cohen <jeremy@dbtlabs.com>
2022-07-11 15:30:24 -05:00
Lewis Davies
74bbae3a65 Improve column comment handling when persist_docs is enabled (#161)
* Persist docs for quoted column names

* Delete BigQuery tests

* Add cast col without name

* Update changelog

* Update changelog

Co-authored-by: Jeremy Cohen <jeremy@dbtlabs.com>
2022-07-05 13:19:25 +02:00
Jeremy Cohen
31e389064b Multi-query statements: fix rows_affected + query comments (#153)
* Add test for rows_affected

* Alt path for begin + commit. Query comments post-split

* Fix unit test

* Add changelog entry
2022-06-30 19:39:25 +02:00
github-actions[bot]
b9875e4674 Bumping version to 1.2.0b1 (#177)
* Bumping version to 1.2.0b1

* Remove whitespace

* Update CHANGELOG.md

Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
Co-authored-by: leahwicz <60146280+leahwicz@users.noreply.github.com>
2022-06-24 15:08:32 -04:00
Matthew McKnight
8db7d9f060 migrate oauth refresh script from core (#175)
* migrate oauth refresh script from core

* update eof error

* update changelog
2022-06-14 09:49:57 -05:00
Rob Scriva
0829bd3625 add set/unset_query_tag to the dbt macro namespace (#132)
* add set/unset_query_tag to the dbt macro namespace

* Update CHANGELOG.md

* Update CHANGELOG.md

* Update adapters.sql

* Add contributor entry

Co-authored-by: Gerda Shank <gerda@dbtlabs.com>
Co-authored-by: Jeremy Cohen <jeremy@dbtlabs.com>
2022-06-07 12:26:15 +02:00
Hugo Hobson
ae025b6021 Bump cryptography restraint upper bound to <37.0.0 (#171)
* Bump cryptography restraint upper bound

* Add CHAGNELOG entry

* Add contributor entry

Co-authored-by: Jeremy Cohen <jeremy@dbtlabs.com>
2022-06-06 14:24:51 +02:00
Matthew McKnight
c086d61650 rename dev_requirements -> dev-requirements to match dbt-core (#152)
* rename dev_requirements -> dev-requirements to match dbt-core

* changelog entry
2022-05-04 15:25:39 -05:00
Mila Page
ae31719cb0 Remove redudant pip install commands for workflow. (#145)
* Remove redudant pip install commands for workflow.

Surfaced by Chenyu in review of dbt-redshift PR 105. These are already found in the dev_requirements.txt and don't need explicit inclusion like so

* Add changelog.

Co-authored-by: Mila Page <versusfacit@users.noreply.github.com>
2022-04-25 14:27:39 -07:00
Mila Page
0f0634243e Ct 177/add precommit hooks (#107)
* Adding precheck manager, make tasks, workflows, and dev requirements to facilitate these workflows.
* Add commit hooks and get them working.
* Update Makefile for use in this repo.
* Add linecheck recipe (all Python lines over 99).
* Bring flake8 into compliance with dbt core.
* use checks over code and rewrite repo to conform to style conventions
* Mix in released snowflake 1.1.0b1
* Resolve a Black library issue
* Add changelog entry.
2022-03-29 13:02:19 -07:00
Gerda Shank
71f133fbe9 Initial use of adapter test framework (#106) 2022-03-29 11:47:45 -04:00
github-actions[bot]
8d9f1af959 Bumping version to 1.1.0b1 (#116)
* Bumping version to 1.1.0b1

* changelog update

* file name change

Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
Co-authored-by: Matthew McKnight <matthew.mcknight@dbtlabs.com>
2022-03-23 16:30:45 -05:00
Mila Page
032d2bb920 Add query_id to adapter payload and tests. (#109)
Co-authored-by: Mila Page <versusfacit@users.noreply.github.com>
Authored-by: Josh Taylor <joshuataylor@users.noreply.github.com>
2022-03-14 06:03:42 -07:00
Mila Page
71f2f43499 Test incremental model with unique key both as string and list (#96)
* Make general tests and tests for unique key as string. Add tests for unique key lists in incremental models.

* Code cleanup from code review. Revised the test for failures to be more accurate and performed a bit of renaming. I also folded two methods into setup that didn't need their own level of abstraction.

* Update changelog as requested in PR.

Co-authored-by: Mila Page <versusfacit@users.noreply.github.com>
2022-02-22 13:41:01 -08:00
Mila Page
a026ed4ba9 Add unique_key field to config sections where it is now expected as a result of core PR 4618. (#94)
Co-authored-by: Mila Page <versusfacit@users.noreply.github.com>
2022-02-10 11:00:10 -08:00
Anton Huck
fbf2b809a3 Use new agate_helper.Number type in tests for table creation (#76)
* Use new agate_helper.Number type for table creation

* Revert "Use new agate_helper.Number type for table creation"

This reverts commit 4d72ac7e72.

* Update test of Number type check from Boolean to 0,1
2022-01-05 09:13:29 -06:00
github-actions[bot]
390e1770f5 Bumping version to 1.0.0rc2 (#56)
* Bumping version to 1.0.0rc2

* Update changelog

Co-authored-by: Github Build Bot <buildbot@fishtownanalytics.com>
Co-authored-by: Jeremy Cohen <jeremy@dbtlabs.com>
2021-11-24 17:51:31 +01:00
Spencer Taylor
55f478b95f Add column comments to Snowflake views (#53)
* Add column comments to Snowflake views
* Update create_view_as macro to include column comments
* Add test for column-level view comments
* Add testing for column comments with non-lowercase column names

* Organizing adapter macros for column persistence
2021-11-19 18:26:39 +01:00
R. Joshua Huntley
e1ee1c8d9a Update connections.py (#49)
* Update connections.py

Resolves issues when the Snowflake OCSP server is not reachable and the dbt user would like to run commands without checking the OCSP server. OCSP failures/inaccessibilitiy are possible due to network routing issues or when corporate network security has exposed Snowflake (especially in privatelink) but not the OCSP server.

* Update CHANGELOG.md

Adding changelog information

* Update CHANGELOG.md

Co-authored-by: Jeremy Cohen <jtcohen6@gmail.com>

* Update changelog and unit test

Updated changelog and unit tests as requested.

* Fix typo

Co-authored-by: Jeremy Cohen <jtcohen6@gmail.com>
Co-authored-by: Jeremy Cohen <jeremy@dbtlabs.com>
2021-11-19 13:15:31 +01:00
Anton Huck
9194552cdb Fix: Support individual query tag configuration for Seeds and Snapshots (#48)
* Add Query Tag for Seed

* Add Query Tag for Snapshots

* Add Changelog for #48

* Add Snapshot with Query Tag test

* Add Seed with Query Tag test
2021-11-19 12:05:28 +01:00