Connect data

Databases, warehouses, file uploads, discovery and Marketplace data.

• Connections A connection is how Halo reaches your data, read-only, with its credentials encrypted. Here's what one holds, which sources Halo supports, and who can manage them.
• Connect PostgreSQL Give Halo a read-only login and your database's address, test it, and run discovery.
• Connect Amazon Redshift Give Halo a read-only Redshift user and your endpoint, test it, and run discovery. For a provisioned cluster or a Serverless workgroup.
• Connect Dremio Give Halo a Dremio user or personal access token and your Arrow Flight address, test it, and run discovery.
• Upload CSV and Excel files Turn a CSV file or Excel workbook into tables you can query like a database. Preview before importing, then replace or append later, with recent versions kept.
• Allowlists, SSH tunnels and read-only logins For your IT team. What Halo needs to reach a database, what's available and what's planned, what Halo stores and how, and what it never does.
• Discovery Discovery reads a connection's tables and columns, finds how they relate, profiles the values, and suggests what each column means. Re-run it to see what changed.
• Marketplace data and the Marketplace Datasets Halo maintains and shares with your organization. They come with your plan or on request, you use them like your own, and they're read-only.
• Use your dbt project Load the files dbt writes, and Halo's catalog picks up your descriptions, tags, owners, keys and joins, and shows failing tests and stale sources beside the tables and datasets they affect.