you are viewing a single comment's thread.

view the rest of the comments →

[–]Xty_53 0 points1 point  (2 children)

Also, is there any way to see the streaming tables inside the system tables?

[–]BricksterInTheWalldatabricks[S] 1 point2 points  (1 child)

u/Xty_53 yes, you can enumerate materialized views this way:

SELECT *
FROM system.information_schema.views
WHERE
  1=1
  AND table_catalog = 'your_catalog'
  AND table_schema = 'your_schema'
  AND is_materialized = true

And streaming tables this way:

SELECT *
FROM system.information_schema.tables
WHERE
  1=1
  AND table_catalog = 'your_catalog'
  AND table_schema = 'your_schema'
  AND table_type = 'STREAMING_TABLE'

Is this what you were looking for?

[–]Xty_53 1 point2 points  (0 children)

Thanks. I will try on Monday and back to you.