What's New in Version 0.9.16

Version 0.9.16 of the relationalai Python package is now available. This release includes the ability to skip invalid rows during data export or query with detailed warnings to improve transparency and troubleshooting.

To upgrade, activate your virtual environment and run the following command:

pip install --upgrade relationalai

New Features and Enhancements

• You can now skip invalid rows during data export or query by using the new skip_invalid_data=True option in the Python API’s query and export methods. When enabled, any rows with invalid data (such as type mismatches or constraint violations) are automatically skipped instead of causing failures.

  Importantly, the system will provide detailed warnings showing which rows were rejected, which columns caused errors, and the specific error messages. This helps you quickly identify and fix data quality issues without silent failures or guesswork.

  Example Usage:

  # Skip invalid data during export
  @model.export("<my_db>.<my_schema>", skip_invalid_data=True)
  def my_export():
      ...
  
  # Skip invalid data during query:
  with model.query(skip_invalid_data=True) as select:
      ...

  Example warning output:

  Your data has been loaded but 2 rows were skipped due to erroneous data. Here are the first 2 rejected rows:
  Rejected record: {"id": "abc", "amount": "not_a_number"}
  - Erroneous column: amount
    Error message: Could not convert value to numeric
  
  Rejected record: {"id": 123, "amount": null}
  - Erroneous column: amount
    Error message: Null value not allowed