PARA-1000: Missing production warehouse connection
This error appears when you run a production dbt job in Bolt without an active production warehouse connection. It also appears when your production run references a target that does not exist.Solution
- Add an active production connection for the scheduler.
- Confirm the connection works before rerunning.
- If you use a custom target, confirm that target exists.
PARA-1007: Couldn’t fetch info-schema from Snowflake for production catalog
Paradime could not fetch the information schema for your production catalog. Common causes include:- The production user does not exist.
- The stored credentials are invalid.
- The Snowflake account no longer exists or has expired.
SolutionCheck the production connection details.Test the connection again.If the test fails, confirm the credentials with your Snowflake admin.See Snowflake.
PARA-1007: Couldn’t fetch info-schema from Snowflake for dev catalog
Paradime could not fetch the information schema for your development catalog. Common causes include:- The development user does not exist.
- The stored credentials are invalid.
- The Snowflake account no longer exists or has expired.
SolutionCheck the development connection details.Test the connection again.If the test fails, confirm the credentials with your Snowflake admin.See Snowflake.
250001 (08001): Multi-factor authentication is required for this account
SolutionSwitch the connection to key-pair authentication. Snowflake doesn’t ask for MFA when you sign in with a key pair.
- Generate a key pair for the Snowflake user on the connection. Follow Snowflake’s guide to generating an encrypted or unencrypted key pair.
-
Set the public key on that user:
-
Open Workspace Settings > Environments and edit the connection. Set Auth Method to Key Pair, then enter the username, the private key (including the
BEGINandENDlines), and the passphrase if you set one.
250001 (08001): Authentication attempt rejected by the current authentication policy
SolutionAsk your Snowflake admin which sign-in methods the policy allows (its
AUTHENTICATION_METHODS). Then do one of these:- Switch the connection to key-pair authentication, using the steps in the previous error, and confirm the policy allows
KEYPAIR. - Have your admin allow the sign-in method the connection uses, for that user.
Radar: Schema ‘SNOWFLAKE.ACCOUNT_USAGE’ does not exist or not authorized
paradime_cost_role, so Snowflake runs the Radar queries as PUBLIC, which can’t read SNOWFLAKE.ACCOUNT_USAGE.
This happens when:
- The user already existed, so
create user if not existsdidn’t set its default role. - The user’s default role is set, but the role isn’t granted to the user.
SolutionRun as a user admin:Then run
desc user paradime_cost_user; and confirm that DEFAULT_ROLE is PARADIME_COST_ROLE. Replace paradime_cost_user with your user name if you use a different user.See Snowflake cost connection.BigQuery: The job encountered an internal error during execution
jobInternalError). See BigQuery’s error messages.
Solution
- Run the schedule again. BigQuery’s guidance for this error is to retry the job.
- If the same models fail in every run, open one of the failed jobs in the BigQuery console and run the same SQL there. On dbt™ v2, the error links to the job.
- If the SQL also fails in the console, the problem is on the BigQuery side, not in dbt™ or Paradime. Check whether the tables the query reads changed recently, and contact Google Cloud support with the job IDs.
BigQuery: The job encountered an error during execution
jobBackendError. BigQuery accepted the model’s query job, then failed it with an internal error on its side.
SolutionRun the schedule again. If the same models fail with this error, or with the internal error in the previous entry, in every run, follow the steps in the previous entry.
PARA-1014: Couldn’t list databases when running paradime sources generate
Paradime could not list databases to generate sources.yml.
This usually means your development connection does not have enough access to query information schema.
SolutionReview the permissions on your development connection.Then check the setup guide for your warehouse in Code IDE environment.