Schemas

Schemas are essentially meaningful groups of tables meant to segment data and keep some order in the data warehouse.

  • Some schemas are used for internal purposes only (administration, data transformation, etc) and not accessible by users.
  • Some schemas may be available to some users only, depending on their scope.

💡 Access permissions are scoped at the level of schemas, not tables.

When referencing tables, typically inside SQL queries, make sure to specify the table schema, without which your query may fail or read from the wrong table:

SELECT
    column_1,
    column_2
FROM schema_name.table_name
WHERE condition;

💡 The default schema is pennylane; when not specified, the query planner will look for a table matching the query inside this schema, and return an error if not found.

Available Schemas