Skip to main content
Data connection in nao is key.
It allows you to browse, view, query your data directly in the IDE.
It gives context of your data schema to nao AI featurse.
Data privacy:
When you connect a data warehouse to nao, your connection stays between your computer and the data warehouse. No data content is ever sent to nao servers or the LLM. Only metadata (like table and column names) is used to provide warehouse context to nao features.Read more about how your data is secured in our security documentation.

​
Add a data connection

To add a connection:
Go to Settings > Warehouse Connections > Add Connection
Data connection panel

  • https://mintcdn.com/naolabs/SrCHy4m-rDoUF-k2/images/get-started/datawarehouses/bigquery.webp?fit=max&auto=format&n=SrCHy4m-rDoUF-k2&q=85&s=e00fe8f4a047b119aa2fbb3174c744d9 BigQuery
  • https://mintcdn.com/naolabs/SrCHy4m-rDoUF-k2/images/get-started/datawarehouses/snowflake.png?fit=max&auto=format&n=SrCHy4m-rDoUF-k2&q=85&s=785ab7a0776f774eef24fe5bd87a35ff Snowflake
  • https://mintcdn.com/naolabs/SrCHy4m-rDoUF-k2/images/get-started/datawarehouses/postgres.png?fit=max&auto=format&n=SrCHy4m-rDoUF-k2&q=85&s=51ae18399a96e15cf49e34b45cca39a3 Postgres
  • https://mintcdn.com/naolabs/SrCHy4m-rDoUF-k2/images/get-started/datawarehouses/databricks.png?fit=max&auto=format&n=SrCHy4m-rDoUF-k2&q=85&s=5df5ab7ff02c93012ad140db13745943 Databricks
  • https://mintcdn.com/naolabs/SrCHy4m-rDoUF-k2/images/get-started/datawarehouses/Redshift.svg?fit=max&auto=format&n=SrCHy4m-rDoUF-k2&q=85&s=4bca8dad6ef0d423d86193035e6b8a06 Redshift
  • https://mintcdn.com/naolabs/0ghPiY7kvr42Nxxi/images/get-started/datawarehouses/clickhouse.svg?fit=max&auto=format&n=0ghPiY7kvr42Nxxi&q=85&s=4ac4e9ccd1205f12eb6c066797e4054a ClickHouse
  • https://mintcdn.com/naolabs/SrCHy4m-rDoUF-k2/images/get-started/datawarehouses/Athena.svg?fit=max&auto=format&n=SrCHy4m-rDoUF-k2&q=85&s=9dfe3bf8105371a77d9ffbd8363ab54a Amazon Athena
  • https://mintcdn.com/naolabs/SrCHy4m-rDoUF-k2/images/get-started/datawarehouses/duckdb.png?fit=max&auto=format&n=SrCHy4m-rDoUF-k2&q=85&s=5ccfda1cb24eda795bdb84b78d6aab41 DuckDB
  • https://mintcdn.com/naolabs/SrCHy4m-rDoUF-k2/images/get-started/datawarehouses/MotherDuck.png?fit=max&auto=format&n=SrCHy4m-rDoUF-k2&q=85&s=37e1ecc5c5cf6fae4dc7875c616d385f MotherDuck
​
connection_name
string
required
Display name for this connection inside nao.
​
project_ids
string
required
Comma-separated project IDs. Supports wildcards (e.g. project_*) and exclusions (!project-dev).
​
region
string
Optional BigQuery location. Leave blank to use the project default.
​
datasets
string
Optionally scope access to specific datasets by listing them explicitly.
​
authentication_method
string
default:"SSO via OAuth"
required
Choose between SSO via OAuth or Service Account. SSO requires your BQ project ID; service accounts use key files.
​
service_account_private_key
file
Required only when Service Account authentication is selected. Upload the JSON key for a service account with at least the BigQuery Data Viewer (Reader) role.
Connect multiple BigQuery projectsSelect multiple project-ids and datasets using the following patterns:
  • Comma separated values (project1,project2): Select specific projects by listing them explicitly (no space after the comma)
  • Wildcard prefix (project_*): Select all projects that start with “project_”
  • Exclusion (!project2): Select all projects except “project2”
Set query size limitsYou can limit the size of queries executed within nao.If you do, nao will perform a dry run of every query, and cancel query execution if it’s above the GB limit. The limit will be effective for both user queries and AI agent queries.Go to Settings → Warehouse Connections and set the query size limit field to the maximum rows you want nao to run automatically.
To check your data is connected, open the left panel then click on the data warehouse icon. Here you will see all the tables from your data connection. When you click on a table, you will be able to preview it directly within nao.
Data preview

​
Multiple data connections

You can connect multiple databases at once in nao.
You can choose to:
  • Set a connection as a global connection (available across all folders in nao)
  • Attach a connection to a specific workspace
To do this, hover over a connection and you’ll see the options: “Attach to workspace” or “Make global”
Only one connection is active at once in nao.You can choose the active connection either from the data tree on the left or from the nao settings / data connections menu with the small circles.
Data Multiple connections