In Credible, database connection configurations are stored securely in the Credible control plane. Database credentials never leave the Credible service. All access—whether for model development purposes or serving semantic models—goes through the Credible platform. In turn, the Credible service provides a secure perimeter around your databases.
Let’s connect your data sources (BigQuery, Snowflake, PostgreSQL, Trino, Databricks, MySQL, DuckDB, MotherDuck) to Credible to start building semantic models. Connections provide secure access to your databases and data warehouses. Connections are added to an environment and become available to all packages within that environment.
After configuring your connection details, you’ll select which schemas and tables to index for AI-assisted modeling. The Schema Browser lets you browse and select specific tables.
Browse schemas on the left, select tables on the right
Use Select All to include all tables in a schema, or pick individual tables
Check “Do not include any tables for AI-assisted modeling” if you only need the connection for manual queries
These indexing limits apply to AI-assisted model creation:
100 tables per schema for metadata indexing
25 tables or fewer for automated join inference
You can manually write Malloy models for any size dataset. Published models are indexed separately for analysis.
Click Update Connection to save. You’ll see an indexing status page confirming the connection is being indexed:
Use the Credible command-line tool for programmatic connection management and automation.
Install the CLI:
npm install -g cred
Login to your organization:
cred login <organizationName>
Add a connection:
cred add connection <connectionFileName>
The connection file should be a JSON file containing an array of connection objects. See the CLI reference for detailed connection file formats and examples.