Relational Data View

Foji is a versatile data integration platform that allows you to connect and process data from various sources, including relational databases. This documentation will guide you through the process of configuring a Relational Data View as a data source in Foji. The Relational Data View configuration enables you to define a view on your pre-configured tables and use it as a data source in Foji workflows. To configure the data source, you will need to provide the following fields: Name, Toggle - Enabled, Target Table, Toggle - Append Data to Table, and Query.

Step 1: Accessing Data Source Configuration

1. Log in to your Foji account and navigate to the data sources section.
2. Click on the "Add Data Source" button or select the option to create a new data source.

Step 2: Naming the Data Source

1. In the "Name" field, enter a unique name for your Relational Data View data source. Choose a descriptive name that helps you identify the purpose or characteristics of this data source.

Step 3: Enabling the Data Source

1. Toggle the "Enabled" option to enable the Relational Data View data source. This allows Foji to retrieve data from the view during workflow execution.

Step 4: Selecting the Target Table

1. From the "Target Table" dropdown, select the pre-configured table where you want to store the data retrieved from the view. Ensure that you have already created the target table in Foji using the appropriate schema to match the data structure of the view's results.

Step 5: Toggle - Append Data to Table

1. Enable the "Append Data to Table" toggle if you want to append the retrieved data to the target table during each execution of the workflow. If disabled, the target table will be truncated and refreshed with the new data.

Step 6: Defining the Query

1. In the "Query" field, provide the SQL query that defines the relational view. This query should be structured to retrieve the desired data from the pre-configured tables and any necessary joins or filtering operations. Ensure that the query is valid and returns the expected data structure.

Step 7: Saving the Data Source Configuration

1. After providing the necessary configuration details, click on the "Save" or "Create" button to save the Relational Data View data source configuration.
2. Foji will automatically execute the SQL query defined in the view configuration and retrieve the data from the pre-configured tables.
3. The retrieved data will be stored in the target table, either by appending it to the existing data or replacing it, based on the selected configuration.
4. You can now use this data source in your Foji workflows to process and analyze the data retrieved from the relational view.
5. Contact the Foji support team for more information on utilizing the Relational Data View data source within your workflows.

Conclusion

By following the steps outlined in this documentation, you can configure a Relational Data View as a data source in Foji. This enables you to define a view on your pre-configured tables and utilize it as a data source in your Foji workflows. Leverage the power of relational views to organize and retrieve data efficiently within the Foji platform.

‍