feat: Enable semantic views #4221

sfc-gh-asawicki · 2025-11-20T19:58:25Z

Add snowflake_semantic_view resource and snowflake_semantiv_views data source
Fix/improve the implementation
- Handle renaming through ALTER
- Handle objects in a case-sensitive way
- Fix metrics with window functions
- Add more integration tests and improve the acceptance ones
- Remove describe output from resource and data source
- Adjust the SDK
- Mark table_alias as required
- Move SDK gen definition to the new dir
Generate the docs
Document al the limitations
Update the migration guide

github-actions · 2025-11-21T01:36:04Z

Account-level tests failure for ba10b56a3b28d9dc2c939ee09d6e81bc1d798d04

github-actions · 2025-11-21T03:18:41Z

Integration tests success for ba10b56a3b28d9dc2c939ee09d6e81bc1d798d04

docs/data-sources/semantic_views.md

pkg/resources/semantic_views.go

pkg/resources/semantic_view.go

sfc-gh-jmichalak

Merge conflicts and +1 to Jan's comment.

pkg/testacc/data_source_semantic_views_acceptance_test.go

github-actions · 2025-11-21T10:42:47Z

Integration tests cancelled for f376edb1016f11bb3a65642579c774813915973f

github-actions · 2025-11-21T10:50:00Z

Integration tests cancelled for 3b425dbe9662da6bd0ac76b2ae0f92f9b1bc4598

github-actions · 2025-11-21T11:24:56Z

Account-level tests success for f376edb1016f11bb3a65642579c774813915973f

🤖 I have created a release *beep* *boop* --- ## [2.11.0](v2.10.1...v2.11.0) (2025-11-21) ### 🎉 **What's new:** * Add notebook datasource ([#4209](#4209)) ([5599cfe](5599cfe)) * Add notebook resource ([#4195](#4195)) ([407dfa2](407dfa2)) * Add support for semantic views in grant ownership ([#4210](#4210)) ([5d2b961](5d2b961)) * Add task seconds and hours scheduling ([#4207](#4207)) ([ec623ed](ec623ed)) * Enable semantic views ([#4221](#4221)) ([2398a93](2398a93)) ### 🔧 **Misc** * Add protected security integrations in sweepers ([#4193](#4193)) ([94260ce](94260ce)) * Add small provider adjustments ([#4208](#4208)) ([34b1d6d](34b1d6d)) * Adjust data source tests follow up 1 ([#4163](#4163)) ([8e1d20a](8e1d20a)) * Adjust data source tests follow up 2 ([#4165](#4165)) ([23725df](23725df)) * Adjust data source tests follow up 3 ([#4166](#4166)) ([20ee0eb](20ee0eb)) * Adjust migration guide after grant ownership pr ([#4190](#4190)) ([c061a4e](c061a4e)) * Adjust task documentation ([#4226](#4226)) ([85ddbb9](85ddbb9)) * Adjust task tests ([#4216](#4216)) ([1e80581](1e80581)) * Adjust to 2025_07 BCR part 1 ([#4171](#4171)) ([df00c22](df00c22)) * Adjust to 2025_07 BCR part 2 ([#4174](#4174)) ([ec84372](ec84372)) * Bump the driver version to 1.18.0 ([#4220](#4220)) ([7f22a80](7f22a80)) * Change migration guide ([#4229](#4229)) ([8507769](8507769)) * Fix data source tests ([#4203](#4203)) ([c59e35d](c59e35d)) * Fix failing tests in ci ([#4194](#4194)) ([945aa69](945aa69)) * Fix references to objects used in the SDK generator templates ([#4200](#4200)) ([2b13800](2b13800)) * Regenerate SDK without package problems ([#4183](#4183)) ([ae7cb43](ae7cb43)) * Remove database roles from bulk ownership grants ([#4185](#4185)) ([8229934](8229934)) * Remove legacy columns from managed accounts SDK ([#4175](#4175)) ([3832a34](3832a34)) * Upgrade golangci-lint to v2.6.1 ([#4182](#4182)) ([ce1f354](ce1f354)) ### 🐛 **Bug fixes:** * Do not panic in parsing identifiers with arguments ([#4191](#4191)) ([f8a97f0](f8a97f0)) --- This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please). Co-authored-by: terraform-provider-release[bot] <205196624+terraform-provider-release[bot]@users.noreply.github.com>

