snowflake-jdbc icon indicating copy to clipboard operation
snowflake-jdbc copied to clipboard

Published 20 hours ago • verified publisher icon snowflakedb

`TABLE_TYPE` for materialised views appearing as `VIEW` on Information Schema

Open unsuitable001 opened this issue 2 years ago • 1 comments

I'm trying to get a table's type. When I'm trying to get that via a SQL query:

  • In the UI: I get TABLE_TYPE as MATERIALIZED VIEW.
  • In JDBC Driver: I get TABLE_TYPE as VIEW

JDBC version: 3.13.16

unsuitable001 avatar Mar 21 '22 10:03 unsuitable001

Hi @unsuitable001,

Thanks for reporting this.

Would you mind letting me know how you're retrieving the table's type both in the UI and in the driver?

sfc-gh-wfateem avatar Mar 21 '22 13:03 sfc-gh-wfateem

Closing since we haven't heard back. Please post a comment if you still need help with this.

sfc-gh-wfateem avatar Oct 18 '22 22:10 sfc-gh-wfateem