Soham Dasgupta
06/19/2025, 7:07 AMpackages:
- package: dbt-labs/redshift
version: 0.9.0
- package: dbt-labs/codegen
version: 0.13.1
- package: dbt-labs/dbt_utils
version: 1.3.0
- package: starburstdata/trino_utils
version: 0.6.0
- package: elementary-data/elementary
version: 0.18.3
models:
elementary:
+schema: "elementary"
.venv/amzn-hercules-amex/bin/dbt run --select elementary
io.trino.spi.TrinoException: Incorrect timestamp precision for timestamp(6); the configured precision is MILLISECONDS; column name: bucket_start
at io.trino.plugin.hive.HiveMetadata.validateTimestampTypes(HiveMetadata.java:3890)
at io.trino.plugin.hive.HiveMetadata.validateTimestampColumns(HiveMetadata.java:3882)
at io.trino.plugin.hive.HiveMetadata.getNewTableLayout(HiveMetadata.java:3494)
at io.trino.plugin.base.classloader.ClassLoaderSafeConnectorMetadata.getNewTableLayout(ClassLoaderSafeConnectorMetadata.java:135)
at io.trino.tracing.TracingConnectorMetadata.getNewTableLayout(TracingConnectorMetadata.java:557)
at io.trino.metadata.MetadataManager.getNewTableLayout(MetadataManager.java:1098)
at io.trino.tracing.TracingMetadata.getNewTableLayout(TracingMetadata.java:581)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitCreateTableAsSelect(StatementAnalyzer.java:986)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitCreateTableAsSelect(StatementAnalyzer.java:520)
at io.trino.sql.tree.CreateTableAsSelect.accept(CreateTableAsSelect.java:96)
at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:539)
at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:499)
at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:488)
at io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:98)
at io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:87)
at io.trino.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:289)
at io.trino.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:222)
at io.trino.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:892)
at io.trino.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:153)
at io.trino.$gen.Trino_457____20250328_163719_2.call(Unknown Source)
at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)
at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:76)
at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1575)
/* {"app": "dbt", "dbt_version": "1.8.9", "profile_name": "herculesestuary", "target_name": "dev", "node_id": "model.elementary.data_monitoring_metrics"} */
create table "hercules_uadc"."amex_dev_elementary"."data_monitoring_metrics"
as (
select * from (
select
cast('dummy_string' as varchar) as id
,
cast('dummy_string' as varchar) as full_table_name
,
cast('dummy_string' as varchar) as column_name
,
cast('dummy_string' as varchar) as metric_name
,
cast('dummy_string' as varchar) as metric_type
,
cast(123456789.99 as double) as metric_value
,
cast('dummy_string' as varchar) as source_value
,
cast('2091-02-17' as
timestamp(6)
) as bucket_start
,
cast('2091-02-17' as
timestamp(6)
) as bucket_end
,
cast(123456789 as integer) as bucket_duration_hours
,
cast('2091-02-17' as
timestamp(6)
) as updated_at
,
cast('dummy_string' as varchar) as dimension
,
cast('dummy_string' as varchar) as dimension_value
,
cast('dummy_string' as varchar) as metric_properties
,
cast('2091-02-17' as
timestamp(6)
) as created_at
) as empty_table
where 1 = 0
)