Improved SQL worksheets

• Better table name completions for SQL worksheets
• Snowflake selection of several databases & schemas
• Fix Postgres timeout issue
• Special sign up with username for HN launch

Table completion + Google SSO

• Sign in / up with Google SSO
• Profiling handles json / array values

Bug fixes

Faster indexing

• Faster indexing of codebase + warehouse

Minor bug fixing

Set up of Pro trial

• Setup of trial version for self-service
• Rate limit for trial users

Faster nao tab

• faster nao tab
• nao tab works without data connexion

Sign up & extensions

• Autonomous sign up
• Compatibility with open-vsx extensions
• Fixes on code indexing process

nao tab available for all users

• Make nao tab available by default

Persistent data connexion

• Persist data connexion in all repositories
• New onboarding flow #2

New onboarding flow

• New onboarding flow

Fix query error in chat

• Fix in chat: send a query error directly in the chat to help solve

nao AI on data connexion only mode

• SQL worksheets
• data connexion only workmode - no code repo needed
• Data preview up to 100 rows

Agent can launch dbt commands

• Accept/reject all from data preview
• New function in the agent: launch a dbt command (run, build, test)

Increased data security in agent

• Increased data security: agent now asks for permission to read results of executed queries

Green-red in data preview

• Add differences in green-red in the data preview
• New agent tool: data profiling of a table (count rows, null values, value distribution)

Python 3.9 compatibility

• Fixed compatibility with python 3.9 envs

Second version of nao tab

• Second & better version of nao tab
• New in Preview : tab "columns" in a table preview to brows the columns of a table & their types

First version of nao tab

• First version of nao tab to suggest auto-completion of the code while writing
• Improve preview : every value becomes clickable so as to see the full value when it's too long

Auto-complete & agent can execute a SQL query

• New version of auto-complete: get suggestion of available columns after a SELECT in a query
• Jump to reference of models, CTEs & columns with cmd + click
• New tool in the agent: execute a SQL query on the datawarehouse

Data-specific workflows added to agent

• Agent is trained on 2 specific workflows: create staging models from datawarehouse tables / refactor a column through lineage & check dependencies
• New tool for agent: get schema of a table in the datawarehouse, find a specific dbt model, list files in a directory

Agent has codebase & warehouse in implicit context

• Agent has direct access to the indexed codebase & warehouse and don't need the @codebase & @warehouse mentions anymore

Agent shows only changes with current codebase

• Agent shows only changes in chat - instead of whole file changed
• SQL generated is automatically collapsed

.naorules, scroll up while agent writes, stop agent generation

• Agent reads file .naorules so that user pre-prompts agent with custom rules
• Scroll up while agent is writing
• Button to stop agent when writing

Auto-indexing of codebase

• Auto-indexing of codebase - to select by user
• Faster indexing of codebase & warehouse

First version of nao agent

• Create first version of nao agent: an intelligent chat with tools to search your codebase & warehouse, and suggest changes
• Apply button to directly apply agent suggestions to your code

Improve dbt project loading

• Detect automatically dbt_project and profiles, but you can also specify it manually
• Fix a bug on apply and a visual spinner that shows it's waiting
• Fix lineage input seleciton

Lineage fixes and apply mode

A lot of bug fixes

• How dbt is parsed (dbt_project, profiles)
• fix @warehouse
• In Snowflake you can enter the database and the schema now
• use .nao.env to manage env variables
• Fix an issue with Snowflake schema and tables starting with a number
• Re connect BigQuery if the refresh token is expired as per the org policy

Snowflake SSO

• SSO Snowflake (via Okta or native Snowflake)
• Add role support in Snowflake connection
• Fixed a bug with Postgres connection

BigQuery OAuth connection

• Connect to BigQuery using the OAuth SSO
• Support JSONB as type in the result panel

Fix the codicons

• Fixes the icons

Bugfixes

• Small bugfixes on Postgres conn SHH tunnel

New connection panel, treeview

• We improved the connection management panel, you can now only manage a connection
• Postgres connection now supports the SSH tunnel
• Jump to column definition in SQL queries

Better linter and apply code

• You can now apply code from the chat
• There is a better linter, that can understand your whole project

Tables

• Fix bugs with Postgres and Snowflake connections
• Query results and table preview are great

Postgres support

• Add Postgres support
• New features in Lineage (reset button, node focus)

To launch nao on mac you need to run (after the install)
`xattr -c /Applications/nao.app`

Lineage, Snowflake and bug fixes

• New lineage version, you can see the whole lineage, or when you select a specific file you the lineage centers on the model and you see a level before and after, there is also a + to expand the lineage in the wanted direction.
• Snowflake now supports preview of table from the tree (we you click on a table name) and from dbt models (run or Ctrl+E, Cmd+E)
• Prompt context also include Snowflake tables
• Prompt context defaults to the current file opened
• Indexing now excludes all the files in the .gitignore and there is a .naoignore that you can use to exclude other files/folders from the indexing
• nao helps you install SQLFluff if it's not installed by default
• Bug fixes:
- By default a chat model is selected
- CSS in the settings menu has been fixed (especially the settings page), the nao theme also changes the menu now

nao the first

- Works with Windows and MacOS
- There is lineage, chat, dbt support, query preview, query cost and error linting
- Databases supported are BigQuery and Snowflake