Get started

Quickstart

Go from signing in to reading your first table, end to end.

Sign in, find a real table in the Data Catalog, and read rows from it — first in the catalog, then from a notebook or SQL. New to warehouses, namespaces and Iceberg tables? Start with core concepts.

What you need

A Databaas login and a grant on at least one table — if the catalog says No rights yet, ask an administrator (data permissions). The last step branches: can_use_notebooks for the notebook route, or can_use_dashboards for the SQL route.

Sign in

Go to https://<your-databaas-domain>. Sign in. Overwhelmed? Check out the portal tour.

A feature you need is missing?

The portal shows only features you can open. If one you need isn’t listed, you don’t have its permission yet — ask an administrator. See how access works.

Find a table

In Data Catalog, the left pane lists the warehouses you can read. Expand into namespaces and tables, or filter with the Search field. Select a table; the breadcrumb shows its identity — warehouse, namespace, table name — which the routes below need.

Look before you query

The detail pane opens on Preview: about the first 20 rows from the current snapshot — a sample, not a query result. Schema, Properties and Permissions tabs sit beside it. If the preview looks right, you have your table.

Read it

Read from a notebook (Python) or SQL Lab (SQL); both return the same rows.

In a notebook

Requires can_use_notebooks. Open Notebooks (first launch takes about a minute) and create a Python notebook. The databaas_auth helper fetches a token for you, so the catalog is scoped to your grants:

Load a table with pyiceberg
from databaas_auth import load_user_catalog

catalog = load_user_catalog()
table = catalog.load_table("<namespace>.<table>")
print(table.scan(limit=10).to_arrow().to_pandas())

Use the breadcrumb values; for a table outside the default warehouse, pass load_user_catalog(warehouse="<warehouse>"). A permission error means that table isn’t one of your grants; a token error means your sign-in aged out — sign out of Notebooks and back in. To narrow a scan and query it with DuckDB, see querying data.

In SQL Lab

Requires can_use_dashboards. Open Dashboards, then SQL Lab. Choose the database that points at the lakehouse and pick your namespace from the schema list (namespaces appear as schemas):

First rows, in SQL
SELECT * FROM <namespace>.<table> LIMIT 10

The query runs as you, so a table you could not preview will not return rows here either.

Dashboards are a door, not a filter: everyone who can open Superset sees the same charts and datasets, but a query returns only rows you are granted — a chart on data you have no grant for errors. See how access works.