Custom Schema

Our schema is defined SQL and can be found here.

You can extend the schema in the Hasura UI data tab. Currently, the following operations are safe:

  • Adding a field
  • Adding a table
  • Adding a foreign key reference

When adding a field or a table, it is recommended to prefix it with the name of your organization, to avoid any conflict with any future schema changes upstream.

After adding a table, the faros-init container must be run and the Hasura instance restarted. The easiest way of doing this is to simply restart Faros CE.

Once extended, you can leverage those new fields and/or tables by executing GraphQL mutations in Hasura, or extending the Airbyte Faros Destination converters.