What are database and warehouse connectors?
Definition
A connector stores the connection details for a database such as PostgreSQL or MySQL, or a cloud warehouse such as BigQuery, Snowflake or Redshift. Queries run on that database, and results come back to the tool.
A live connection queries the source database when a query runs. Cached results and dashboard snapshots may show an earlier result, so a live connection does not mean every chart updates continuously.
Why it matters
A connector determines whether an analytics tool can reach the data you already have and how queries reach it. For a live connection, analytical work can share resources with other activity on the database. The choice of account, permitted tables and query limits therefore affects both access and operational load.
Check the details against a representative source rather than relying on a database logo. Confirm the supported engine, authentication method and network requirements, then try the types of fields and calculations your team uses. Read-only credentials and a clear set of accessible tables reduce unnecessary access. Also understand when a displayed result is newly queried and when it is a previously captured result.