INFORMATION_SCHEMA.COLUMNS

The INFORMATION_SCHEMA.COLUMNS view contains metadata for all the columns within the tables and views in a project.

Syntax

SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS

note:

The list of columns for tables is determined by the metadata caching policy on individual sources. The columns are not refreshed if the data is expired.

{{% snippet "information-schema-columns-snippet.md" %}}