Adding a New Collection

Click on the Collections tab, and it opens a list of all the collections previously added by you.

Clicking on the Create New Collection button, located on the right corner of the Top Banner allows you to create a new collection.

Name your collection and select your source by clicking on the dropdown icon. The source (where the desired table(s) exist) serves as a repository of information which Ask Neo will utilize to answer your queries. You may add a new data warehouse here (last option in the drop down). Alternatively, you can use an existing data warehouse. When using an existing warehouse, do bear in mind that it is advisable to create a separate service account with read only permissions.

Presently you have the option of selecting among BigQuery, Redshift, Snowflake, MySQL, PostgreSQL, Clickhouse, Azure Synapse, Microsoft SQL Server, and Flat File.

If you want to add a new warehouse, you will be required to enter the details of the data warehouse. Please refer to detailed documentation in the Data warehouses section to know more about each field.

Click Create Collection.

It will open a schema explorer where you can add tables and columns to the collection.

Use the search bar to locate the table where the data resides.

Click on the + icon to add the table

You need to add a description about each of the tables added. Click on [Save] button to save the description.

You also need to add the description and synonyms for the selected columns. You can deselect the column by clicking on the checkbox.

Please go through each of the descriptions to make sure that it is relevant. Remember the more accurate the table descriptions, the better the query results generated.

Use the respective edit icons to configure each of the table(s) and columns added.

Once finished click on Save.

When we have more than one table as part of a collection, it is important to configure relationships among them. A relationship links the data in one table to data in another table. This creates a way to cross reference the two tables. For eg: lets say we have two tables called orders and products. We may use the product_id to link the two tables.

You may add one or more relationships between two tables. However, you must note that with the addition of more tables and more keys, the inter-relationships among tables will become increasingly complex. Including all the data from a warehouse/ too many tables is likely to needlessly complicate the analysis/ query results. Hence, it is advisable to be selective and include only those tables in a collection which are required by the user to carry out the analysis.

To add a relationship, select a field from table 1 and its corresponding field from table 2. Then click on the Add relationship button.

If you want to delete an existing relationship, you can do so using the X icon in the added relationship.

Once finished click on Build KG, located on the top right corner of the main UI screen.

Once Knowledge Graph is finished building, click on Save, located on the top right corner of the main UI screen.