Describe the bug
Materialized Views creation in error since 1.10.6 and 1.10.7 release with error message:
Unhandled error while executing
string index out of range
If I force version to 1.10.4, it's OK
Steps To Reproduce
Create or update a materialized view with a DBT job:
{{ config(
materialized = 'materialized_view',
schema = 'core',
catalog = 'datapf_' ~ var('environment') ~ '_featured',
tags = ['test', 'featured']
) }}
SELECT
BA.SourceID,
FROM {{ ref('test') }} BARun the job.
Result:
Unhandled error while executing
string index out of range
1 of 14 ERROR creating sql materialized_view model core.test.... [ERROR in 0.74s]
If the materialized view already exists with the correct definition, no issue, it will just trigger a refresh
Expected behavior
Don't crash and create/update the materialized view:
1 of 14 OK created sql materialized_view model core.test........ [OK in 79.22s]
Screenshots and log output
Unhandled error while executing
string index out of range
1 of 14 ERROR creating sql materialized_view model core.test.... [ERROR in 0.74s]
System information
The output of dbt --version:
Error:
12:41:01 Running with dbt=1.10.6
12:41:04 Registered adapter: databricks=1.10.7
Working fine:
12:41:01 Running with dbt=1.10.6
12:41:04 Registered adapter: databricks=1.10.4
Additional context
Add any other context about the problem here.
Describe the bug
Materialized Views creation in error since 1.10.6 and 1.10.7 release with error message:
Unhandled error while executing
string index out of range
If I force version to 1.10.4, it's OK
Steps To Reproduce
Create or update a materialized view with a DBT job:
{{ config( materialized = 'materialized_view', schema = 'core', catalog = 'datapf_' ~ var('environment') ~ '_featured', tags = ['test', 'featured'] ) }} SELECT BA.SourceID, FROM {{ ref('test') }} BARun the job.
Result:
If the materialized view already exists with the correct definition, no issue, it will just trigger a refresh
Expected behavior
Don't crash and create/update the materialized view:
1 of 14 OK created sql materialized_view model core.test........ [OK in 79.22s]
Screenshots and log output
System information
The output of
dbt --version:Error:
Working fine:
Additional context
Add any other context about the problem here.