duckdb.cache is not available?

[luqmansen]

Hey, I'm trying the simple cache example from the readme

SELECT duckdb.cache('s3://some_path', 'parquet');

It gives me an error

[42883] ERROR: function duckdb. cache(unknown, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 8

Seems like it's not available in my current extension?

I'm using the latest docker image from dockerhub 17-main with duckdb version 1.3.1

This is all the available duckdb function from my current pg catalog

extname	extschema	proname	proschema
pg_duckdb	public	autoload_extension	duckdb
pg_duckdb	public	create_azure_secret	duckdb
pg_duckdb	public	create_simple_secret	duckdb
pg_duckdb	public	duckdb_alter_table_trigger	duckdb
pg_duckdb	public	duckdb_am_handler	duckdb
pg_duckdb	public	duckdb_create_table_trigger	duckdb
pg_duckdb	public	duckdb_drop_trigger	duckdb
pg_duckdb	public	duckdb_grant_trigger	duckdb
pg_duckdb	public	duckdb_update_extensions_table_seq	duckdb
pg_duckdb	public	enable_motherduck	duckdb
pg_duckdb	public	force_motherduck_sync	duckdb
pg_duckdb	public	install_extension	duckdb
pg_duckdb	public	is_motherduck_enabled	duckdb
pg_duckdb	public	json_in	duckdb
pg_duckdb	public	json_out	duckdb
pg_duckdb	public	json_subscript	duckdb
pg_duckdb	public	load_extension	duckdb
pg_duckdb	public	map_in	duckdb
pg_duckdb	public	map_out	duckdb
pg_duckdb	public	map_subscript	duckdb
pg_duckdb	public	query	duckdb
pg_duckdb	public	raw_query	duckdb
pg_duckdb	public	recycle_ddb	duckdb
pg_duckdb	public	row_in	duckdb
pg_duckdb	public	row_out	duckdb
pg_duckdb	public	row_subscript	duckdb
pg_duckdb	public	struct_in	duckdb
pg_duckdb	public	struct_out	duckdb
pg_duckdb	public	struct_subscript	duckdb
pg_duckdb	public	time_bucket	duckdb
pg_duckdb	public	union_in	duckdb
pg_duckdb	public	union_out	duckdb
pg_duckdb	public	unresolved_type_final	duckdb
pg_duckdb	public	unresolved_type_in	duckdb
pg_duckdb	public	unresolved_type_operator	duckdb
pg_duckdb	public	unresolved_type_operator_bool	duckdb
pg_duckdb	public	unresolved_type_out	duckdb
pg_duckdb	public	unresolved_type_state_trans	duckdb
pg_duckdb	public	unresolved_type_subscript	duckdb
pg_duckdb	public	view	duckdb

Thanks!

[JelteF]

This function has been removed on the main branch. Instead you can now rely on the caching provided by duckdb itself.

[dentiny]

duckdb by default enables external file cache with config enable_external_file_cache: https://duckdb.org/docs/stable/configuration/overview.html#global-configuration-options