Bruin AI Step 3 of 6
Build an AI Data Analyst
1. Discover available schemas (optional)
If you already know the name of the schema (or dataset) you want to import, skip ahead to step 2. Otherwise, you can list the available schemas in your database:
BigQuery:
bruin query --connection gcp-default --query "SELECT schema_name FROM INFORMATION_SCHEMA.SCHEMATA"
Postgres / Redshift:
bruin query --connection postgres-default --query "SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('pg_catalog', 'information_schema')"
ClickHouse:
bruin query --connection clickhouse-default --query "SHOW DATABASES"
Pick the schema that contains the tables you want to analyze (e.g., stock_market, ecomm, public).