AnswerLayer

Connections

Connections represent a link to your data warehouse. AnswerLayer supports Postgres, BigQuery, Snowflake, MySQL, SQL Server, ClickHouse, Athena, DuckDB, and CSV uploads.

List connections

GET /api/v1/connections/

Returns all active connections for the organization.

Test a connection

POST /api/v1/connections/{connection_id}/test_existing

Tests that an existing connection can reach the database.

Schema metadata

GET /api/v1/connections/{connection_id}/schema

Returns the database schema — tables, columns, types, and any PII annotations.

File uploads

AnswerLayer also supports direct file uploads as data sources:

TypeEndpointContent-Type
CSVPOST /api/v1/csv/uploadmultipart/form-data
DuckDBPOST /api/v1/duckdb/uploadmultipart/form-data

CSV upload example

curl -X POST https://app.answerlayer.io/api/v1/csv/upload \
  -H "X-API-Key: $ANSWERLAYER_API_KEY" \
  -F "file=@sales_data.csv" \
  -F "name=Sales Data" \
  -F "has_header=true" \
  -F "delimiter=,"