- Add `snowflake_semantic_view` resource and `snowflake_semantiv_views` data source - Fix/improve the implementation - Handle renaming through `ALTER` - Handle objects in a case-sensitive way - Fix metrics with window functions - Add more integration tests and improve the acceptance ones - Remove describe output from resource and data source - Adjust the SDK - Mark `table_alias` as required - Move SDK gen definition to the new dir - Generate the docs - Document al the limitations - Update the migration guide

🤖 I have created a release *beep* *boop* --- ## [2.11.0](snowflakedb/terraform-provider-snowflake@v2.10.1...v2.11.0) (2025-11-21) ### 🎉 **What's new:** * Add notebook datasource ([snowflakedb#4209](snowflakedb#4209)) ([5599cfe](snowflakedb@5599cfe)) * Add notebook resource ([snowflakedb#4195](snowflakedb#4195)) ([407dfa2](snowflakedb@407dfa2)) * Add support for semantic views in grant ownership ([snowflakedb#4210](snowflakedb#4210)) ([5d2b961](snowflakedb@5d2b961)) * Add task seconds and hours scheduling ([snowflakedb#4207](snowflakedb#4207)) ([ec623ed](snowflakedb@ec623ed)) * Enable semantic views ([snowflakedb#4221](snowflakedb#4221)) ([2398a93](snowflakedb@2398a93)) ### 🔧 **Misc** * Add protected security integrations in sweepers ([snowflakedb#4193](snowflakedb#4193)) ([94260ce](snowflakedb@94260ce)) * Add small provider adjustments ([snowflakedb#4208](snowflakedb#4208)) ([34b1d6d](snowflakedb@34b1d6d)) * Adjust data source tests follow up 1 ([snowflakedb#4163](snowflakedb#4163)) ([8e1d20a](snowflakedb@8e1d20a)) * Adjust data source tests follow up 2 ([snowflakedb#4165](snowflakedb#4165)) ([23725df](snowflakedb@23725df)) * Adjust data source tests follow up 3 ([snowflakedb#4166](snowflakedb#4166)) ([20ee0eb](snowflakedb@20ee0eb)) * Adjust migration guide after grant ownership pr ([snowflakedb#4190](snowflakedb#4190)) ([c061a4e](snowflakedb@c061a4e)) * Adjust task documentation ([snowflakedb#4226](snowflakedb#4226)) ([85ddbb9](snowflakedb@85ddbb9)) * Adjust task tests ([snowflakedb#4216](snowflakedb#4216)) ([1e80581](snowflakedb@1e80581)) * Adjust to 2025_07 BCR part 1 ([snowflakedb#4171](snowflakedb#4171)) ([df00c22](snowflakedb@df00c22)) * Adjust to 2025_07 BCR part 2 ([snowflakedb#4174](snowflakedb#4174)) ([ec84372](snowflakedb@ec84372)) * Bump the driver version to 1.18.0 ([snowflakedb#4220](snowflakedb#4220)) ([7f22a80](snowflakedb@7f22a80)) * Change migration guide ([snowflakedb#4229](snowflakedb#4229)) ([8507769](snowflakedb@8507769)) * Fix data source tests ([snowflakedb#4203](snowflakedb#4203)) ([c59e35d](snowflakedb@c59e35d)) * Fix failing tests in ci ([snowflakedb#4194](snowflakedb#4194)) ([945aa69](snowflakedb@945aa69)) * Fix references to objects used in the SDK generator templates ([snowflakedb#4200](snowflakedb#4200)) ([2b13800](snowflakedb@2b13800)) * Regenerate SDK without package problems ([snowflakedb#4183](snowflakedb#4183)) ([ae7cb43](snowflakedb@ae7cb43)) * Remove database roles from bulk ownership grants ([snowflakedb#4185](snowflakedb#4185)) ([8229934](snowflakedb@8229934)) * Remove legacy columns from managed accounts SDK ([snowflakedb#4175](snowflakedb#4175)) ([3832a34](snowflakedb@3832a34)) * Upgrade golangci-lint to v2.6.1 ([snowflakedb#4182](snowflakedb#4182)) ([ce1f354](snowflakedb@ce1f354)) ### 🐛 **Bug fixes:** * Do not panic in parsing identifiers with arguments ([snowflakedb#4191](snowflakedb#4191)) ([f8a97f0](snowflakedb@f8a97f0)) --- This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please). Co-authored-by: terraform-provider-release[bot] <205196624+terraform-provider-release[bot]@users.noreply.github.com>

