@bonnard/cli
Advanced tools
@@ -13,3 +13,3 @@ # Bonnard Documentation | ||
| - [cubes.refresh-key](cubes.refresh-key) - Cache invalidation strategies | ||
| - [cubes.data-source](cubes.data-source) - Connect cubes to warehouses | ||
| - [cubes.data-source](cubes.data-source) - Connect cubes to warehouses (SSL, multi-database) | ||
@@ -16,0 +16,0 @@ ### Measures |
@@ -84,2 +84,53 @@ # Data Source | ||
| ## SSL Configuration | ||
| Cloud-hosted databases (Neon, Supabase, Amazon RDS, Google Cloud SQL, Azure) typically require SSL connections. Bonnard supports SSL for Postgres and Redshift data sources via the `sslmode` config field. | ||
| ### Supported Modes | ||
| | Mode | Description | | ||
| |------|-------------| | ||
| | `require` | Encrypt the connection (default for `bon datasource add`) | | ||
| | `disable` | No encryption | | ||
| ### Setting SSL via CLI | ||
| ```bash | ||
| # Interactive — defaults to "require", press Enter to accept | ||
| bon datasource add | ||
| # Non-interactive | ||
| bon datasource add --name my_db --type postgres \ | ||
| --host ep-cool-rain-123456.us-east-2.aws.neon.tech \ | ||
| --database mydb --user myuser --password-env DB_PASSWORD \ | ||
| --ssl require | ||
| # Disable SSL (e.g. localhost) | ||
| bon datasource add --name local_dev --type postgres \ | ||
| --host localhost --database devdb --user dev --password dev \ | ||
| --ssl disable | ||
| ``` | ||
| ### Setting SSL in datasources.yaml | ||
| ```yaml | ||
| # .bon/datasources.yaml | ||
| datasources: | ||
| - name: production | ||
| type: postgres | ||
| config: | ||
| host: ep-cool-rain-123456.us-east-2.aws.neon.tech | ||
| port: "5432" | ||
| database: mydb | ||
| schema: public | ||
| sslmode: require | ||
| credentials: | ||
| username: myuser | ||
| password: "{{ env_var('DB_PASSWORD') }}" | ||
| ``` | ||
| ### dbt Import | ||
| When importing from dbt profiles via `bon datasource add --from-dbt`, the `sslmode` field is automatically carried over from your dbt configuration. | ||
| ## Cross-Database Joins | ||
@@ -86,0 +137,0 @@ |
+1
-1
| { | ||
| "name": "@bonnard/cli", | ||
| "version": "0.3.9", | ||
| "version": "0.3.10", | ||
| "type": "module", | ||
@@ -5,0 +5,0 @@ "bin": { |
+3
-0
@@ -33,2 +33,5 @@ <p align="center"> | ||
| <p align="center"> | ||
| <img src="./assets/architecture.png" alt="Bonnard architecture -data sources flow through the semantic layer to AI agents, BI tools, and MCP clients" width="100%" /> | ||
| </p> | ||
| ## Why Bonnard? | ||
@@ -35,0 +38,0 @@ |
Sorry, the diff of this file is too big to display
URL strings
Supply chain riskPackage contains fragments of external URLs or IP addresses, which the package may be accessing at runtime.
Found 1 instance in 1 package
URL strings
Supply chain riskPackage contains fragments of external URLs or IP addresses, which the package may be accessing at runtime.
Found 1 instance in 1 package
2375055
0.08%5423
0.24%135
2.27%