Does Anyone know how can I use Elementary with Tri...
# community-support
s
Does Anyone know how can I use Elementary with Trino 457 in dbt?
Copy code
packages:
  - 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
Copy code
models:
  elementary:
    +schema: "elementary"
Copy code
.venv/amzn-hercules-amex/bin/dbt run --select elementary
Copy code
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)
Copy code
/* {"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

    )