- Add `snowflake_semantic_view` resource and `snowflake_semantiv_views` data source - Fix/improve the implementation - Handle renaming through `ALTER` - Handle objects in a case-sensitive way - Fix metrics with window functions - Add more integration tests and improve the acceptance ones - Remove describe output from resource and data source - Adjust the SDK - Mark `table_alias` as required - Move SDK gen definition to the new dir - Generate the docs - Document al the limitations - Update the migration guide

🤖 I have created a release *beep* *boop* --- ## [2.11.0](snowflakedb/terraform-provider-snowflake@v2.10.1...v2.11.0) (2025-11-21) ### 🎉 **What's new:** * Add notebook datasource ([snowflakedb#4209](snowflakedb#4209)) ([5599cfe](snowflakedb@5599cfe)) * Add notebook resource ([snowflakedb#4195](snowflakedb#4195)) ([407dfa2](snowflakedb@407dfa2)) * Add support for semantic views in grant ownership ([snowflakedb#4210](snowflakedb#4210)) ([5d2b961](snowflakedb@5d2b961)) * Add task seconds and hours scheduling ([snowflakedb#4207](snowflakedb#4207)) ([ec623ed](snowflakedb@ec623ed)) * Enable semantic views ([snowflakedb#4221](snowflakedb#4221)) ([2398a93](snowflakedb@2398a93)) ### 🔧 **Misc** * Add protected security integrations in sweepers ([snowflakedb#4193](snowflakedb#4193)) ([94260ce](snowflakedb@94260ce)) * Add small provider adjustments ([snowflakedb#4208](snowflakedb#4208)) ([34b1d6d](snowflakedb@34b1d6d)) * Adjust data source tests follow up 1 ([snowflakedb#4163](snowflakedb#4163)) ([8e1d20a](snowflakedb@8e1d20a)) * Adjust data source tests follow up 2 ([snowflakedb#4165](snowflakedb#4165)) ([23725df](snowflakedb@23725df)) * Adjust data source tests follow up 3 ([snowflakedb#4166](snowflakedb#4166)) ([20ee0eb](snowflakedb@20ee0eb)) * Adjust migration guide after grant ownership pr ([snowflakedb#4190](snowflakedb#4190)) ([c061a4e](snowflakedb@c061a4e)) * Adjust task documentation ([snowflakedb#4226](snowflakedb#4226)) ([85ddbb9](snowflakedb@85ddbb9)) * Adjust task tests ([snowflakedb#4216](snowflakedb#4216)) ([1e80581](snowflakedb@1e80581)) * Adjust to 2025_07 BCR part 1 ([snowflakedb#4171](snowflakedb#4171)) ([df00c22](snowflakedb@df00c22)) * Adjust to 2025_07 BCR part 2 ([snowflakedb#4174](snowflakedb#4174)) ([ec84372](snowflakedb@ec84372)) * Bump the driver version to 1.18.0 ([snowflakedb#4220](snowflakedb#4220)) ([7f22a80](snowflakedb@7f22a80)) * Change migration guide ([snowflakedb#4229](snowflakedb#4229)) ([8507769](snowflakedb@8507769)) * Fix data source tests ([snowflakedb#4203](snowflakedb#4203)) ([c59e35d](snowflakedb@c59e35d)) * Fix failing tests in ci ([snowflakedb#4194](snowflakedb#4194)) ([945aa69](snowflakedb@945aa69)) * Fix references to objects used in the SDK generator templates ([snowflakedb#4200](snowflakedb#4200)) ([2b13800](snowflakedb@2b13800)) * Regenerate SDK without package problems ([snowflakedb#4183](snowflakedb#4183)) ([ae7cb43](snowflakedb@ae7cb43)) * Remove database roles from bulk ownership grants ([snowflakedb#4185](snowflakedb#4185)) ([8229934](snowflakedb@8229934)) * Remove legacy columns from managed accounts SDK ([snowflakedb#4175](snowflakedb#4175)) ([3832a34](snowflakedb@3832a34)) * Upgrade golangci-lint to v2.6.1 ([snowflakedb#4182](snowflakedb#4182)) ([ce1f354](snowflakedb@ce1f354)) ### 🐛 **Bug fixes:** * Do not panic in parsing identifiers with arguments ([snowflakedb#4191](snowflakedb#4191)) ([f8a97f0](snowflakedb@f8a97f0)) --- This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please). Co-authored-by: terraform-provider-release[bot] <205196624+terraform-provider-release[bot]@users.noreply.github.com>

