Microsoft SQL Server
Microsoft SQL Server is a relational database management system developed by Microsoft. As a scheduler environment in Paradime, SQL Server enables deploying dbt™ in production with Bolt.
IP RESTRICTIONS
Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.
👉 See also: Paradime IP addresses.
Setup Instructions
Click the gear Icon (⚙️) on the top right of the Paradime interface to access Account Settings
In the left sidebar, click "Connections"
Click "Add New" next to the Scheduler section
Select "SQL Server"
In the Profile Configuration field, add at least these required parameters. For additional configuration options, see the Profile Fields Reference section.
After adding the configuration, ensure it's properly formatted using a YAML formatter like YAML Formatter.
Provide a dbt™ Profile Name (This should match with the profile name set in your
dbt_project.yml
).In the Target field, enter "
prod
". This is the default target your dbt™ project will use for your Bolt Schedules.The "Schema" field is pre-configured, but you can change it to specify the schema where dbt will build objects.
The "Threads" value is pre-configured to 1, but you can adjust this number to specify how many parallel operations your dbt project can run.
Example Profile Configuration
Profile Fields Reference
driver
OBDC 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
❌
Last updated