What is a Table?

In Raven tables are used to organize and manage incoming data sources. A table is essentially a collection of data that has been organized into rows and columns. Each row represents a single record, and each column represents a specific attribute or piece of information about that record.

Tables in Raven can be created using a variety of data sources, including CSV files, JSON files, and SQL databases. Once a table has been created, you can use filters to query the data it contains.

To create a table you can use Raven Flows or use the Python class.

Once your table is populated with data, you can start using filters to query the data. Filters allow you to search for specific records based on certain criteria, and can help you identify patterns and trends in your data.

In Raven tables are a powerful tool for managing and analyzing data. Whether you are working with small datasets or large, complex datasets, tables can help you organize your data, make sense of it, and use it to make informed decisions.

Creating tables with Python:#

Creating tables with Raven Flows:#

  • A workflow table is created using a Raven Flow.
  • Through use of the flow it enables the table to be periodically updated.

Filters#

When working with filters in Raven, we use PostgreSQL, an extension of the SQL language. Just like in SQL, the WHERE clause can be used in queries to filter the results.

Make sure to use filters that might be passed through the WHERE clause in your code when working with Python tables. This will ensure that you are able to retrieve the data you need.