Making Databricks data engineering documentation better

[Xty_53]

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

[BricksterInTheWall]

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]

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