Skip to main content

ProphecyManaged connection

iconFree and Professional

Available for the Free and Professional Editions only.

When you first sign in to Prophecy (Free or Professional Edition), you get access to automatically-provisioned Prophecy fabrics. Each fabric includes a default SQL warehouse connection called ProphecyManaged. This connects you to Prophecy In Memory.

This connection provides a ready-to-use environment for running SQL pipelines without additional configuration.

Key features

Review the following features to understand how the ProphecyManaged connection works.

FeatureDescription
Compute & DatabaseEach connection has its own allocated compute resources and database in the warehouse. Prophecy uses a DuckDB warehouse under the hood.
Default SchemaOutputs are written to a schema named default by default. You can change this in the connection settings. AI agents write to the default schema when creating target tables.
ConfigurationConnection details (host, port, credentials) are fixed and cannot be modified.
Knowledge GraphYou can reindex the connection to update the metadata so the AI Agent has current table information.
info

Data cannot be transferred between different ProphecyManaged connections. To share data with other users, add them to the team that owns the fabric with this connection.