I’ve been working through the setup for the dbt Fundamentals course, and though I’ve followed the steps 1 through 6 in the Quickstart as is required, when I attempt to query the database using dbt it fails to connect (e.g. as is shown in the “Set Up dbt Cloud / Getting Started”).
I’ve attempted to add rules to the AWS ACLs (i.e., that of the “dbtWorkshop”'s VPC’s “Main Network ACL”, to include the IPs that are listed at Access, Regions, & IP addresses | dbt Developer Hub , but it’s been to no avail; the connection times out every time I attempt to query via dbt (e.g. as is done in 2:02 in the video).
The result is:
Encountered an error: Runtime Error Database Error in sql_operation inline_query (from remote system.sql) ('connection time out', TimeoutError(110, 'Connection timed out'))
What do I need to do here?