# diffChangeLog for Snowflake only returning tables and ignoring Views and StoredProcs

**URL:** <https://forum.liquibase.org/t/diffchangelog-for-snowflake-only-returning-tables-and-ignoring-views-and-storedprocs/5733>\
**Category:** Liquibase Development\
**Created:** [July 27, 2021, 10:27am UTC](https://forum.liquibase.org/t/diffchangelog-for-snowflake-only-returning-tables-and-ignoring-views-and-storedprocs/5733 "2021-07-27T10:27:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![muneer77](https://avatars.discourse-cdn.com/v4/letter/m/b9bd4f/32.png) [@muneer77](https://forum.liquibase.org/u/muneer77)\
**Post date:** [July 27, 2021, 10:27am UTC](https://forum.liquibase.org/t/diffchangelog-for-snowflake-only-returning-tables-and-ignoring-views-and-storedprocs/5733/1 "2021-07-27T10:27:38Z")

</div>

Hi, running a diffChangeLog command against my snowflake databases.  
Have a Dev and Test database both with same set of schemas in them.  
The Dev schemas contain changes to tables, views and Procs but when running the diffChangeLog command  
liquibase --changelogFile=DDL.snowflake.sql diffChangeLog

The output file only shows the DDL for table changes - it’s ignoring Views and Stored Procedures.  
Surely it should show all? Is this a bug?

Using Liquibase version 4.4.2 (Community).

---

<div class="post-metadata">

**Author:** ![rakhi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/rakhi/32/288_2.png) [@rakhi](https://forum.liquibase.org/u/rakhi)\
**Post date:** [July 28, 2021, 12:26pm UTC](https://forum.liquibase.org/t/diffchangelog-for-snowflake-only-returning-tables-and-ignoring-views-and-storedprocs/5733/2 "2021-07-28T12:26:59Z")

</div>

Hi @muneer77

Were you facing the same issue with earlier versions of Liquibase? Could you please check and confirm?

Thanks!  
Rakhi Agrawal

---

<div class="post-metadata">

**Author:** ![muneer77](https://avatars.discourse-cdn.com/v4/letter/m/b9bd4f/32.png) [@muneer77](https://forum.liquibase.org/u/muneer77)\
**Post date:** [July 28, 2021, 1:48pm UTC](https://forum.liquibase.org/t/diffchangelog-for-snowflake-only-returning-tables-and-ignoring-views-and-storedprocs/5733/3 "2021-07-28T13:48:50Z")

</div>

No - 4.4.2 is the only version I’ve ever downloaded and used. Deploying ChangeLogs works fine - only the diffChangeLog is an issue - as stated, it only looks at the tables and ignores Views and Procs