Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. Connect it to Paradime to develop dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent run dbt™ models and queries during background sessions.

IP restrictionsMake sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.See also: Paradime IP addresses.

Available in: Code IDE, Bolt, and Agent environments.

Add a connection

Click Settings in the top menu bar of the Paradime interface to access Workspace Settings.
In the left sidebar, click Environments.
Click Add New next to the section for the environment you are configuring:
- Code IDE for the Code IDE connection
- Bolt for the Bolt connection
- Agent for the Agent connection
Select Microsoft SQL Server.
In the Profile Configuration field, add at least the required parameters. For additional options, see the Profile fields reference.
Provide a dbt™ Profile Name (this should match the profile name set in your dbt_project.yml).
In the Target field, enter the target for the environment you are configuring: dev for Code IDE, prod for Bolt, or dinoai for the Agent.
The Schema field is pre-configured, but you can change it to specify the schema where dbt™ builds objects.
The Threads value is pre-configured to 1, but you can adjust this to specify how many parallel operations your dbt™ project can run.

Profile configuration

Add at least these required parameters:

driver: 'ODBC Driver 18 for SQL Server'     # ODBC Driver 18 for SQL Server
server: sql.company.com                     # Hostname or IP address
port: 1433                                  # Default: 1433
database: analytics_db                      # Name of the database
user: sql_user                              # SQL Server username
password: your_password                     # SQL Server password

After adding the configuration, ensure it is properly formatted using a YAML formatter like YAML Formatter.

Profile fields reference

Field	Description	Example	Default Value	Required
driver	ODBC driver	`ODBC Driver 18 for SQL Server`	`ODBC Driver 18 for SQL Server`	✅
server	Server hostname or IP	`sql.company.com`	None	✅
port	Server port number	`1433`	`1433`	✅
database	Database name	`analytics_db`	None	✅
schema	Schema name. This is configured in the UI “Schema” field	`dbo`	None	✅
user	Authentication username	`sql_user`	None	✅
password	Authentication password	`your_password`	None	✅
retries	Number of query retry attempts	`3`	`1`	❌
encrypt	Enable connection encryption	`true`	`true`	❌
trust_cert	Trust server certificate	`false`	`false`	❌
login_timeout	Connection timeout in seconds	`10`	`0`	❌
query_timeout	Query timeout in seconds	`300`	`0`	❌
schema_authorization	Schema owner principal	`db_owner`	None	❌

Optional connection attributes

Set additional profiles.yml attributes for this connection.

​Add a connection

​Profile configuration

​Profile fields reference

​Related

Optional connection attributes

Add a connection

Profile configuration

Profile fields reference

Related