What is a source?

A source in Bruinen is a single backing data source that holds information to be used in your ontology. This can be a production database, a data warehouse, an external API, or even CSVs uploaded to the Bruinen application.

There are two types of sources currently supported: “live” and “synced”.

  • Live sources are databases that can be connected via a live connection, meaning that queries are run directly against the backing dataset and no sync is needed.
  • Synced sources are sources that cannot support live connections, either due to system considerations or because the data is impractically large. For these sources, a copy of the data is synced and indexed so that entire tables don’t need to be loaded at query time.

When adding a synced source, you will need to wait for the initial sync to complete before viewing the source’s schema or creating datasets and blueprints based on the source

The sources that are currently supported are listed below:

NameStatusTypeCapabilities
PostgresActiveLiveRead, Write
SnowflakeActiveSyncedRead
MySQLIn progressLiveRead, Write
CSV uploadIn progressSyncedRead

Don’t see a specific source that you’re interested in? Reach out to us at support@bruinen.co

Connection information for the live sources is below:

Creating a source

To create a source, visit your Bruinen dashboard and perform the following steps:

  • Navigate via the sidebar to the Sources tab and hit New Source
  • Select your source type
  • Enter a name for your source and connection details (detailed above) and hit Submit

Once your source has been created, the list of available tables in the source will appear in the central column. Those tables can be used to create datasets in Bruinen’s system.