You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
if i pass schema inside my model either as config parameter({{ config(materialized='table',schema='schema')}}) or as source parameter ({{source('schema','table')}}) , the model fails with the following error. Model 'model.Test_project.model_name' (models/pod_os_stats/model_name.sql) depends on a source named 'schema.table' which was not found
if i remove the schema from source parameter and keep it in the config getting below error dbt.exceptions.CompilationException: Compilation Error in macro oracle__create_schema (macros/adapters.sql)
'relation' is undefined
in macro create_schema (macros/adapters/schema.sql)
called by macro oracle__create_schema (macros/adapters.sql)
if i remove the schema from both config and source parameter simply use the table name it succeeds.
The text was updated successfully, but these errors were encountered:
ThoSap
pushed a commit
to ThoSap/dbt-oracle
that referenced
this issue
May 9, 2022
1. Following macros changed or fixed in adapter.sql to use custom schema name - oracle__create_schema, oracle__create_view_as, oracle__alter_relation_comment, oracle__alter_column_type, oracle__drop_relation, oracle__truncate_relation, oracle__rename_relation, oracle__make_temp_relation
2. Changed view materialization strategy which unncessarily created an intermediate <model>__dbt_tmp view first and renamed it to the target view. Now we directly CREATE or REPLACE view <target_view_name>
3. Added generate_schema_name.sql as per dbt documentation in test project to determine the name of the schema that a model should be built in.
4. Changed a couple of models in the test project to use custom schema
5. Fixes Bug #14
6. Fixes Bug #2
7. Addresses issues raised in PR #15
Hi ,
Model 'model.Test_project.model_name' (models/pod_os_stats/model_name.sql) depends on a source named 'schema.table' which was not found
dbt.exceptions.CompilationException: Compilation Error in macro oracle__create_schema (macros/adapters.sql)
'relation' is undefined
in macro create_schema (macros/adapters/schema.sql)
called by macro oracle__create_schema (macros/adapters.sql)
The text was updated successfully, but these errors were encountered: