[Bug] Teradata profile throwing error with mock profile #1087
Comments
sc250072
added
bug
dosubot
bot
added
area:execution
|
Hey @sc250072, I'm here to help you with the issue you're facing. I can assist with bug fixes, answer questions, and guide you on how to contribute. Let's tackle this together! 🤖 The error "Must specify To resolve this error, ensure that your mock Teradata profile includes the from cosmos.config import ProfileConfig
from cosmos.profiles import TeradataUserPasswordProfileMapping # Assuming TeradataUserPasswordProfileMapping exists
profile_config = ProfileConfig(
profile_name="default",
target_name="dev",
profile_mapping=TeradataUserPasswordProfileMapping(
conn_id="my_teradata_conn_id",
profile_args={"schema": "my_schema"},
),
)
dag = DbtDag(profile_config=profile_config, ...)Additionally, ensure that your test cases include the def test_validate_arguments_schema_in_task_args():
profile_config = ProfileConfig(
profile_name="test",
target_name="test",
profile_mapping=TeradataUserPasswordProfileMapping(conn_id="test", profile_args={}),
)
task_args = {"schema": "abcd"}
validate_arguments(
select=[], exclude=[], profile_config=profile_config, task_args=task_args, execution_mode=ExecutionMode.LOCAL
)
assert profile_config.profile_mapping.profile_args["schema"] == "abcd"Make sure your profile configuration includes the |
…ofile", target "dev" invalid: Runtime Error Must specify `schema` in Teradata profile (astronomer#1088) `TeradataUserPassword` profile mapping throws below error for mock profile ``` Credentials in profile "generated_profile", target "dev" invalid: Runtime Error Must specify the schema in Teradata profile ``` Closes astronomer#1087
Astronomer Cosmos Version
Other Astronomer Cosmos version (please specify below)
If "Other Astronomer Cosmos version" selected, which one?
1.6.0a1
dbt-core version
1.8.1
Versions of dbt adapters
dbt-teradata 1.8.1
LoadMode
AUTOMATIC
ExecutionMode
VIRTUALENV
InvocationMode
None
airflow version
2.9.2
Operating System
Distributor ID: Ubuntu Description: Ubuntu 22.04.4 LTS Release: 22.04 Codename: jammy
If a you think it's an UI issue, what browsers are you seeing the problem on?
No response
Deployment
Virtualenv installation
Deployment details
Deployed 1.6.0a1 under python3.10 virtual environment
What happened?
cosmos 1.6.0a1 throwing an error with mock profile
raise CosmosLoadDbtException(f"Unable to run {command} due to the error:\n{details}") cosmos.dbt.graph.CosmosLoadDbtException: Unable to run ['/home/airbyte/devtools/cosmos/cosmos-venv/bin/dbt', 'ls', '--output', 'json', '--project-dir', '/tmp/tmp84a8an_e', '--profiles-dir', '/tmp/cosmos/profile/cf3dc9700b875516f605be1e8410b5dc7d9765fe25b7da42140dfc441de87144', '--profile', 'generated_profile', '--target', 'dev'] due to the error: 06:48:04 Running with dbt=1.8.3 06:48:05 Encountered an error: Runtime Error Credentials in profile "generated_profile", target "dev" invalid: Runtime Error Must specifyschemain profileRelevant log output
How to reproduce
airflow standaloneAnything else :)?
No response
Are you willing to submit PR?
Contact Details
[email protected]
The text was updated successfully, but these errors were encountered: