Trino 470 Snowflake Open Catalog - No factory for location For S3

[andrewa-habitat]

Setup

• trino helm chart 1.37.0
• trino version 470
• Iceberg REST connector using Snowflake Open Catalog (S3)

My configuration looks like the following:

my_catalog_name: |
    connector.name=iceberg
    iceberg.catalog.type=rest
    iceberg.rest-catalog.uri=https://${ENV:POLARIS_ACCOUNT_LOCATOR}.snowflakecomputing.com/polaris/api/catalog
    iceberg.rest-catalog.security=OAUTH2
    iceberg.rest-catalog.oauth2.credential=${ENV:POLARIS_CLIENT_ID}:${ENV:POLARIS_SECRET}
    iceberg.rest-catalog.oauth2.scope=${ENV:POLARIS_ROLE}:${ENV:POLARIS_SCOPE}
    iceberg.rest-catalog.warehouse=my_catalog_name
    iceberg.rest-catalog.vended-credentials-enabled=true
    
    fs.native-s3.enabled=true
    s3.endpoint=https://my_region.amazonaws.com
    s3.region=my_region
    s3.path-style-access=true
    iceberg.file-format=PARQUET

Context

I can connect to Snowflake Open Catalog using REST configuration. I can list tables, namespaces, schemas, etc. but when a table is read, the following error occurs:

s3://my-bucket-name/my-namespace/my-table-name/data/asd123.parquet is just placeholder for actual path.

java.lang.IllegalArgumentException: No factory for location: s3://my-bucket-name/my-namespace/my-table-name/data/asd123.parquet
	at io.trino.filesystem.manager.FileSystemModule.lambda$createFileSystemFactory$2(FileSystemModule.java:152)
	at java.base/java.util.Optional.orElseThrow(Optional.java:403)
	at io.trino.filesystem.manager.FileSystemModule.lambda$createFileSystemFactory$3(FileSystemModule.java:152)
	at io.trino.filesystem.switching.SwitchingFileSystem.fileSystem(SwitchingFileSystem.java:194)
	at io.trino.filesystem.switching.SwitchingFileSystem.newInputFile(SwitchingFileSystem.java:66)
	at io.trino.filesystem.tracing.TracingFileSystem.newInputFile(TracingFileSystem.java:57)
	at io.trino.plugin.iceberg.IcebergPageSourceProvider.createPageSource(IcebergPageSourceProvider.java:313)
	at io.trino.plugin.iceberg.IcebergPageSourceProvider.createPageSource(IcebergPageSourceProvider.java:249)
	at io.trino.plugin.base.classloader.ClassLoaderSafeConnectorPageSourceProvider.createPageSource(ClassLoaderSafeConnectorPageSourceProvider.java:48)
	at io.trino.split.PageSourceManager$PageSourceProviderInstance.createPageSource(PageSourceManager.java:79)
	at io.trino.operator.TableScanOperator.getOutput(TableScanOperator.java:265)
	at io.trino.operator.Driver.processInternal(Driver.java:403)
	at io.trino.operator.Driver.lambda$process$8(Driver.java:306)
	at io.trino.operator.Driver.tryWithLock(Driver.java:709)
	at io.trino.operator.Driver.process(Driver.java:298)
	at io.trino.operator.Driver.processForDuration(Driver.java:269)
	at io.trino.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:890)
	at io.trino.execution.executor.dedicated.SplitProcessor.run(SplitProcessor.java:77)
	at io.trino.execution.executor.dedicated.TaskEntry$VersionEmbedderBridge.lambda$run$0(TaskEntry.java:201)
	at io.trino.$gen.Trino_470____20250403_173236_2.run(Unknown Source)
	at io.trino.execution.executor.dedicated.TaskEntry$VersionEmbedderBridge.run(TaskEntry.java:202)
	at io.trino.execution.executor.scheduler.FairScheduler.runTask(FairScheduler.java:177)
	at io.trino.execution.executor.scheduler.FairScheduler.lambda$submit$0(FairScheduler.java:164)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
	at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)
	at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:75)
	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)

related issues

• Trino 467 Delta - Error getting snapshot - No factory for location For S3 #24433
• Hive performance regression between 419 and 463 #24099

[gphilipp]

@andrewa-habitat Did you find a fix for this? I'm hitting the same exact error (using Trino with Polaris and Minio).

[gphilipp]

Ok, got it working with:

connector.name=iceberg
iceberg.catalog.type=rest
iceberg.rest-catalog.uri=http://polaris:8181/api/catalog/
iceberg.rest-catalog.warehouse=polariscatalog
iceberg.rest-catalog.vended-credentials-enabled=true
iceberg.rest-catalog.security=OAUTH2
iceberg.rest-catalog.oauth2.credential=root:secret
iceberg.rest-catalog.oauth2.scope=PRINCIPAL_ROLE:ALL

# needed for Trino to read from/write to S3
fs.native-s3.enabled=true
s3.endpoint=http://minio:9000
s3.region=us-east-1