G’day dbt community,
I am new to dbt and trying to utilise dbt with VSCode but I’m running into an error.
Setup
I have added the Power User for dbt extension and dbt core for redshift.
I am setting up the profiles.yml file locally as per documentation. Please find example profiles.yml below.
AWS credentials are setup.
These work fine with the AWS toolkit.
Note: These credentials have a aws_session_token as MFA is required to access redshift in our aws account. The session in the credentials is valid.
When I run “dbt debug” I get a timeout error on the database.
01:23:34 Registered adapter: redshift=1.8.1
01:24:19 Connection test: [ERROR]
01:24:19 1 check failed:
01:24:19 dbt was unable to connect to the specified database.
The database returned the following error:
Database Error
(‘connection time out’, TimeoutError(10060, ‘A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond’, None, 10060, None))
Profile.yml example:
default:
target: dev
outputs:
dev:
type: redshift
method: iam
cluster_id: our cluster id
host: our host
user: my redshift user
iam_profile: AWS profile with aws_access_key_id, aws_secret_access_key, aws_session_token
region: our region
dbname: our database name
schema: my dbt schema
port: 5439
Please can you advise of what I need to change in my config to establish the connection?