sfc-gh-asawicki added 30 commits November 19, 2025 12:03

Rename semantic view resource file

e3bda37

Add missing wrappers to semantic views data source

8532d42

Unskip semantic views tests

435b051

Remove describe output from semantic views resource and data source

da9a136

Move semantic views definition

297d5ab

Regenerate semantic views SDK

1d869df

Use double quotes for all the objects

78d1ec6

Pass existing integration tests with lowercase names

1c0d004

Pass existing integration tests with column lowercase names

dcd0917

Add TODOs list

289cc12

Add tests (WIP)

b0c2961

Regenerate semantic views

5a0ff82

Regenerate semantic views unit tests

5d77a05

Pass an integration rename test

46e956a

Pass unit tests

62e0198

Handle rename

916a66d

Finish rename test

b51a198

Add semantic view template

ef19492

Generate docs for semantic view resource

68a337d

Update the resource template

413ff8a

Regenerate the docs for semantic view resource

5897668

Add casing clarifications

9d5231f

Fix small formatting in resource docs

b0bd904

Add semantic views template

ebeca4e

Generate data source docs for semantic views

6aa84ee

Add rename test and failing test without table alias

a28b1f4

Add test for creation without queryable

b428a9e

Pass integration and acceptance tests with window function

7e6e600

Update semantic views definition

dd30c3f

Fix window function metric

2db3d00

sfc-gh-asawicki marked this pull request as ready for review November 21, 2025 08:43

sfc-gh-asawicki requested a review from a team as a code owner November 21, 2025 08:43

sfc-gh-jcieslak previously approved these changes Nov 21, 2025

View reviewed changes

docs/data-sources/semantic_views.md Outdated Show resolved Hide resolved

pkg/resources/semantic_views.go Show resolved Hide resolved

pkg/resources/semantic_view.go Show resolved Hide resolved

pkg/resources/semantic_view.go Show resolved Hide resolved

sfc-gh-jmichalak reviewed Nov 21, 2025

View reviewed changes

pkg/testacc/data_source_semantic_views_acceptance_test.go Show resolved Hide resolved

sfc-gh-asawicki added 4 commits November 21, 2025 11:07

Merge branch 'dev' into enable-semantic-views

f4cb054

Adjust the grant ownership for semantic views test

7e86251

Adjust data source example

b4b00e3

Add renames with database

f376edb

sfc-gh-asawicki dismissed sfc-gh-jcieslak’s stale review via f376edb November 21, 2025 10:42

sfc-gh-asawicki had a problem deploying to test November 21, 2025 10:42 — with GitHub Actions Error

sfc-gh-asawicki temporarily deployed to test November 21, 2025 10:45 — with GitHub Actions Inactive

Merge branch 'dev' into enable-semantic-views

3b425db

sfc-gh-asawicki had a problem deploying to test November 21, 2025 10:48 — with GitHub Actions Error

sfc-gh-asawicki requested review from sfc-gh-jcieslak and sfc-gh-jmichalak November 21, 2025 10:48

sfc-gh-jcieslak approved these changes Nov 21, 2025

View reviewed changes

sfc-gh-jmichalak approved these changes Nov 21, 2025

View reviewed changes

sfc-gh-asawicki merged commit 2398a93 into dev Nov 21, 2025
10 of 11 checks passed

sfc-gh-asawicki deleted the enable-semantic-views branch November 21, 2025 10:57

terraform-provider-release bot mentioned this pull request Nov 21, 2025

chore(main): release 2.11.0 #4199

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

feat: Enable semantic views #4221

feat: Enable semantic views #4221

Uh oh!

sfc-gh-asawicki commented Nov 20, 2025 •

edited

Loading

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

sfc-gh-jmichalak left a comment

Uh oh!

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

4 participants

feat: Enable semantic views #4221

feat: Enable semantic views #4221

Uh oh!

Conversation

sfc-gh-asawicki commented Nov 20, 2025 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

sfc-gh-jmichalak left a comment

Choose a reason for hiding this comment

Uh oh!

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

Uh oh!

github-actions bot commented Nov 21, 2025

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

4 participants

sfc-gh-asawicki commented Nov 20, 2025 •

edited

Loading