Skip to main content
Connect your data sources (BigQuery, Snowflake, PostgreSQL) to Credible to start building semantic models. Connections provide secure access to your databases and data warehouses. Connections are added to a project and become available to all packages within that project.

​
Setup Process

  1. Access your organization at https://your-org.admin.credibledata.com
  2. Select your project from the project list
  3. Click “Add Connection” in the Connections section
  4. Choose your data source type and fill in the connection details:
Connection names cannot contain spaces or hyphens. Use underscores instead (e.g., my_connection).
  • BigQuery
  • PostgreSQL
  • Snowflake
BigQuery ConnectionRequired:
  • Connection name
  • Service Account Key (JSON file) - upload or paste the JSON key file from GCP
Optional Configuration: All of these can be specified in the service account key or overridden here:
  • Default Project ID
  • Billing Project ID
  • Location (e.g., US, EU, asia-northeast1)
  • Maximum Bytes Billed
  • Query Timeout (milliseconds)
  1. Test the connection to verify connectivity
  2. Create the connection for use in your models
Once created, you can use the View Schema button to explore your connection’s tables and schemas: Connection Explorer

​
CLI Option

Use the Credible command-line tool for programmatic connection management and automation.
  1. Install the CLI: 
    npm install -g cred
  2. Login to your organization: 
    cred login <organizationName>
  3. 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.

​
BigQuery Setup

BigQuery requires a service account with a JSON key file. See Setting Up BigQuery for instructions on creating a service account. PostgreSQL and Snowflake connections work with standard database credentials - no special setup required.

​
Embed Data (Optional)

You can also include CSV or Parquet files directly in your packages alongside database connections. Add files to a data/ folder and reference them in your models using duckdb.table('data/filename.csv'). This is useful for reference data, lookup tables, or small datasets.

​
Next Steps

After connecting your data, you’ll move to building your model in VS Code:

Build a Model

Continue to the modeling workflow in VS Code to create your semantic models
⌘I